Blue Prism - DB2 Platform

[MichalPristas]

Hello. I would like to ask if there is any chance in next future to implement DB2 Database support as a Blue Prism Platform ? Thank you

[John__Carter]

Thanks Michal, please submit your idea here https://portal.blueprism.com/products/enhancement-request

[SusheelMaurya]

We can connect the IBM DB2 database in the blue prism using the OLEDB provider. I am using in one of my processes and it is working fine as per my requirement.
Below are the steps to connect the database.

• Components you need to connect the IBM DB2/AS400 Database
  • Microsoft OLE DB Provider for DB2 Version 6.0
  • Blue Prism Object - VBO - Data - OLEDB
  • IBM DB2/AS400 Database Access

• Microsoft OLE DB Provider for DB2 Version 6.0

• •   Download from https://www.microsoft.com/en-us/download/details.aspx?id=100917 and install on your machine
• Blue Prism Object - VBO Data – OLEDB

• •   Import from the folder VBO (Blue Prism installation folder)
• IBM DB2 Database Access
  •   If you don't have IBM DB2 access.   You can create a test database  on IBM cloud https://cloud.ibm.com/

Use Below Connection String and update the values for your database

"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;"

Below is the flow of the process to run the query.

------------------------------
Susheel Maurya
Team Leader - Process Excellence
Metlife
Noida
------------------------------

[santhoshthepro1]

Thanks Susheel for sharing the solution to connect to DB2.

------------------------------
Santhosh Vijayabaskar
Program Manager
Fidelity Investments
Covington KY
------------------------------

[mikkorah]

Hello, Thanks for this!

In addition, if network port needs to be configured - following string should be added to connection string: 

"Network Port=xxxxx;"

------------------------------
Mikko Rahikainen
RPA Manager
S-Group
Europe/Helsinki
------------------------------