RM Studio 9.5.001 - New Connection SQL Server - tables not showing

New Altair Community Member
Updated by Jocelyn
I just got a new win10 rebuild and installed RM 9.5.001 -- I went to add my new connection (vs the old legacy method) to a 2017 SQL Server. I connected with following URL
(Note - I replaced my real server and db name in string)
jdbc:sqlserver://SQLSERVER:1433;databaseName=MYDBNAME;integratedSecurity=true
I have a Local Repository-->Connection-->MYSQLServer_Connection - I can pass the TEST CONNECTION and I am able to +Import a data table.
In my prior version of RM Studio, I was able to use down arrow on the DBName to see all my tables and then access them via retrieve. When I pull in the retrieve operator now, I just see the MYSQLServer_Connection and no way to get to the data.
I assume I am not using the right driver or something -- PLEASE HELP.
thanks...litia
(Note - I replaced my real server and db name in string)
jdbc:sqlserver://SQLSERVER:1433;databaseName=MYDBNAME;integratedSecurity=true
I have a Local Repository-->Connection-->MYSQLServer_Connection - I can pass the TEST CONNECTION and I am able to +Import a data table.
In my prior version of RM Studio, I was able to use down arrow on the DBName to see all my tables and then access them via retrieve. When I pull in the retrieve operator now, I just see the MYSQLServer_Connection and no way to get to the data.
I assume I am not using the right driver or something -- PLEASE HELP.
thanks...litia
Sort by:
1 - 3 of
31

New Altair Community Member
Updated by Marco_Boeck
Hi,
The DB repository was quite frankly very broken in many cases, and is therefore not supporting the new connections and will be dropped eventually.
Regards,
Marco
The DB repository was quite frankly very broken in many cases, and is therefore not supporting the new connections and will be dropped eventually.
Regards,
Marco
Sort by:
1 - 1 of
11

New Altair Community Member
Accepted Answer
Updated by Marco_Boeck
Hi,
You can still do it, e.g. like this:


Make sure you select "table name". You may need to press the refresh button next to the dropdown once.
Regards,
Marco
You can still do it, e.g. like this:


Make sure you select "table name". You may need to press the refresh button next to the dropdown once.
Regards,
Marco
You can still do it, e.g. like this:
Make sure you select "table name". You may need to press the refresh button next to the dropdown once.
Regards,
Marco