Skip to main content
allenp0001
allenp0001
Known Participant
October 3, 2022
Solved

Connected System - Appian DB (Maria)

  • October 3, 2022
  • 2 replies
  • 0 views

I am having difficulty utilizing the "Connected System" and connecting to the Appian DB.

I have verified we have a Maria DB and that the database name is Appian.  I think I have the server name correct, but not 100% sure.

Would the server name be the same as the appian website.... companytest.appiancloud.com:3306?

I know it is already available as a Data Type "Topcat" but I am trying to execute a stored procedure on the DB.

Thank you

Best answer by nathanp119

Hi [mention:823f1931e3e34d3ab5fe3af388fb6fc1:e9ed411860ed4f2ba0265705b8793d05], if using the execute store proc smart services against the Appian MariaDB you can set the name as text "jdbc/Appian" rather than a connected system. I've confirmed this is working in Appian 22.3

2 replies

N
nathanp119Answer
October 3, 2022

Hi [mention:823f1931e3e34d3ab5fe3af388fb6fc1:e9ed411860ed4f2ba0265705b8793d05], if using the execute store proc smart services against the Appian MariaDB you can set the name as text "jdbc/Appian" rather than a connected system. I've confirmed this is working in Appian 22.3

    prafuls972
    prafuls972
    October 4, 2022

    Hi [mention:823f1931e3e34d3ab5fe3af388fb6fc1:e9ed411860ed4f2ba0265705b8793d05], you can do 3 things

    • if you are connected to the Appian database which is the default database then you can use connection string as "jdbc/Appian".
    • If you have created a new schema in MariaDB using AppianProcess.createNewSchema('customSchema') then create the connection to this schema using a connected system then store this connected system in constant of type connected system. Then pass this constant in the connection string. 
    • If you have created a new schema in MariaDB using AppianProcess.createNewSchema('customSchema') then create the connection to this schema using Admin console -> datasource-> define new data source. Whatever name you have defined in the data source will be used in data connection. i.e. "jdbc/CustomSchema"
      Terms & ConditionsAccessibility statement