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
(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com