How to make DB connection url string as Text

Question

Hi 
 I am using Import Excel to Database Smart service and for Datasource I tried to make connection using Connected System .I called the CS in constant using CS as its type .But in Import excel smart service , 
 Datasource is defined Text type . Is it possible to give DB connection url string as Text and pass it in constant and then use it . If yes then what is correct connection url string?

vinaykumar · Answer

Shabab Hassan 
 It would be the data source name or resource name similar to " jdbc/Appian " - Configuring Relational Databases - Appian 24.3 
 As you mentioned, create a text constant for the same and use it in the data source input.

Kumar Agniwesh · Answer

Hi Shabab Hassan , 
 Lets say you are trying to upload the data in mariaDB, then you would need to pass "jdbc/Appian". If you have created a connection to other DB using connected system, then this value needs to be the name of that connected system. If the connection has been done using admin console then it would be name you have given there. Hope this helps.

How to make DB connection url string as Text

Top Replies