Data Transfer

Oracle OLAP runs within the Oracle database kernel. An Oracle OLAP session is always connected to the database. You do not open a connection with the database as a separate or optional step.

You can move data between an analytic workspace objects (such as variables and dimensions) and relational tables in the following ways:

• The OLAP DML's SQL command fetches data into dimensions and variables for further manipulation. A new SQL IMPORT command facilitates bulk data transfer from relational tables into the analytic workspace, and a new SQL INSERT DIRECT command facilitates data transfer from the analytic workspace into relational tables.
• A PL/SQL package, CWM2_OLAP_AW_CREATE, provides procedures for creating an analytic workspace from relational tables and OLAP Catalog metadata, and for generating views of the workspace.
• Using SQL table functions, it is now possible for a SQL-based application to manipulate and extract data from an analytic workspace. Express Server did not permit a data transfer to be initiated externally.

ODBC is not available, and thus access to third-party databases is not available directly from Oracle OLAP.

Oracle Express Relational Access Administrator and Oracle Express Relational Access Manager are not available.