How to connect to columnar DB?
9 November, 2015
Hello,
We are working in YF version 7.1 build 20150922 and we have a tabular data base in the Microsoft SQL server. How we can create a connection to these data source through Yellowfin?
Regards,
Tina
We are working in YF version 7.1 build 20150922 and we have a tabular data base in the Microsoft SQL server. How we can create a connection to these data source through Yellowfin?
Regards,
Tina
Hello Tina,
This should be pretty painless. I've included the link below from our Wiki that covers adding
a data source connection.
Data Sources
Once you've read through this (please click on the Source Connection Parameters link as well) information, let us know
if you have any specific questions.
Thank you,
Kyle
This should be pretty painless. I've included the link below from our Wiki that covers adding
a data source connection.
Data Sources
Once you've read through this (please click on the Source Connection Parameters link as well) information, let us know
if you have any specific questions.
Thank you,
Kyle
Hi Kyle,
Thank you for your help. I have tried to learn it but I need to know all details please.
I have attached some screen shot with a details of connection. Could you look at please on
this picture and explain step by step. I am sure that should be any details what I am doing
wrong here.
Thank you
Tina
Thank you for your help. I have tried to learn it but I need to know all details please.
I have attached some screen shot with a details of connection. Could you look at please on
this picture and explain step by step. I am sure that should be any details what I am doing
wrong here.
Thank you
Tina
Hello Tina,
Unfortunately this error simply means it wasn't able to connect to the database.
There could be many reasons why it can't connect, and is usually due to SQL configuration.
Are you able to ping the ip address?
You may be having connection issues due to SQL not listening to incoming connections.
You can check this by running 'netstat -an' in the command prompt.
You should see something similar to the screen below:
Are you able to test the connection by using a free 3rd part DB tool such as DB visualizer or SQL Squirrel to connect to the DB? If you aren't able to connect with one of these then we will know it's not a YF specific issue and is likely a configuration or permission issue with your server.
Please let me know what you find.
Thank you,
Kyle
Unfortunately this error simply means it wasn't able to connect to the database.
There could be many reasons why it can't connect, and is usually due to SQL configuration.
Are you able to ping the ip address?
You may be having connection issues due to SQL not listening to incoming connections.
You can check this by running 'netstat -an' in the command prompt.
You should see something similar to the screen below:
Are you able to test the connection by using a free 3rd part DB tool such as DB visualizer or SQL Squirrel to connect to the DB? If you aren't able to connect with one of these then we will know it's not a YF specific issue and is likely a configuration or permission issue with your server.
Please let me know what you find.
Thank you,
Kyle