MMHeader

Importing JDBC in Dimension Designer


Source relational models can be created by importing from JDBC sources.

Follow the steps below...

Note: Depending the detail provided in the database connection url information and schema, Steps 5 thru 7 may not be required

Step 1: In the VDB Explorer, choose the Import action in the toolbar or select the VDB in the tree and choose "Import..."

Step 2: Select the import option Metadata from JDBC Database and choose NEXT>

Step 3: Select existing or previous Source configuration or press "Sources..." to create new source configurations. (See the following for more information)

Step 4: After selecting Source, input password and press "Connect to Database". Press NEXT> (or FINISH> if enabled)

Step 5: On the "Select Database Metadata" page, choose select the types of objects in the database to import. Press NEXT> when finished (or FINISH> if enabled)

Step 6: On the "Select Database Objects" page, view the contents of the schema, or change selections. Customize which objects will be used to construct relational objects. Press NEXT> when finished (or FINISH> if enabled)

Step 7: On the "Specify Import Options" page, speciify desired Model Name as well as any other options used to customize the constructed relational objects. Press FINISH> to complete.


Related Topics

Create a New VDB

Import XML Schema

Connector Bindings

Web Service Advisor View

Getting Started with Metamatrix Dimension