Importing Sources via JDBC

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.

> 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. Select which database schema 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
- New Model Wizard
- Import Wizard
- Import XML Schema
- Connector Bindings
- Web Service Advisor View
- Getting Started with Metamatrix Dimension

(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com