Analyzing and Cleansing Data for Sun Master Index

Connecting to the Source Database

For this task, you might need to install the driver for your source database type. Once a driver is available, you can create a connection to the database that contains the data to be analyzed and cleansed.

ProcedureTo Connect to the Source Database

Before You Begin

Complete the steps under Configuring the Environment.

  1. For Oracle and MySQL, copy the database driver from your database installation to appServer_Home/lib.

  2. In the NetBeans Services window, expand Databases and then expand Drivers.

  3. If you do not see the driver for your source database, do the following:

    1. Right-click on Drivers and then select New Driver.

    2. On the Driver dialog box, click Add, and then browse to the location of the driver file.

      The driver you use depends on the database vendor for your source database. If you are unsure of how to find the driver, refer to your database documentation.

  4. Right-click the driver for your database, and then select Connect Using.

  5. On the New Database Connection dialog box, fill in the following fields:

    • Database URL - The URL to the source database. If you do not know the format for this, refer to your database documentation.

    • User Name – The user login ID for the source database.

    • Password – The password for the source database.

  6. Click OK.

  7. Under Databases in the Services window, expand the URL you entered above and view the tables in the database.

    If there are no database tables present, the connection failed. Recheck the values you entered for the database connection.

Next Steps

Continue to Creating the Staging Database and ETL Collaboration.