Create a Database and Add Tables to the Physical Layer

A database is the physical layer's highest level object and minimally contains one schema and a subset of tables and metadata from the semantic model's data source.

When you drag a table from the connection and drop it into an empty physical database, Oracle Analytics creates a physical schema and puts the table into the schema.

Dragging and dropping a table from the data source connection to the database populates some of the database's features, the query features, and connection pools. You can adjust these settings as needed. You can add query limits for application roles to the database.

Before you start adding tables to the database, you can add catalogs and schemas structure to organize the database's tables. See Add a Catalog to a Database and Add a Schema to a Database or Catalog.

For multidimensional data sources, see Add Essbase Cube Tables to the Physical Layer and Add Oracle EPM Cloud Cube Tables to the Physical Layer.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer tab contains objects representing physical data.
  4. In the Physical Layer pane click Create Create icon and then click Create Database.
  5. In Create Database, go to the Name field and enter a name. In the Database Types field, select the physical database's data source. Click OK.
    The new database's Tables tab is displayed.
  6. Click Connections Connections icon and in the connections pane, browse or search for the table to add to the physical database.
  7. Drag the table to the physical database and drop it into the Tables list.
  8. Click Save.