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.
Discussion posts and replies are publicly visible
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.