Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{scrollbar}
----

Now that we have a few database connections (see [Setting Up Your Database Connections|01. Setting Up Your Database Connections], the next step is to describe the physical database tables and columns that we will want to include in our [business model|00. Metadata Terminology#BusinessModel].

h4. Importing Physical Tables 

Fortunately, when you import a physical table, all of the table's columns come with it, so the import is a one step exercise instead of two. You can later remove those columns that you do not want in the connection or the model. 

h5. An Example Import: Importing Tables into a MySQL Connection

# Right-click (or CTRl-click) on the *MySQLSampleData* node in the Tree Navigator. Select the *Import Tables...* option from the popup menu. 
# You will be prompted by a dialog with list of physical tables available in the database. Select the tables you want to include, and click *OK*. 

!metadata_import_tables.png|align=center!