Skip to main content
R
raphaeln0001
August 23, 2023
Question

SQL Server Record Types

  • August 23, 2023
  • 1 reply
  • 0 views

Was the issue with Appian being unable to select the scheme in SQL server for recorded types/data stores resolved in 23.3?   Is there an ETA when this issue will be resolved.   This really slows down development on my team and makes appian much harder to use if you are pointing it to a database that has multiple schemes on it.  

1 reply

ignacio.moran
ignacio.moran
August 24, 2023

Hi Raphael, currently this has not been solved. You  need to create different database users, each of them with a different default schema selected. Then create the connected systems with each user to have access to each schema. Later on, when creating the CDT/Record, select the corresponding connected system to connect the table you would like to use in each schema. 

This problem occurs with SQL Server, but with Mariadb or Postresql, you could point to the schema needed in the URL defined in the connected system, it won't be needed to have a user with a default schema associated.

Terms & ConditionsAccessibility statement