Installing Data Exchange for a transformation from a SQL Server to an Enterprise Database Server involves installing the Data Exchange Windows components, the DE Agent for SQL Server on the Windows partition, and the DMSII Adapter on the transformation target MCP host.
The Windows components can be installed on one Windows partition or on multiple partitions. It is recommended to install the DDW on one partition and all the Runtime components on another partition.
The MCP Agent and DMSII Adapter constitute the MCP Service. DMSII Adapter is used when the Enterprise Database Server is the transformation target. You must use the Inbound License key to install the DMSII Adapter.
This section provides information about installing and configuring the prerequisite software and the Data Exchange components, installing the DE Agent for SQL Server, installing the MCP Service, and configuring the SQL Server to be able to capture changed data.