Hi Community,
I am facing an issue while uploading the excel file using the (Import Excel to Database ) smart service in one of the process , Could you please provide some inputs why this is occurring as we have already configured with correct business DB, Error has been attached as below,
Discussion posts and replies are publicly visible
Hi harshadd0001,
If you are using data source connected systems, then use a!getDataSourceForPlugin() Function - Appian 24.2 function in data Data source name field.
If you are using basic Appian Maria DB, then use "jdbc/Appian"
Hi Yogi,
have attached screenshots for your reference, DS name is same only the difference i see into the JDBC driver version.
new infra - DS
old infra -DS
Hi Sri Ram Kaja,
Not using the Connected System, we have configured the DS in console Admin level as we are still able to read and write operations by using same DS in same process.
Are you able to write data to DB using write to data store entity? if yes, then some configuration issue with import excel, if you are not able to do then there might be issue at connectivity level.
Hi All,
This issue has been resolved, the issue which we suspected earlier that is correct. Configuration is required at host level for business DS. its working fine now. Thank you all for your help and support.
Pls advise , Do we need to create data store and entity and cdt to use this smart sevice , our application uses record centric , do we need to have cdts for import excel to db ?
That function writes directly to the DB table. For writing, you do not need a CDT.