1. Administrator's Guide
  2. Importing and Exporting Data and Metadata
  3. Working with the Outline Load Utility
  4. Importing Data and Metadata from a Relational Data Source

Importing Data and Metadata from a Relational Data Source

You can also import metadata and data from a relational database source. The import of metadata and data contained in a relational database is achieved by supplying a query on the external database that returns a result set equivalent to the flat file input format. A query and database connection information needs to be provided.

Oracle recommends that users employing this functionality are familiar with relational databases, the SQL query language, and JDBC connection properties. For Oracle Hyperion Planning applications, examples of these properties can be found in the HSPSYS_DATASOURCE table in the system database, which by default is located in the relational database that you create when selecting the Configure Database task under Planning in EPM System Configurator.

These command line parameters are available for users using the Outline Load utility to import from a relational data source:

  • /IR[:RDBConnectionPropertiesFileName]

  • /IRA

  • /RIQ:inputQueryOrKey

  • /RIC:catalog

  • /RID:driver

  • /RIR:url

  • /RIU:userName

  • /RIP:password

Note:

The /IR and /RIQ parameters are exclusive.

For descriptions of these parameters, see Command Line Parameters for the Outline Load Utility.

Caution:

Before performing an import operation, ensure you back up the Planning relational store and the Oracle Essbase data. See the Oracle Enterprise Performance Management System Backup and Recovery Guide.