In configure Query Database window when Iam trying to set Mysql driver Iam facing the above error,Could anyone help me with this issue??
are you connecting to an external Database? - I am not sure if you can do that with an appiantrail.
If you are trying to connect to the trail database, the normal thing to do is to use the Data Store
As an aside I think use of the Query Database Smart Service is discouraged as it will appear in the Healthcheck Reports as
The Query Database node is used X times in all process models. Query rules and CDT-based data store updates are the preferred method of database interaction.
So it might be better to use query entity instead.
Sorry for the missunderstanding, what I mean is that you should create a new object type "Data Store", then what you usually do to query the DB is you have a Expression rule that uses a!queryEntity
You have some examples here: https://docs.appian.com/suite/help/20.1/Query_Recipes.html
Anyways, I would encourage you to do the appian academy training or read the documentation regarding how to read or write data in teh data store entities and then use those nodes
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.