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
4 years ago

Hi Terry,

i tried the above but it’s not working… i have OS 5.3 as of now.

it shows me error (mentioned above ) when i connect via above.

did you try connecting it on your OS , if yes, please share any screenshot for reference.

Regards and Thanks

Darpan Bhansali

MichaelSBrokaw's avatar
MichaelSBrokaw
New Contributor III
4 years ago

@darpan.bhansali From the error message, may you select the ellipsis box at the bottom left and copy the error text from that to this thread for review?

  • darpan13's avatar
    darpan13
    Contributor
    4 years ago

    Hi Michael,

    Please find it attached here 

     

     

    Regards and Thanks

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor
      4 years ago

      Hi Darpan,
      Have you tried your query in a data adaptor first? What is the error?
      Is the DB on the same server? If not, you will need to add a connection using the DB manager but it is only done at server level. You can not do this as an admin from the GUI.

      • darpan13's avatar
        darpan13
        Contributor
        4 years ago

        Hi Nicolas,

        Yeah the same connection works with Data Adaptor.

        As per discussions with onestream team, with OS 5.3 ,

        It is possible to use the SQL Table Editor with an external connection if the schema is not required to be included in the table name property. If it is required, then a schema property is available in the SQL Table Editor component from 6.1

        So i think we have a dead end here.

        Regards and Thanks

        Darpan Bhansali.