Configuring OLE DB

Configuring OLE DB involves configuring the OLE DB provider and data source.

Procedure

  1. Using a text editor, create an empty text file and save it to the desktop as test.udl.
  2. Double-click the desktop icon for the test.udl file.
  3. In the list of OLE DB providers, select IBM Netezza OLE DB Data Provider and click Next.
  4. On the Connection tab, in the Data Source field, specify the name of the system where the database is located.
  5. Specify appropriate values for the database user name and password.
  6. From the list, choose the name of the database (catalog) to which you want to connect.
  7. If your database has multiple schemas, click the Advanced tab, and type the name of the schema within the database to which you want to connect.
  8. On the Connection tab, click Test Connection.
  9. Click OK to authenticate the user and establish the connection.

    If the connection is successful, a confirmation window opens. If the connection fails, verify that the values of the SSL security parameters agree with the values of the parameters that the system administrator defined for the system to which you are attempting to connect.