We can connect the IBM DB2 database in the blue prism using OLEDB.
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
-
- Blue Prism Object - VBO Data – OLEDB
-
- Import from the folder VBO (Blue Prism installation folder)
- IBM DB2 Database Access
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.
![34847.jpg 34847.jpg](/t5/image/serverpage/image-id/34910iB5E2893D740C5C2E/image-size/large?v=v2&px=999)
![]()