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 error ( where as the same connection works via Data Adaptor )

 

Subledgers _ External.png977×467 21.7 KB

 

Regards and Thanks

Darpan Bhansali

  • 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

      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

        @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?