Modifying Configuration to Extract and Process DB2 Data

This section provides step-by-step instructions for enabling the BDNA Data Platform DB2 Extractor to extract data from a DB2 database using the IBM Native Provider rather then the default MS OLEDB Provider.

The process described here requires modification to the Normalize DatabasaeProvider.config file, located in <Installpath>\BDNA\Data Platform\Conf, using a text editor such as Notepad.

To extract data from a DB2 database:

Open the DatabaseProvider.config file in a text editor.

By default, the BDNA Data Platform Extractor uses the MS OLEDB Provider for DB2, as shown in {Z_Hyperlink}Figure {paranumonly[FigureCaption,FigureCaptionWide]}‚ ”.”{Default ¹ Font} You must edit the DatabaseProvider.config file so that it uses the IBM Native Provider for DB2 instead.

Note • Both the MS OLEDB and the IBM Native Provider are included in the DatabaseProvider.config file. Only the MS OLEDB provider is activated by default.

DatabaseProvider.config with DB2 MS OLEDB Provider activated

You can make the modification to DatabaseProvider.config simply by commenting out the DB2 MS OLEDB Provider section and un-commenting the DB2 IBM Native Provider section as shown in {Z_Hyperlink}Figure {paranumonly[FigureCaption,FigureCaptionWide]}‚ ”DatabaseProvider.config with DB2 IBM Native Provider activated.”{Default ¹ Font}

DatabaseProvider.config with DB2 IBM Native Provider activated

Save the modified DatabaseProvider.config file.

Restart the Normalize service,

Test the connection to DB2.

If you see an error status about a required client at the bottom of the page, proceed to {Z_Hyperlink}step ;7{Default ¹ Font}.

If you are able to connect successfully, the modification process is finished. Proceed to {Z_Hyperlink}step ;8{Default ¹ Font}.

If you need to install the IBM Data Server Runtime Client, use the link provided here: http://www-01.ibm.com/support/docview.wss?uid=swg21385217. Clicking the link opens the IBM Data Server Client Packages page.

On the IBM Data Server Client Packages page, click the IBM Data Server Runtime Client link, as shown in {Z_Hyperlink}Figure {paranumonly[FigureCaption,FigureCaptionWide]}‚ ”Link to IBM Data Server Runtime Client.”{Default ¹ Font}

Link to IBM Data Server Runtime Client

Note • You are required to have an IBM ID to download the Data Server Runtime Client.

Select the appropriate download for your Normalize installation:

•

Select the IBM 32-bit Data Server Runtime Client if you are running Normalize in 32-bit mode

•

Select the IBM 64-bit Data Server Runtime Client if you are running Normalize in 64-bit mode

Download and install the IBM Data Server Runtime Client you selected.

You have completed the modifications necessary to extract and process data from your DB2 database. Reboot your system if necessary.

Open topic with navigation

Modifying Configuration to Extract and Process DB2 Data

BDNA Data Platform 5.5 Installation Help Library

June 2021