The following table lists the order in which the prerequisite software and the Data Exchange components must be installed and configured.
Table 8. Installation Sequence for Transformations from SQL Server to Enterprise Database Server
| Partition | Action | References |
DE Agent for SQL Server | Install DE Agent for SQL Server | See Installing Data Exchange Agent for SQL Server |
MCP Host | Install DMSII Adapter | See Installing Data Exchange MCP Service (DMSII Adapter) |
Runtime Service | Install ClearPath Interface to AIS | For AIS 5.0, see ClearPath Application Integration Services Installation and Programming Guide For MCP Users, Section “Installing the Windows Component”. For AIS 4.1, see ClearPath Libra Servers Application Integration Services Release 4.0 Installation and Programming Guide, Section “Installing the Windows Component”. |
Runtime Service | Configure AIS Connection for target | Configure an AIS connection to each MCP target host and port. For AIS 5.0, see ClearPath Application Integration Services Installation and Programming Guide For MCP Users For AIS 4.1, see ClearPath Libra Servers Application Integration Services Release 4.0 Installation and Programming Guide, Section “Configuring Application Integration Services”. Use the default port 43745. If you are using SSL, use the port 43746. |
Runtime Service | Install or use an existing SQL Server | |
Runtime Service | Install Runtime Service | |
Administrative Service | Install or use an existing SQL Server | |
Administrative Service | Install and Configure IIS | See Prerequisites |
Administrative Service | Install Runtime Administration | |
DDW | Install or use an existing SQL Server | |
DDW | Install DDW |