Forum Discussion

darpan13's avatar
darpan13
Contributor
4 years ago

SQL Table Editor - Query - External DataBase

SOURCE: ONESTREAM CHAMPIONS Hi Team, do we need to put some specific settings to connect the External DataBase… when we are connecting it via SQL Table Editor. i am getting the below mentioned ...
Dashboards
darpan13's avatar
darpan13
Contributor

Understood Terry,

Let me speak to One Stream team on the same , we do not have access to create New External DB Connection.

but as per my understanding creating new DB connection and changing the Default Schema should resolve this issue.

this issue is not per OLE DB or ODBC.

let me try both the options and confirm.

Regards

Darpan

scottr's avatar
scottr
New Contributor III
4 years ago

In version 6.2 it works. these are my settings.

 

image
  • darpan13's avatar
    darpan13
    Contributor
    4 years ago

    Yeah so that’s the catch… Schema name. table name doesn’t works in sQL Table Editor.