Installation and Configuration Guide

10.2
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

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:

<MDM Registry Edition Installation Directory>\dbscript\ora

On UNIX:

<MDM Registry Edition 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.

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

Grant the SELECT privilege on all the user source tables to the newly created user.

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 CREATE PROCEDURE

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

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.

If you want to create public synonyms for the database objects so that the objects can be shared, perform the following tasks:

Open the

updsyncg.sql

script, and ensure that you specify the same user ID that you use to run the

updsyncu.sql

script.

Run the

updsyncg.sql

script by using a user ID that has the CREATE PUBLIC SYNONYM privilege.

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_PID

IDS_UPD_SYNC_REJ

On each target database, run the

idsconv9.sql

script.

The

idsconv9.sql

script creates the IDS_CONV utility on the target database.

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:

<MDM Registry Edition Installation Directory>\bin

On UNIX:

<MDM Registry Edition Installation Directory>/bin

These scripts create PL/SQL API components on each target database. For more information about the scripts, see

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

Step 2. Create Users and Tables

Step 2. Create Users and Tables