IQ Data Movement Scripts

PowerDesigner can generate data movement scripts to populate your AS IQ data warehouse from other databases. The script can generate a flat file for loading to the IQ data warehouse and create Insert Location statements for use with a proxy database (for ASE and ASA only).

1. To enable the Data Movement extensions in your model, select Model > Extensions, click the Attach an Extension tool, select the Data Movement IQ (on the General Purpose tab), and click OK to attach it.
2. Right-click the model in the Browser and select Properties to open its property sheet, then click the Data Movement tab and set the following properties as appropriate to control the files used during data movement:

   Property	Description
   Field / Row delimiter	Specify the delimiters to be used between fields and between rows in the dump file.
   Fully delimited file	Specifies that each row ends with a field delimiter before the row delimiter.
   Maximum image or text size	Specifies the maximum length of an image (or text) record, to which it will be truncated if necessary.
   Load file directory	Specifies the directory where the load file is located.

   Note: You can override these global data movement options for a specific table (and specify a table-specific dump file for importing) by opening its property sheet and enter table-specific values on the Data Movement tab.
3. In your IQ warehouse PDM, right-click the model in the Browser and select New > Data Source to create a data source to populate your IQ Data Warehouse. Enter a name for the source and then click the Models tab, click the Add Models tool, and select your source model.
4. Click the data source Database Connection tab, and select a data source, login, and password to connect to your source database.
5. Click the data source Data Movement tab, and enter the following properties as appropriate to access the remote server:

   Property	Description
   Remote server name	Specifies the name of the remote server used in the interface file for IQ server.
   Remote database name	Specifies the name of the remote database.
   Data source name	Specifies the label given to the data source in the sql.ini file.
   Dump file directory	Specifies the directory where the 'dump' file (external flat file), that contains the data to be imported, will be created.
   Local user name	Specifies the database user name.

6. [optional] Select Tools > Mapping Editor and create mappings between your source and warehouse tables.
   For detailed information about using the Mapping Editor, see Core Features Guide > Linking and Synchronizing Models > Object Mappings.

• Generating the Data Movement Script
  You can generate the data movement script from the Tools menu.