Skip to main content
zacharyb8201
zacharyb8201
August 26, 2024
Solved

SQL Server datasource access schema other than dbo

  • August 26, 2024
  • 6 replies
  • 0 views

We would like to be able to access many schemas in Appian when creating a record type from a sql server table. I have the table created on the server that is in or datasource in the admin console but when I got to select the table in the record type I only see tables that exist in the dbo schema

    Best answer by stefanhelzle0001

    Correct. Appian will always use the default schema of the user.

    6 replies

    R
    rishirajk1074
    August 27, 2024

     [mention:d2e7592ed41245609a58e1a07db6efb6:46448885d0e64133bbfbf0cd7b0fd6f7] 

    https://stackoverflow.com/questions/3282665/possible-to-set-default-schema-from-connection-string

    davidj137213
    davidj137213
    August 27, 2024

    YOU should have to create another datasource in admin console... when created, you will be able to work against the tables contained in the other schemas

    zacharyb8201
    zacharyb8201Author
    August 28, 2024

    I don't see anywhere to specify schema when setting up the datasource in the admin console.

    stefanhelzle0001
    stefanhelzle0001Answer
    August 29, 2024

    Correct. Appian will always use the default schema of the user.

      Terms & ConditionsAccessibility statement