topic RE: Thanks Michal, please submit… in Product Forum

Blue Prism - DB2 Platform

MichalPristas — Thu, 01 Nov 2018 16:37:00 GMT

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

Thanks Michal, please submit…

John__Carter — Thu, 01 Nov 2018 17:39:00 GMT

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

RE: Thanks Michal, please submit…

SusheelMaurya — Sat, 20 Feb 2021 20:07:00 GMT

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

RE: Thanks Michal, please submit…

santhoshthepro1 — Mon, 22 Feb 2021 13:06:00 GMT

Thanks Susheel for sharing the solution to connect to DB2.

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

RE: Thanks Michal, please submit…

mikkorah — Fri, 02 Dec 2022 11:19:00 GMT

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