During the installation of the metabase, Connect CDC Director created the omnirep database and granted privileges to its owner rpuser (replication user). After the metabase install, you must prepare the database by granting connection privileges to the replication user for the databases that will be replicated from/to the Informix DS server. At a minimum, this replication user must have dba privileges.
-
To prepare the database from within Connect CDC Director, right-click the server, then select Prepare User Database.
- Enter the database name in the Database/Schema Name dialog.
-
Click OK.
- Pick the system administrator ID and password on the User ID and Password dialog, then click OK.
A summary of steps that Connect CDC Director takes to prepare the database displays.
- Click OK.
A screen with the commands executing and then a message that the process is complete displays.
-
Click OK.