Copying cube data to the integration database

Use the Copy Cube Data to Integration Database page to export data to a staging table in the integration database.

Data integration for Base Data Store does not use or require Infor ION, Infor Business Vault, or Infor Business Vault Base Data Store. For information about loading structure and data using Infor ION, see the Infor ION Configuration section and the Infor ION documentation.

See the Base Data Store integration section for information on importing data from staging tables.

  1. Click the Home icon.
  2. Select Application Configuration > General Settings > Copy Cube Data to Integration Database.
  3. Select the integration database from the Database Name drop-down.
  4. Select the cube to export.
    The name of the target table is displayed. The target table name in the Integration database starts with EXPORT_.
  5. Select the staging table to contain the exported data.
    Staging tables are predefined and begin with EXPORT_. For example, EXPORT_BPCMAIN.
  6. Select a configuration set.
  7. Optionally, select the Include Unassigned Configuration set check box.
  8. Select a version.
  9. Optionally, select the Include Unassigned Version check box.
  10. For some cubes, select additional parameters.
    For WDCDRIVER cube, for example, select a driver.
  11. Optionally, select the Overwrite Existing Cube Data check box.
  12. Click Export.