Updating the interfaces files for the source database, Replication Server, and ETL Server

  1. Navigate to the interfaces file.

    • On Windows, the file is in <installation_directory>\ini\sql.ini.

    • On UNIX and Linux, the file is in <installation_directory>/interfaces

  2. Use a text editor to modify all the three interfaces files to include:

    • Entries for Replication CDC Services of all ETL Servers.

      • On Windows for example, use:

        [<cdc_service_name>]
        master=TCP,<machine_name>,<port>
        query=TCP,<machine_name>,<port>
        
      • On UNIX or Linux, use:

        <cdc_service_name>
        master tcp sun-ether <machine_name> <port>
        query tcp sun-ether <machine_name> <port>
        

      where:<cdc_service_name> is a unique Replication CDC Service name to be used by a single ETL Server.<machine_name> is the name of the machine on which the grid ETL Server runs.

      <port> is the port on which the Replication CDC Service listens.

    • A SYBETL_VIR_RDBMS entry that contains all CDC Service entries.

      • On Windows for example, use:

        [SYBETL_VIR_RDBMS]
        
        	master=TCP,<machine_name_1>,<port>
        
        query=TCP,<machine_name_1>,<port>
        
        master=TCP,<machine_name_2>,<port>
        
        query=TCP,<machine_name_2>,<port>
        
      • On UNIX and Linux, use:

        SYBETL_VIR_RDBMS
        
        master tcp sun-ether <machine_name_1> <port>
        
        query tcp sun-ether <machine_name_1> <port>
        
        master tcp sun-ether <machine_name_2> <port>
        
        query tcp sun-ether <machine_name_2> <port>
        

      NoteThe IP port of the virtual database and Replication CDC Services should match.

    • If the source database is ASE, create or copy the entries for your ASE source database, Replication Server, and Embedded Replication Server System Database (ERSSD) or RSSD.

      If the source database is Oracle, create or copy the entries for your Replication Agent™, Replication Server, and Embedded Replication Server System Database (ERSSD) or RSSD.

      • On Windows for example, use:

        [<ase_name>]
        master=tcp,<ase_machine_name>,<ase_port>
        query=tcp,<ase_machine_name>,<ase_port>
        
        [<repserver_name>]
        master=tcp,<repserver_machine_name>,
               <repserver_port>
        query=tcp,<repserver_machine_name>,
               <repserver_port>
        [<erssd_name>]
        master=tcp,<erssd_machine_name>,<erssd_port>
        query=tcp,<erssd_machine_name>,<erssd_port>
        
      • On UNIX and Linux, use:

        <ase_name>
        master tcp sun-ether <ase_machine_name> <ase_port>
        query tcp sun-ether <ase_machine_name> <ase_port>
        
        <repserver_name>
        master tcp sun-ether <repserver_machine_name>
        <repserver_port>
        query tcp sun-ether <repserver_machine_name> <repserver_port>
        <erssd_name>
        master tcp sun-ether <erssd_machine_name> <erssd_port>
        query tcp sun-ether <erssd_machine_name> <erssd_port>