I have a use case to connect to MySQL databases and write data into them using BluePrism. I researched on this and found that Data - OLEDB action can be leveraged with the following connections strings.
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
Replacing the values for db_name, db_user, and db_password with my own.
Has anyone explored this or other alternatives for writing into MySQL?
I have tried the following queries:
Select distinct * from surveil.actions_db_CH
I tried one with a semi colon and one without, but all populate no results. Initially, I was getting an error
"SSL Authentication Error - A call to SSPI failed, see inner exception."
But I made a change to the code stage in the object, specifying the following in the connection string w.r.t. sslmode:Dim connString As String = "server="+Server+";uid="+Username+";pwd="+Password+";database="+DBName+";sslmode=none"This helped the model run successfully through till completion, however results are not getting populated.I spoke to the stakeholder and he mentioned that it is probably because of the connection method, but because there is no confirmation w.r.t. connection status I cannot be sure of this either.