Data Replication Prerequisite Tasks

1. 1. Verify that a database target exists.
To replicate data to a database target, the database target must exist before you create the Data Replication task. If a database does not exist, the database administrator must create a target database. The database must meet the minimum system requirements.
2. 2. Create database users.
To replicate data to a database target, the database administrator must create a database user account in the target database. Each database user account must have the CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE privileges. You must have a database user account for each Data Replication task that writes to that database. You can use the same database user account for multiple Data Replication tasks. If you use the same database user account for multiple groups, ensure that the Data Replication tasks do not overwrite data in the same target tables.
3. 3. Create a directory for the flat files.
To replicate data to a flat file, create a directory to store the flat files.
4. 4. Optionally, create a schedule.
To run Data Replication tasks at specified times or on regular intervals, create a schedule.