test

Designing Data Integrator Projects

Connecting to a JDBC-Compliant Database

This step requires that the database drivers for the database platforms you are working with are installed. Some database drivers are already installed by default, but you might need to add the database driver depending on which database platform you are using. For example, if you are using Oracle or Microsoft SQL Server, you need to copy the driver to the application server and add it to the Services window.

ProcedureTo Connect to a JDBC-Compliant Database

Before You Begin

Make sure the database you are connecting to has already been created and is running. If the database drivers for the platforms you are using have not been installed to app_server/lib, copy the drivers to that location.

  1. In the NetBeans Services window, expand Databases.

  2. If you do not see the driver for the database you are using, copy the driver from your database installation to AppServer_Home/lib and then do the following:

    1. Right-click Drivers, and select New Driver.

    2. On the New JDBC Driver dialog box, click Add.

    3. Browse to and open the JAR or ZIP file you copied to the application server libdirectory.

    4. Accept the default driver class or type in a new one. If no driver is entered, click Find to have the wizard search for an appropriate class.

    5. Enter a name for the driver.

      Figure shows the New JDBC Drivers dialog box.

    6. Click OK.

    The new database driver appears under Drivers in the Services window.

  3. Right-click the new driver, and select Connect Using.

  4. In the New Database Connection dialog box, do the following:

    1. Enter the database connection URL.

      Note –

      Different database platforms use different connection URLs. Refer to your database documentation for the format to use.

    2. Enter the user name and password to use to log on to the database.

    3. Select Remember Password.

      Figure shows the New Database Connection dialog box.

    4. To select a specific schema in the database, click the Advanced tab and then click Get Schemas.

      A list of available schemas appears for you to choose from.

    5. Click OK.

    A new database connection appears under Databases.

  5. Right-click the new database, and select Connect.