• State Suggested Answer
  • +2 person also asked this people also asked this
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 14 subscribers
  • Views 5001 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Has anyone managed to connect a DataSource to an SQL Server schema other rthan .dbo?

ianb0001

Hi all

I have a cloud implementation of Appian and am trying to connect through to  a local SQL Server 2016 server. I can do this fine and connect a datastore to tables in the .dbo schema  but don't appear to be able to connect to tables in any other schema - the datastore just doesn't allow any connections to be established to anything other than .dbo. There are pieces of documentation that suggest that this should be possible and some referring to synonyms but none appear to work for me

 

Has anyone else succeeded in doing this?

 

Many thajs 

  Discussion posts and replies are publicly visible

Parents
  • 0
    We are facing the same issue and trying to figure out how to configure connecting to a specific schema other than the dbo (default schema). When we created a XSD in the normal way (without mentioning any schema name in the annotation) and tried to publish the data store (for the intended data source that has multiple schema in a single database) we are getting the error 'Missing column a_id'
Reply
  • 0
    We are facing the same issue and trying to figure out how to configure connecting to a specific schema other than the dbo (default schema). When we created a XSD in the normal way (without mentioning any schema name in the annotation) and tried to publish the data store (for the intended data source that has multiple schema in a single database) we are getting the error 'Missing column a_id'
Children

© 2024 Appian. All rights reserved.