Skip to main content
nicholaso0002
nicholaso0002
August 5, 2022
Question

Using Active Directory Service Account to Connect to Business Data Source in Appian

  • August 5, 2022
  • 4 replies
  • 0 views

Hello team,

What is the format for connecting an SQL business data source using a an Active Directory Account

Thank you

    4 replies

    L
    lakshmirajas0001
    August 6, 2022

    Hi [mention:9f686c32b1594769a1d1de53c1629d1c:e9ed411860ed4f2ba0265705b8793d05] 

    Few points I can think of:

    Create a schema in SQL using command Then sql(Cloud DB) will auto generate url, username, password as well
    Now add that schema in Admin Console of your environment using those url, username, password generated by Sql(Cloud DB) click on testConnection connection will be successful
    Finally Now your are good to create a DataStore for specific application Someone please correct me if I'm wrong here.

    nicholaso0002
    nicholaso0002Author
    August 6, 2022

    The SQL Database in on-premise not cloud.

    How can this be achieved.

    Thanks

    L
    lakshmirajas0001
    August 6, 2022

    Yes we can do the same for MySql As well

    Like you know, Create a schema in Mysql give grant permissions for that schema + (ddl, dml...etc) permissions with this you need to have MySql username & password for configuring userName then password in AdminConsole

    Now add that credentials in Admin Console of your environment

    Finally your good to create dataStore now. Someone please correct me if I'm wrong here.

    Terms & ConditionsAccessibility statement