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?
Discussion posts and replies are publicly visible
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.
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.
You need to give the data source name:
Did you try this?
https://docs.appian.com/suite/help/24.3/fnc_system_a_getDataSourceForPlugin.html
If you need to connect via Connected System, you should use the function referred by Stefan Helzle
Thank you so much everyone !https://docs.appian.com/suite/help/24.3/fnc_system_a_getDataSourceForPlugin.html
This solution worked for me .