trying to connect to multiple Microsoft SQL databases

Avatar
Permanently deleted user
Created

I am trying to connect to Dev, QA, and Production databases.....However All the data sources seem to just duplicate the same connection regardless of changing settings. I end up with the same database listed on all data sources even though they are different. All the counts (tables 575) is the same in all the sources even thought the sources are supposed to be pointing at different databases and I know they are different in reality. This makes the product un usable because I can not manage more than one database. even if I clear out all the data sources and try to work on each database separately is seems to save the settings and will not even pull up the correct database. very frustrated because this tool should help me. But working on one database is not what I need to do.

Votes

0

Share

3 comments
Avatar
Permanently deleted user
Created

Example the tab is the FlightOps database on sguqa01  however the sql that runs...is pulling data from skydata@skydatadev01 there is no table listed under flightops in the left hand side.... all the counts on the two databases is the same...they should not be....NOTHING on this page makes sense. Only one of the datasources is correct but you can not tell which one. I must be doing something wrong because I assume more than one person uses this.

 

0
Avatar
Charles Wise
Created

If you aren't already, include the database name in your database definition, e.g., the URL for your database connection should look something like this: jdbc:sqlserver://myserver:1433;databaseName=mydatabase

I use SQL Server for work and have many different connections to many different databases, some on the same physical database server. Everything works as expected.

0
Avatar
vasily chernov
Created

Hi,

Currently,  you no need to define a database in URL, you'll be connected to your default database and then feel free to choose what ever you want:





Thank you.

0

Please sign in to leave a comment.