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 DatabaseProvider.config file, located in <Installpath>\BDNA\Data Platform\Conf, using a text editor such as Notepad.
To extract data from a DB2 database:
| |
1.
|
Open the DatabaseProvider.config file in a text editor. |
| |
2.
|
By default, the BDNA Data Platform Extractor uses the MS OLEDB Provider for DB2, as shown in the following screen. 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
| |
3.
|
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 the following screen. |
DatabaseProvider.config with DB2 IBM Native Provider activated
| |
4.
|
Save the modified DatabaseProvider.config file. |
| |
5.
|
Restart the Normalize service, |
| |
6.
|
Test the connection to DB2. |
| |
a.
|
If you see an error status about a required client at the bottom of the page, proceed to Step 7. |
| |
b.
|
If you are able to connect successfully, the modification process is finished. Proceed to Step 8. |
| |
a.
|
On the IBM Data Server Client Packages page, click the IBM Data Server Runtime Client link. |
Note:You are required to have an IBM ID to download the Data Server Runtime Client.
| |
b.
|
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 |
| |
c.
|
Download and install the IBM Data Server Runtime Client you selected. |
| |
8.
|
You have completed the modifications necessary to extract and process data from your DB2 database. Reboot your system if necessary. |