The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
4 years ago

SQL Table Editor connecting to External Database not working

Hi, Can anyone explain why External connection is not working in SQL Table Editor ? The same connection is working for Data Adapter. Screenshot for Data Adapter and it’s working.   Screensh...
planning
Sridhar_M's avatar
Sridhar_M
Contributor
4 years ago

Yes, that user has write access. 

ckattookaran's avatar
ckattookaran
Valued Contributor
4 years ago

What is the error you are getting then? Prior releases won't let you write to a different schema. But I guess you are not on that version.

  • Sridhar_M's avatar
    Sridhar_M
    Contributor
    4 years ago

    I am just trying a connection from Table editor and getting below error. I am on version 6.4. 

     

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      Your data adapter does have aliasing on the SELECT statement. What if you remove the alias as do SELECT * from error_codes? Does that work?

       

      • Sridhar_M's avatar
        Sridhar_M
        Contributor
        4 years ago

        No, I am getting below error message if I don't use fully qualified name (ailas) in Data Adapter.