topic Connect IBM DB2/AS400 with Blue Prism in University Forum https://community.blueprism.com/t5/University-Forum/Connect-IBM-DB2-AS400-with-Blue-Prism/m-p/95245#M3153 <DIV class="media" style="overflow: hidden; zoom: 1;"><STRONG style="font-family: 'Noto Sans', sans-serif;">We can connect the IBM DB2 database in the blue prism using OLEDB.</STRONG></DIV> <STRONG>Below are the steps to connect the database.</STRONG><BR /> <UL> <LI><STRONG>Components you need to connect the IBM DB2/AS400 Database</STRONG> <UL> <LI>Microsoft OLE DB Provider for DB2 Version 6.0</LI> <LI>Blue Prism Object - VBO - Data - OLEDB</LI> <LI>IBM DB2/AS400 Database Access</LI> </UL> </LI> </UL> <BR /> <UL> <LI><STRONG>Microsoft OLE DB Provider for DB2 Version 6.0</STRONG></LI> </UL> <OL></OL> <UL> <LI style="list-style-type: none;"> <UL style="list-style-type: circle;"> <LI>&nbsp; Download from <A href="https://www.microsoft.com/en-us/download/details.aspx?id=100917" target="_blank" rel="noopener">https://www.microsoft.com/en-us/download/details.aspx?id=100917</A> and install on your machine</LI> </UL> </LI> <LI><STRONG>Blue Prism Object - VBO Data – OLEDB</STRONG></LI> </UL> <UL> <LI style="list-style-type: none;"> <UL style="list-style-type: circle;"> <LI>&nbsp; Import from the folder VBO (Blue Prism installation folder)</LI> </UL> </LI> <LI><STRONG>IBM DB2 Database Access</STRONG> <UL> <LI>&nbsp; If you don’t have IBM DB2 access.&nbsp;&nbsp; You can create a test database&nbsp; on IBM cloud <A href="https://cloud.ibm.com/" target="_blank" rel="noopener">https://cloud.ibm.com/</A></LI> </UL> </LI> </UL> <P><STRONG>Use Below Connection String and update the values for your database</STRONG></P> <P>“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;"<BR /><BR />Below is the flow of the process to run the query.<BR /><span class="lia-inline-image-display-wrapper" image-alt="34847.jpg"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/34910iB5E2893D740C5C2E/image-size/large?v=v2&amp;px=999" role="button" title="34847.jpg" alt="34847.jpg" /></span><BR /><IMG class="img-responsive" data-mce-hlimagekey="8c73fc1e-6997-e1d4-aff9-7ce5091513d4" data-mce-hlselector="#MainCopy_ctl02_TinyMCEEditor_TinyMCEContent" /><BR /><BR /></P> Sat, 20 Feb 2021 20:10:15 GMT SusheelMaurya 2021-02-20T20:10:15Z Connect IBM DB2/AS400 with Blue Prism https://community.blueprism.com/t5/University-Forum/Connect-IBM-DB2-AS400-with-Blue-Prism/m-p/95245#M3153 <DIV class="media" style="overflow: hidden; zoom: 1;"><STRONG style="font-family: 'Noto Sans', sans-serif;">We can connect the IBM DB2 database in the blue prism using OLEDB.</STRONG></DIV> <STRONG>Below are the steps to connect the database.</STRONG><BR /> <UL> <LI><STRONG>Components you need to connect the IBM DB2/AS400 Database</STRONG> <UL> <LI>Microsoft OLE DB Provider for DB2 Version 6.0</LI> <LI>Blue Prism Object - VBO - Data - OLEDB</LI> <LI>IBM DB2/AS400 Database Access</LI> </UL> </LI> </UL> <BR /> <UL> <LI><STRONG>Microsoft OLE DB Provider for DB2 Version 6.0</STRONG></LI> </UL> <OL></OL> <UL> <LI style="list-style-type: none;"> <UL style="list-style-type: circle;"> <LI>&nbsp; Download from <A href="https://www.microsoft.com/en-us/download/details.aspx?id=100917" target="_blank" rel="noopener">https://www.microsoft.com/en-us/download/details.aspx?id=100917</A> and install on your machine</LI> </UL> </LI> <LI><STRONG>Blue Prism Object - VBO Data – OLEDB</STRONG></LI> </UL> <UL> <LI style="list-style-type: none;"> <UL style="list-style-type: circle;"> <LI>&nbsp; Import from the folder VBO (Blue Prism installation folder)</LI> </UL> </LI> <LI><STRONG>IBM DB2 Database Access</STRONG> <UL> <LI>&nbsp; If you don’t have IBM DB2 access.&nbsp;&nbsp; You can create a test database&nbsp; on IBM cloud <A href="https://cloud.ibm.com/" target="_blank" rel="noopener">https://cloud.ibm.com/</A></LI> </UL> </LI> </UL> <P><STRONG>Use Below Connection String and update the values for your database</STRONG></P> <P>“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;"<BR /><BR />Below is the flow of the process to run the query.<BR /><span class="lia-inline-image-display-wrapper" image-alt="34847.jpg"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/34910iB5E2893D740C5C2E/image-size/large?v=v2&amp;px=999" role="button" title="34847.jpg" alt="34847.jpg" /></span><BR /><IMG class="img-responsive" data-mce-hlimagekey="8c73fc1e-6997-e1d4-aff9-7ce5091513d4" data-mce-hlselector="#MainCopy_ctl02_TinyMCEEditor_TinyMCEContent" /><BR /><BR /></P> Sat, 20 Feb 2021 20:10:15 GMT https://community.blueprism.com/t5/University-Forum/Connect-IBM-DB2-AS400-with-Blue-Prism/m-p/95245#M3153 SusheelMaurya 2021-02-20T20:10:15Z