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.
Complete the steps under Configuring the Environment.
For Oracle and MySQL, copy the database driver from your database installation to appServer_Home/lib.
In the NetBeans Services window, expand Databases and then expand Drivers.
If you do not see the driver for your source database, do the following:
Right-click the driver for your database, and then select Connect Using.
On the New Database Connection dialog box, fill in the following fields:
Click OK.
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.
Continue to Creating the Staging Database and ETL Collaboration.