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
    Edited by Vivek Goel 9 days ago
    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
    ------------------------------