To Connect to the Staging Database

Before You Begin

Complete the steps under Creating 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 Connecting to the Source Database.