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:

Add the Data Movement IQ XEM to your AS IQ model
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 following fields are available on the Model properties sheet Data Movement tab:
Adding the Data Movement IQ XEM to Your AS IQ Model
You must add the Data Movement IQ XEM to your model.
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 following fields are available on the Data Source properties sheet Data Movement tab:
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, containing the following fields:

Parent topic: Sybase IQ