topic RE: BluePrism connection with MySQL in Product Forum

BluePrism connection with MySQL

DiyaPaul — Wed, 20 Nov 2019 10:33:00 GMT

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

RE: BluePrism connection with MySQL

vivek.kumar.goel — Wed, 20 Nov 2019 12:01:00 GMT

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/
------------------------------

RE: BluePrism connection with MySQL

vivek.kumar.goel — Wed, 20 Nov 2019 12:06:00 GMT

Forgot to attach VBO. Please find

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

RE: BluePrism connection with MySQL

DiyaPaul — Wed, 20 Nov 2019 12:46:00 GMT

Thanks Vivek, appreciate the quick revert.

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

RE: BluePrism connection with MySQL

DiyaPaul — Thu, 21 Nov 2019 16:06:00 GMT

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
------------------------------

RE: BluePrism connection with MySQL

vivek.kumar.goel — Thu, 21 Nov 2019 16:11:00 GMT

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/
------------------------------

RE: BluePrism connection with MySQL

DiyaPaul — Fri, 22 Nov 2019 07:10:00 GMT

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
------------------------------

RE: BluePrism connection with MySQL

vivek.kumar.goel — Mon, 25 Nov 2019 04:30:00 GMT

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/
------------------------------

RE: BluePrism connection with MySQL

DiyaPaul — Mon, 25 Nov 2019 05:22:00 GMT

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
------------------------------

RE: BluePrism connection with MySQL

vivek.kumar.goel — Mon, 25 Nov 2019 05:41:00 GMT

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/
------------------------------

RE: BluePrism connection with MySQL

ewilson — Fri, 20 Dec 2019 00:13:00 GMT

FWIW - There is a MySQL utility available on the Digital Exchange. Have you tried it?

https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism---mysql-utility

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: BluePrism connection with MySQL

kirtish.trivedi — Mon, 12 Oct 2020 10:00:00 GMT

Hi Eric,

While importing the MySQL release , I m getting error "An error occurred while attempting to import the release:
Element 'release' with namespace name 'http://www.blueprism.co.uk/product/release' was not found. Line 7, position 2."

Could you please assist on this ? Also I am using Blueprism 6.3 hence wanted to confirm if this is related to Blueprism Version ?
Thanks

------------------------------
Kirtish Trivedi
------------------------------

RE: BluePrism connection with MySQL

ewilson — Mon, 12 Oct 2020 12:14:00 GMT

@Kirtish Trivedi I think you have a corrupted file. Pease see the linked post about how to download assets from a Blue Prism GitHub repository to ensure you have a clean, XML-only, file.

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=385&MessageKey=516d01d6-82b1-473b-8e69-057c50e9fb51&CommunityKey=1e516cfe-4d1f-4de9-a9eb-58d15bf38c81&tab=digestviewer&ReturnUrl=%2fcommunity-discussions%2fallrecentposts

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: BluePrism connection with MySQL

kirtish.trivedi — Mon, 12 Oct 2020 12:48:00 GMT

Hi Eric,

Thanks for the assist !!

Yes this resolved my issue. I was not downloading the file properly. Thanks for the clarification

Thanks

------------------------------
Kirtish Trivedi
------------------------------