Contributor

SQL Table Editor connecting to External Database not working

Forum|Forum|4 years ago
January 27, 2022
4 replies
0 views

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.

Screenshot for SQL Table Editor and it’s not working.

I tried giving the schema name as well but no luck. We are on version 6.4.

Thanks
Sri

Planning

N

NicolasArgente

Veteran

Hi there,

Did you try to put the column format like this ?

S

Sridhar_MAuthor

Contributor

Hi Nicolas,

column format is not required to test the connection. So I didn't include.

S

Sai_Maganti

Newcomer

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.

N

NicolasArgente

Veteran

OR check your SQL statement directly into a data adaptor

C

ckattookaran

Newcomer

Keep in mind that the editor and data adapter works differently. Also, is the user that you are using in the external connection does that user got write access to the tables?