We have an in-house SQL Server database. Established the connection to the SQL Server Database and tried to create the custom data type. Steps as follows...
1. Logged into Admin Console.. Under Data Sources section, I tried to create new sql server connection.
2. I setup the JDBC connection to use the schema as some other schema where my tables exist instead of default dbo schema.
3. Then I go to my application, try to create new Custom Data Type; Option I chose is to build the Custom Data Type based on the existing tables.
4. When I do the above step, I can see only the database tables part of dbo schema and not the tables from my own schema.
Can you advise what configuration is needed to enable the data source connection to look into the specific schema and not the default schema?
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.