Question

How to make DB connection url string as Text

Forum|Forum|1 year ago
September 13, 2024
6 replies
0 views

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?

vinaykumarp8308

Participating Frequently

[mention:ed111c1e5981406186496b36b93e5bf0:e9ed411860ed4f2ba0265705b8793d05]

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.

kumara0180

Hi [mention:ed111c1e5981406186496b36b93e5bf0:e9ed411860ed4f2ba0265705b8793d05] ,

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.

Y

yogip3177

You need to give the data source name:

stefanhelzle0001

Did you try this?

https://docs.appian.com/suite/help/24.3/fnc_system_a_getDataSourceForPlugin.html

S

shababh0001Author

Thank you so much everyone !

https://docs.appian.com/suite/help/24.3/fnc_system_a_getDataSourceForPlugin.html

This solution worked for me .

davidj137213

If you need to connect via Connected System, you should use the function referred by [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]

Sign up

Login with SSO

Login to the community

Login with SSO