Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing Identity Resolution
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading Identity Resolution
  7. Uninstalling Identity Resolution

Installation and Configuration Guide

Installation and Configuration Guide

Step 2. Create Users and Tables

Step 2. Create Users and Tables

Informatica provides SQL scripts that you can run to create users and tables. You can find the SQL scripts in the following directory:
  • On Windows:
    <Identity Resolution Installation Directory>\dbscript\ora
  • On UNIX:
    <Identity Resolution Installation Directory>/dbscript/ora
Before you run the SQL scripts, customize the scripts to update the user ID, password, and default table space.
Copy the scripts to another directory before you customize the scripts. When you perform an upgrade, the installer can overwrite the customized scripts.
For a complete list of the database objects that the scripts create, see the database scripts.
  1. On each source database, run the
    idsuseru.sql
    script.
    The script creates a user with the required privileges.
    The following table describes the privileges that the script grants to the user when you run the script:
    Database Type
    Privilege
    Source database without synchronization
    CREATE SESSION
    Source database with synchronization
    CREATE SESSION
    CREATE TABLE
    UNLIMITED TABLESPACE
    CREATE SEQUENCE
    CREATE PROCEDURE
    CREATE ANY TRIGGER
  2. Grant the SELECT privilege on all the user source tables to the newly created user.
  3. On each target database, run the
    idsuseri.sql
    script.
    The
    idsuseri.sql
    script creates a user with the required privileges.
    The following table describes the privileges that the script grants to the user when you run the script:
    Database Type
    Privilege
    Target database without synchronization
    CREATE SESSION
    CREATE TABLE
    UNLIMITED TABLESPACE
    Target database with synchronization
    CREATE SESSION
    CREATE TABLE
    UNLIMITED TABLESPACE
    CREATE SEQUENCE
  4. On each source database that requires synchronization and on each target database, run the
    idstbora.sql
    script.
    The
    idstbora.sql
    script creates the following objects on the database:
    • IDS_FDT_META
    • IDS_FDT_RECID
    • IDS_RB_GROUPS
  5. On each source database that requires synchronization, run the
    updsyncu.sql
    script.
    The
    updsyncu.sql
    script creates the IDS_UPD_SYNC_TXN object on the source database.
    Never rerun the
    updsyncu.sql
    script on a source database that you have already synchronized. Rerunning the script might result in a loss of synchronization.
  6. If you want to create public synonyms for the database objects so that the objects can be shared, perform the following tasks:
    1. Open the
      updsyncg.sql
      script, and ensure that you specify the same user ID that you use to run the
      updsyncu.sql
      script.
    2. Run the
      updsyncg.sql
      script by using a user ID that has the CREATE PUBLIC SYNONYM privilege.
  7. On each target database that requires synchronization, run the
    updsynci.sql
    script.
    The
    updsynci.sql
    script creates the following synchronizer objects on the target database:
    • IDS_2PC
    • IDS_UPD_SYNC_NSA
    • IDS_UPD_SYNC_REJ
  8. On each target database, run the
    idsconv9.sql
    script.
    The
    idsconv9.sql
    script creates the IDS_CONV utility on the target database.
  9. Optionally, on each target database, run the
    ssasep.sql
    ,
    ssaseb.sql
    , and
    ssasec.sql
    scripts that you can find in the following directory:
    • On Windows:
      <Identity Resolution Installation Directory>\bin
    • On UNIX:
      <Identity Resolution Installation Directory>/bin
    These scripts create PL/SQL API components on each target database. For more information about the scripts, see
    Informatica Identity Resolution Developer Guide
    .