About Importing Metadata into the Physical Layer

You can import metadata from a data source connection by dragging and dropping tables from the Connections tab into the semantic model's physical layer.

Before you can import metadata, you must have all data source connections created. See About Semantic Model Data Source Connections.

When you import metadata into the physical layer, be careful to import only those tables that contain data that are likely to be used in the business models you create. You can search and select the tables that you want to add. Adding large numbers of extraneous tables and other objects adds unnecessary complexity and increases the size of the semantic model.

When you import metadata, the default is to import tables and primary keys.

You can also import database views, aliases, synonyms, and system tables. Import these objects only if you want the Oracle Analytics query engine to generate queries against them.

After you import metadata, you should check to ensure that your database and connection pool settings are correct.

In rare cases, the Oracle Analytics query engine can't determine the exact database type during import and instead assigns an approximate type to the database object.