Skip to main content
T
tomj8549
August 22, 2023
Question

Unable to map the other schema from RecordType

  • August 22, 2023
  • 6 replies
  • 0 views

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

6 replies

mathieud0001
mathieud0001
Brainy
August 22, 2023

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.

ignacio.moran
ignacio.moran
August 22, 2023

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. 

mathieud0001
mathieud0001
Brainy
August 22, 2023

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

[View:https://docs.appian.com/suite/help/23.3/Configuring_Relational_Databases.html]

    ignacio.moran
    ignacio.moran
    August 22, 2023

    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

    T
    tomj8549Author
    August 23, 2023

    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>;"

      Terms & ConditionsAccessibility statement