Installing Data Export Tables in IIQ 4.0 Patch 5

[#1]

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.