Skip to main content
Newcomer
January 12, 2022

SQL Table Editor - Query - External DataBase

  • January 12, 2022
  • 1 reply
  • 0 views

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 )

darpan13_0-1642017867259.png

 

Subledgers _ External.png977×467 21.7 KB

 

Regards and Thanks

Darpan Bhansali

    1 reply

    Newcomer
    January 12, 2022

    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.

    https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/8e28c9c465eadae044ac0b8e923dd45fd61b4b7d.png
    image.png700×162 3.67 KB
    darpan13Author
    Newcomer
    January 12, 2022

    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

    Newcomer
    January 12, 2022

    https://onestreamchampions.influitive.com/forum/u/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?