Installing Data Export Tables in Access Governance Suite 4.0 Patch 5

  • 7011132
  • 07-Jul-2010
  • 02-Nov-2012

Environment

NetIQ Access Governance Suite

Situation

Installing Data Export Tables in Access Governance Suite 4.0 Patch 5

Resolution

Option A. There is a Generate Table Creating SQL Button on the Data Export Task create/edit page that generates a customized DDL which will place the SQL into a window where you can cut and paste and then you can hand off to a database administrator for execution. Once the datasource parameters are entered, click Generate Table Creation SQL.

Option B. Generate the Data Definition Language (DDL) specific to your environment. To do this, you can run the 'iiq exportschema' command. This will create the files in WEB-INF\database\export for each DB type.

Example:

WEB-INF/database/dataExport/create_data_export_tables.oracle
WEB-INF/database/dataExport/create_data_export_tables.db2
WEB-INF/database/dataExport/create_data_export_tables.mysql
WEB-INF/database/dataExport/create_data_export_tables.sqlserver


After generating these files, run the create table script on the Database of your choice. Then configure the data export task to point to the Database you are using.