After you install Informatica Data Replication on a Microsoft SQL Server target system, you must complete several tasks to prepare the system for data replication.
Verify that the SQL Server database uses Mixed authentication mode to allow use of SQL Server Authentication.
Create a database user for Data Replication use. For example, use the user name “datarep_user.”
Set up an SQL Server login account for the database user that uses SQL Server Authentication.
Add the database user to the following server-level and database-level roles:
Server-level roles: dbcreator, public
Database-level role: db_owner. Add the Data Replication user to this role for each target database.
If you access SQL Server data from a Linux or UNIX system by using the Server Manager or another means, use the DataDirect ODBC driver that Data Replication provides in the
DataReplication_installation
/dd subdirectory.
Ensure that Microsoft SQL Server Native Client is installed on the system where InitialSync runs.
InitialSync requires the Native Client to load data to Microsoft SQL Server targets by using the Bulk Copy Program (BCP).