Forum Discussion

darpan13's avatar
darpan13
Contributor
3 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
TerryLedet's avatar
TerryLedet
New Contributor III

You may have already done this; however, if you have not… set the Database Location to External and then select the appropriate External Database Connection.

image
image.png700×162 3.67 KB
darpan13's avatar
darpan13
Contributor
3 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
    3 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
      3 years ago

      Hi Michael,

      Please find it attached here 

       

       

      Regards and Thanks

      • NicolasArgente's avatar
        NicolasArgente
        Valued Contributor
        3 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.