Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
3 years ago

SQL Table Editor connecting to External Database not working

Hi, Can anyone explain why External connection is not working in SQL Table Editor ? The same connection is working for Data Adapter. Screenshot for Data Adapter and it’s working.   Screensh...
Planning
Sai_Maganti's avatar
Sai_Maganti
Contributor II
3 years ago

I think the problem is the SQL Table Editor doesn't know what the database is but in your SQL Query for the data adapter you're using the fully qualified name ([dbname.schemaname.tablename]) assuming OneStream_Automation is your database name. It might be the db connection is set up only to the server. Check with your OneStream support and they will help you out.