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.
