Creating the Staging Database

For this task, you create a new Data Integrator Module. Data Integrator uses the master index object definition file to define the structure of the staging database schema.

To Create the Staging Database

1. Right-click in the NetBeans Projects window and select New Project.

2. Under Categories, select SOA, and then select Data Integrator Module under Projects.

3. Click Next.

4. On the Name and Location page, enter a name for the project and the location of the project files.

5. Click Finish.

6. In the NetBeans window, right-click the project you just created and select Generate Schema.

7. On the Choose DB Location dialog box, fill in the following fields. When you are finished, click OK.

   • Master Index Object Definition – The ojbect.xml file in the master index project for which you are analyzing data. This is located in NetBeans_Projects/Project_Name/src/Configuration.

   • Staging Database Location – The path to the location where you want to store the staging database.

   • Database Name – A unique name for the staging database.

     ---

     Note –

     Make a note of the name and location for the database. You will need to use these values to define the database URL in a later step.

     ---

8. Verify that the database files were created in the path you specified.

Next Steps

Continue to Connecting to the Staging Database.