1. Building Semantic Models in Oracle Analytics Cloud
  2. Create and Build Your Model
  3. Build a Semantic Model's Physical Layer
  4. Create a Database and Add Tables to the Physical Layer

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.

  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.
  4. In the Physical Layer pane click Create and then click Create Database.
  5. In Create Database, go to the Name field and type a name. Click OK.
    The new database's Tables tab is displayed.
  6. Click Connections 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.