Hi All,
We trying to connect to an external connection from another system. Though we are already connected, the tables we are looking for is not there. Upon checking, there are more than 2 schema available on their database, the schema that the tables we want is not the one showing on the recordType "choose database table" instead the other one.
Additional Info, when creating a CDT and verifying it on Data Store, other schema and its table cant be map ( "no match table found"), however its verified for all tables under the schema that is appearing on recordType "choose database table"
Can you advice if this support is on Appian Admin, or is it on the external side system to make the correct schema adjustment to be selected as default. Thanks
Discussion posts and replies are publicly visible
The schema is defined in your connection string. You'll need to either create another DB connected system or create another data source in the admin console.
Hi,
this is because the user they have in the connected system / source in admin console to connect to their database has as default schema the other one. On their side, they should create another user whose default schema is the one that contains the tables you would like to use, after that, create a new connected system / source in admin console with this user and then use it to create the CDT or record.
You don't absolutely need to create a separate user to access the schema if this is an external system.
As long as the DB user has access to both schemas, all you have to do is include the schema in the connection string.
jdbc:mariadb://such_as_server.example.com:3306/schema_name?useOldAliasMetadataBehavior=true
Hi Mathieu, I think that is not possible for all the databases types, possible for Mariadb and Postgresql, but for example, I can not find how to do it for SQL server. Do you know how it would be for this case? Thanks in advance
I haven't tried SQL Server but it should be possible. In the documentation, they have examples with the schema name in the connection URL for the different types of databases.
Hi All, was able to fix this by applying this script on Postgresql,
"ALTER ROLE <user_name> IN DATABASE <db_name> SET search_path TO "$user", <schema_name_u_Want_to_change>;"