Viewing System Settings

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

  1. Click Manage.

    The hosts associated with the deployed transformations appear in the Source Database Hosts pane.

  2. In the Source Database Hosts pane, expand the host type to view the list of source databases used in one or more transformations.

  3. Select your transformation source.

    The Transformation Source pane appears to the right.

  4. In the Transformation Source pane, click the Settings tab. The System tab appears.

    The following settings are displayed:

    FieldDescriptionApplicable to Transformation Source...
    Agent HostDisplays the host name or the IP address of the host where the DE Agent for SQL Server is installed.SQL Server
    Agent TCP PortDisplays the port number on which the Agent is listening.Enterprise Database Server, RDMS, SQL Server
    Login User/PasswordDisplays the login user name and the password of the MCP host.Enterprise Database Server
    Runtime Service HostDisplays 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 PortDisplays the TCP port number of the Runtime Service that was configured during installation.Enterprise Database Server, RDMS, SQL Server
    Secure ConnectionDisplays if SSL encryption is enabled for the transformation.SQL Server
    Target HostDisplays the host name or the IP address of the target host.SQL Server
    DMSII Adapter TCP PortDisplays the port number of the DMSII AdapterSQL Server
    AIS Connection Name Displays the AIS Connection NameEnterprise Database Server, SQL Server