Robotic Process Automation (RPA)

 View Only
  • 1.  How do I set-up a DB Connection in RPA Studio 20.12.5

    Posted Wed June 23, 2021 12:09 PM
    Edited by DAVID Jenness Wed June 23, 2021 12:09 PM
    Hello Hello, 

    I have my DB connections set-up in QMF as well as DB2 for SPSS. How do I set-up the same DB connections I use in these tools in RPA Studio.  I watched the videos and searched in Google but none of my connection strings work. 

    For example, I tried an ODBC Connection as Server=jdbc:db2://warehouse.data.zc2.ibm.com:50001;Database=bludb;User Id=a_ibm_com;Password=xxxxxxxx and I get the message "ERROR [IM002] Microsoft ODBC Driver Manager Data Source name not found and no default driver specified. 

    Does anyone have a step-by-step instructions to connect to bludb in CEDP?

    Thank you.

    ------------------------------
    Anthony Gadzinski
    ------------------------------


  • 2.  RE: How do I set-up a DB Connection in RPA Studio 20.12.5

    Posted Thu June 24, 2021 10:30 AM
    I actually got by this error and I am stuck on another. I changed the script to the below.

    Driver=IBM DB2 ODBC DRIVER - DB2COPY1;Server=FMS;Database=DNSP;ConnectTimeout=0;Interrupt=0;User Id=Cxxxxxx;Password=xxxxxx;

    I get ==> ERROR [08001] [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "127.0.0.1". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001

    I went to my Firewall and added rules for studio.exe as well as all the port # for my connection. How do I get around this error?

    ------------------------------
    Anthony Gadzinski
    ------------------------------



  • 3.  RE: How do I set-up a DB Connection in RPA Studio 20.12.5

    Posted Thu July 01, 2021 01:04 PM
    IBM RPA does not have a native command to connect to DB2 database.
    However, if ODBC driver is supported, you might use the odbcConnect command. Find out whether the DB2 allows ODBC and how to set up here
    • https://www.ibm.com/support/pages/db2-odbc-cli-driver-download-and-installation-information
    • https://www.connectionstrings.com/ibm-db2/


    ------------------------------
    Joba Diniz
    Product Manager
    IBM
    ------------------------------