Using the Replication Server and Sybase IQ InfoPrimer Integration

Use Sybase IQ InfoPrimer to materialize data into Sybase IQ with Replication Server materialization methods, and configure Replication Server to process updates made to primary data.

  1. Before materialization:

    • Create an Extract and Load (EL) project in Sybase IQ InfoPrimer, selecting Materialization with Replication Server.

      In the RepServer tab of the EL project editor, you must also specify connection information for the primary Replication Server and the replicate Replication Server, if it is different from the primary. Sybase IQ InfoPrimer adds a command to the Processing tab. Do not modify or delete this command.

      For each source table, Sybase IQ InfoPrimer creates the required staging table definitions. Generate these staging tables on the replicate Sybase IQ database by selecting the Create missing destination tables icon on the Tables tab of the EL project editor.

      Note: If you are attempting to rematerialize, you must clear the rs_status table.

    • Create a SQL Transformation project, and model the transformation for each set of staging tables (insert, update, and delete) that have been generated in the replicate Sybase IQ database. Use the SQL Transformation project to deploy each set of transformations as a stored procedure in the replicate Sybase IQ database.

      Note: These transformation stored procedures truncate their corresponding staging tables when operations have been processed.

    RSIQIPdataflow1.gif
  2. In your Replication Server instance, use the stage_operations connection parameter to configure the replicate database connection to stage operations for the tables specified in your EL project.
    Note: If stage_operations is set to on, Replication Server ignores the setting of dsi_compile_enable and enables RTL for the connection. Operations are compiled, as when dsi_compile_enable is set to on, and then staged.
    In Sybase IQ InfoPrimer, execute your EL project. For each primary table specified, the EL project:
    1. Marks the table for replication.
    2. Inserts an autocorrection on record in the primary database log, which results in suspension of the Replication Server replicate database connection.
    3. Creates a table replication definition in the RSSD.
    RSIQIPdataflow2.gif
  3. Your Sybase IQ InfoPrimer EL project exports primary data for each table into the corresponding staging tables on the replicate Sybase IQ, executes the transformation stored procedures, and inserts an autocorrection off record in the primary database log.
    RSIQIPdataflow3.gif
  4. The Replication Server replicate database connection is resumed, and Replication Server processes any further changes to marked primary database tables using the staging tables and transformation stored procedures on the replicate Sybase IQ database.
    Note: Sybase IQ InfoPrimer is only used for data migration and creating the staging tables and transformation stored procedures. It is not involved in replication.
    RSIQIPdataflow4.gif
Parent topic: Replication Server and Sybase IQ InfoPrimer Integration