BluePrism connection with MySQL

[DiyaPaul]

Hi,

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?

Thanks

Diya

[VivekGoel · Accepted solution]

Place the DLL files attached in your Blue Prism Installation folder and then use the attached VBO.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[VivekGoel]

Forgot to attach VBO. Please find

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[DiyaPaul]

Thanks Vivek, appreciate the quick revert.

------------------------------
Diya Paul
Automation Specialist
S&P Global Market Intelligence
Asia/Kolkata
------------------------------

[DiyaPaul]

Hi Vivek et al,

I tried using the advised model however I am not getting results (empty) when I run any query. I need to use the Connection Method : Standard TCP/IP over SSH to connect to MySQL, I believe this could be the reason why this isn't working.

Any thoughts on this?

Thanks
Diya


------------------------------
Diya Paul
Automation Specialist
S&P Global Market Intelligence
Asia/Kolkata
------------------------------

[VivekGoel]

I believe you have put semi colon at the end of query.

Please don't use any .

If possible send the query so that i can advise better.

Do also send a screenshot if you are getting any error.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[DiyaPaul]

I have tried the following queries:

Select distinct * from surveil.actions_db_CH

show processlist

show tables;

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.

------------------------------
Diya Paul
Automation Specialist
S&P Global Market Intelligence
Asia/Kolkata
------------------------------

[VivekGoel]

Hi Diya,

I am actually  a bit surprised. If I faced such an issue, I would run the same on workbench and then try to run the query in BP (Minux the Semi Colon), that should give me a fair bit of idea.

The only problem I faced using such method is when date calculations are involved. . Otherwise it shd be fine

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[DiyaPaul]

Let me play around with this a bit more Vivek. Any clue about the connection method and how to make that specification in the code? Did you use Standard TCP/IP over SSH to connect to MySQL?

------------------------------
Diya Paul
Automation Specialist
S&P Global Market Intelligence
Asia/Kolkata
------------------------------

[VivekGoel]

It was indeed standard TCP/IP over Ssh..

I just checked if my Resource can connect to the MySQL via workbench. If yes, then I placed the DLLs in the BP folder and ran the mySQL code directly.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------