Topic Thread


Expand all | Collapse all

BluePrism connection with MySQL

Jump to Best Answer
  • 1.  BluePrism connection with MySQL

    Posted 11-20-2019 10:33

    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



  • 2.  RE: BluePrism connection with MySQL
    Best Answer

    Posted 11-20-2019 12:01
    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/
    ------------------------------



  • 3.  RE: BluePrism connection with MySQL

    Posted 11-20-2019 12:06
    Forgot to attach VBO. Please find

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



  • 4.  RE: BluePrism connection with MySQL

    Posted 11-20-2019 12:46
    Thanks Vivek, appreciate the quick revert.

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



  • 5.  RE: BluePrism connection with MySQL

    Posted 11-21-2019 16:06
    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
    ------------------------------



  • 6.  RE: BluePrism connection with MySQL

    Posted 11-21-2019 16:11
    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/
    ------------------------------



  • 7.  RE: BluePrism connection with MySQL

    Posted 11-22-2019 07:10

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



  • 8.  RE: BluePrism connection with MySQL

    Posted 11-25-2019 04:30
    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/
    ------------------------------



  • 9.  RE: BluePrism connection with MySQL

    Posted 11-25-2019 05:22
    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
    ------------------------------



  • 10.  RE: BluePrism connection with MySQL

    Posted 11-25-2019 05:41
    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/
    ------------------------------



  • 11.  RE: BluePrism connection with MySQL

    Posted 12-20-2019 00:13
    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
    ------------------------------



  • 12.  RE: BluePrism connection with MySQL

    Posted 10-12-2020 11:00
    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
    ------------------------------



  • 13.  RE: BluePrism connection with MySQL

    Posted 10-12-2020 13:14
    @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
    ------------------------------



  • 14.  RE: BluePrism connection with MySQL

    Posted 10-12-2020 13:48
    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
    ------------------------------