Generating IQ Data Movement Scripts

PowerDesigner provides the capability to generate data movement scripts to populate your AS IQ data warehouse from your other databases.

The script can be used to:

Generate a flat file for loading to the AS IQ data warehouse
Create Insert Location statements for use with a proxy data base (for ASE and ASA only)

To create a data movement script, you must:

Attach the Data Movement IQ extension file to your AS IQ model.

To enable these extensions in your model, select Model > Extensions, click the Import tool, select the Data Movement IQ (on the General Purpose tab), and click OK to attach it.
Specify your data movement options
[optional] Create a data source linked to a model of the database from which you want to draw the data to be moved
[optional] Specify mappings between the tables in your data source and your AS IQ database
Generate the data movement script

Model Properties Data Movement Tab
The model properties sheet Data Movement tab contains properties to control the files used during data movement.
Creating a Data Source to Populate Your IQ Data Warehouse
You must create a data source to populate your IQ Data Warehouse.
Data Source Properties Data Movement Tab
The data source properties sheet Data Movement tab contains properties to enable access to the remote server.
Table Properties Data Movement Tab
If the Data Movement Method generation option is set to Insert Location, a Data Movement tab is available on each table properties sheet.

Parent topic: Sybase IQ