We would like to be able to access many schemas in Appian when creating a record type from a sql server table. I have the table created on the server that is in or datasource in the admin console but when I got to select the table in the record type I only see tables that exist in the dbo schema
Discussion posts and replies are publicly visible
Has anyone managed to connect a DataSource to an SQL Server schema other rthan .dbo?
https://stackoverflow.com/questions/3282665/possible-to-set-default-schema-from-connection-string
YOU should have to create another datasource in admin console... when created, you will be able to work against the tables contained in the other schemas
I don't see anywhere to specify schema when setting up the datasource in the admin console.
Correct. Appian will always use the default schema of the user.
Because you have to select your schema in your connection string... You can't select it from admin console, default user schema will be used in your connection.
Thank you I will have one of my database admins to check the user to see what the default schema is set to.