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

[ewilson]

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

[KirtishTrivedi]

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

[ewilson]

@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=dig...

Cheers,
​

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

[KirtishTrivedi]

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