The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
4 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
4 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.