• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Subscribers 13 subscribers
  • Views 4927 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

Adding Schema in datasources in standalone for SQL Server DB

vipins

I want to add an schema directly in standalone so that it reflect in data source directly for SQL Server DB. By default it connects to dbo (default) schema but user requirements want other schema to map directly. Mapping schema in standalone will help in creating CDTs from Table/View directly belonging to that schema.

 

Above image shows that we can't select the schema under Data source, new data source has to be defined for that.

 

Tell me the piece of code which I need to add in below standalone in datasource code to map schema directly.

 

I already know that Schema can be mentioned in XSD and then also it will work and also checked KB-1111 "No matching tables found!" error thrown after verifying entity mappings even though the tables exist

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    As far as I know, you can only select a specific database for a given server in the connection string, and not a schema. Since a default schema can be assigned to user, I think the best thing to do is create a NEW connection, using credentials of a user that has a default schema other than dbo. I will not I am not an expert on this side of DB management, so hopefully someone else will add their thoughts.
Reply
  • 0
    Certified Lead Developer
    As far as I know, you can only select a specific database for a given server in the connection string, and not a schema. Since a default schema can be assigned to user, I think the best thing to do is create a NEW connection, using credentials of a user that has a default schema other than dbo. I will not I am not an expert on this side of DB management, so hopefully someone else will add their thoughts.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.