Table of Contents

Search

  1. Preface
  2. Data Replication Overview
  3. Understanding Data Replication
  4. Sources - Preparation and Replication Considerations
  5. Targets - Preparation and Replication Considerations
  6. Starting the Server Manager
  7. Getting Started with the Data Replication Console
  8. Defining and Managing Server Manager Main Servers and Subservers
  9. Creating and Managing User Accounts
  10. Creating and Managing Connections
  11. Creating Replication Configurations
  12. Materializing Targets with InitialSync
  13. Scheduling and Running Replication Tasks
  14. Implementing Advanced Replication Topologies
  15. Monitoring Data Replication
  16. Managing Replication Configurations
  17. Handling Replication Environment Changes and Failures
  18. Troubleshooting
  19. Data Replication Files and Subdirectories
  20. Data Replication Runtime Parameters
  21. Command Line Parameters for Data Replication Components
  22. Updating Configurations in the Replication Configuration CLI
  23. DDL Statements for Manually Creating Recovery Tables
  24. Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
  25. Glossary

Connecting to the Server Manager Main Server

Connecting to the Server Manager Main Server

You must connect to the Server Manager Main server before running Server Manager tasks.
  1. Click the
    Server Manager
    tab >
    Configs
    view.
    The following image shows this view:
    Server Manager > Configs view
  2. Enter connection information for the Server Manager Main server in the following fields:
    Host
    Host name or IP address of the system with the Server Manager Main server.
    Informatica recommends that you use the actual host name or IP address to connect to the Server Manager Main server. For a replication topology with multiple Server Manager instances, if you use "localhost" as the host name or use 127.0.0.1 as the IP address for the Server Manager Main server, subservers cannot access the Main server.
    Port
    Port number. Valid values are integers from 1 through 65535. The default port number is 8088.
    Use TLS
    Select this check box if the Server Manager Main server uses HTTPS connections.
    Login
    User name.
    The first time you connect to the Server Manager Main server, you must log in as the idradmin user. By default, the idradmin user has no password.
    Password
    User password.
  3. Optionally, select the
    Save
    check box to save the password.
  4. Click
    Connect
    to connect to the Main server.
    Under
    Replication Configurations
    , a list of configurations appears. Under
    Properties
    , the list of general properties for the selected configuration appears.
    Alternatively, if you connect to a Server Manager that uses a self-signed certificate to accept HTTPS connections for the first time, Data Replication searches for the TrustStore file that Java uses to store trusted certificates. Data Replication searches the default location of the Java TrustStore file, which is either
    JAVA_HOME
    /jre/lib/security/cacerts
    for the JDK or
    JAVA_HOME
    /lib/security/cacerts
    for the JRE.
    If Data Replication cannot locate the Java TrustStore file in the default directory, the following error message appears:
    If your password does not meet the password-strength requirements, the Data Replication Console opens a dialog box where you can change your password to meet the requirements.
  5. If the error message for a failed HTTPS connection to the Server Manager is displayed, click
    Close
    .
    The
    Server Manager HTTPS Connection Error
    dialog box appears.
  6. In the
    Server Manager HTTPS Connection Error
    dialog box, enter or browse to a valid Java TrustStore directory in the
    Path to the Java TrustStore
    field.
    If the certificate is not located in the specified TrustStore directory, select the
    Add a certificate to the Java TrustStore
    option and perform the following substeps:
    1. Copy the cert.pem file from the Data Replication installation directory on the system that runs the Server Manager Main server to the computer that runs the Data Replication Console.
    2. Open the copy of the cert.pem file in a text editor and delete the private key lines.
      Delete the lines from
      BEGIN PRIVATE KEY
      to
      END PRIVATE KEY
      .
      The host name or IP address in the cert.pem file must match the host name or IP address that you entered on the
      Server Manager
      tab >
      Configs
      view to connect to the Server Manager Main server. To edit the host name or IP address in the cert.pem file, follow the steps for regenerating the certificate in Configuring the Server Manager for HTTPS Communication.
    3. Enter the Java TrustStore information in the following fields:
      • Path to the certificate
        . The full path to the copy of the cert.pem file that includes only the certificate part of the original file.
      • Password for the Java TrustStore
        . The password for the Java TrustStore.
        The default password is "changeit."
    4. Click
      OK
      .
    Alternatively, you can add the certificate to the Java TrustStore manually. Run the following command:
    keytool –import –noprompt –trustcacerts –alias
    HOST_NAME_OR_IP
    –file
    PATH_TO_CERTIFICATE_FILE
    –keystore
    PATH_TO_JAVA_TRUSTSTORE
    –storepass
    PASSWORD_FOR_TRUSTSTORE
    The specified
    HOST_NAME_OR_IP
    address in the command must match the host name or IP address that you entered on the
    Server Manager
    Configs
    view to connect to the Server Manager Main server.
If the connection succeeds, the Main server appears in the
Servers
view and the other views of the
Server Manager
tab become active.
If Data Replication is configured to enforce password-strength policies, the second time you connect to the Server Manager Main server as the idradmin user using the empty password, the Data Replication Console requires you to change the password.

0 COMMENTS

We’d like to hear from you!