Connecting to the Staging Database

To connect to the staging database, you need to use the Virtual DB database driver. This requires entering information you entered for the database in step 17 of Creating the Staging Database and ETL Collaboration.

To Connect to the Staging Database

1. On the NetBeans Services window, expand Databases and then expand Drivers.

2. Right-click Virtual DB, and then select Connect Using.

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

   • Database URL – The URL to the staging database in this format: jdbc:axiondb:DatabaseName:DatabaseLocation.

     DatabaseName is the name you gave the database in Creating the Staging Database; DatabaseLocation is the path to the staging database.

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

   • Password – The password for the staging database.

     The default user name and password for the staging database is “sa” for both.

4. Click OK.

5. 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 Extracting the Data Using Data Integrator.