7.3. Model a JDBC Source

Open Guides View

View larger image

Figure 7.1. Guides View

Define Teiid Model Project

1. The Define Teiid Model Project action launches the New Model Project wizard. In the Action Set list, double-click the action (or select the action, then click Execute selected action). The wizard is launched as shown below:
   Enter a project name, for example, MyProject in the Name field. Then click Next.
   

   View larger image

   

   Figure 7.2. New Project Wizard

2. The next page of the wizard is Project References which allows you to select other projects which this project will reference. Click Next.
3. The next page of the wizard is shown below:
   

   View larger image

   

   Figure 7.3. New Project Folders

4. Under Create Folders, clear schemas and web_services. We will not need them for this example. Now, click Finish to exit the wizard. The project has now been created.
   Your Model Explorer view will look like this:
   

   View larger image

   

   Figure 7.4. Model Explorer

Create JDBC connection

View larger image

Figure 7.5. Connection Profile Name and Type

View larger image

Figure 7.6. Connection Profile properties

Create source model for JDBC data source

1. The Create source model for JDBC data source action will now utilize the Connection profile that you have created, to import the metadata from the database to create your Teiid Source Model. In the Action Set list, double-click the action (or select it, then click Execute selected action). The wizard is launched as shown below:
   

   View larger image

   

   Figure 7.7. Select Connection Profile

2. On this page, select the TestMySQL Connection profile that you created in the previous step. Click Next.
   

   View larger image

   

   Figure 7.8. Select Database Metadata

3. On this page, select the database metadata that you want to import. When finished, click Next.
   

   View larger image

   

   Figure 7.9. Select Database Objects

4. On this page, select the specific objects from the database that you want to import. When finished, click Next.
   

   View larger image

   

   Figure 7.10. Import Options

5. Finally, choose the name for the model to be created (defaults to profileName.xmi). The Into Folder field defines the target location for your new model. Select the MyProject/sources folder. Now, click Finish. The source model has now been created. Your Model Explorer view will look like this:
   

   View larger image

   

   Figure 7.11. Model Explorer

Preview Data

1. The Preview Data action allows you to preview a sample of data rows from your source. In the Action Set list, double-click the action (or select it, then click Execute selected action).
2. In the first dialog, click ... button and then select the source table you want to preview, as shown below:
   

   View larger image

   

   Figure 7.12. Select Preview Table

3. After selecting the table, click OK button in both dialogs. After that, the Custom Preview Data dialog is shown when you can see SQL query and VDB XML Content. Click OK for running query.

   Note

   When the server is not running during creating source model, you can get Data Sources Missing dialog. Just click to Yes for creating a new data source.
   

   View larger image

   

   Figure 7.13. Custom Preview Data

4. Now, the preview results will be displayed:
   

   View larger image

   

   Figure 7.14. Preview Results

Define VDB

1. The Define VDB action allows you to create a VDB (Virtual Database) artifact for deployment to a JBoss Data Virtualization Server. In the Action Set list, double-click the action (or select it, then click Execute selected action). If you choose to create a new VDB, the following dialog is displayed:
   

   View larger image

   

   Figure 7.15. New VDB

2. In the dialog, select the target In Folder location where the VDB will be placed. Enter a Name for the VDB, for example myVDB. Finally, select the models that will be included in the VDB. When finished, click Finish. The VDB will be created in your Teiid Model Project as shown in the following figure.
   

   View larger image

   

   Figure 7.16. Model Explorer

Edit VDB

Execute VDB

View larger image

Figure 7.17. Execute VDB Example