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

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