You can view the host and port information of the Agent, Runtime Service, and Target. If required, you can change these values when you start a transformation.
To view the settings
Click Manage.
The hosts associated with the deployed transformations appear in the Source Database Hosts pane.
In the Source Database Hosts pane, expand the host type to view the list of source databases used in one or more transformations.
Select your transformation source.
The Transformation Source pane appears to the right.
In the Transformation Source pane, click the Settings tab. The System tab appears.
The following settings are displayed:
Field | Description | Applicable to Transformation Source... |
Agent Host | Displays the host name or the IP address of the host where the DE Agent for SQL Server is installed. | SQL Server |
Agent TCP Port | Displays the port number on which the Agent is listening. | Enterprise Database Server, RDMS, SQL Server |
Login User/Password | Displays the login user name and the password of the MCP host. | Enterprise Database Server |
Runtime Service Host | Displays the host name or IP address of the Windows partition where the Runtime Service is installed. | Enterprise Database Server, RDMS, SQL Server |
Runtime Service TCP Port | Displays the TCP port number of the Runtime Service that was configured during installation. | Enterprise Database Server, RDMS, SQL Server |
Secure Connection | Displays if SSL encryption is enabled for the transformation. | SQL Server |
Target Host | Displays the host name or the IP address of the target host. | SQL Server |
DMSII Adapter TCP Port | Displays the port number of the DMSII Adapter | SQL Server |
AIS Connection Name | Displays the AIS Connection Name | Enterprise Database Server, SQL Server |