In this topic, you define your distribution system by providing details about your source and target host machines. A host in an Enterprise data movement model (EDMM) is a computer on which is installed a database instance of a database management system that contains shared data.
A sending host is a host from which captured data is sent to target, or receiving, tables at a receiving host. The receiving host may be the same computer machine.
To create a host:
-
Right-click the Enterprise Data Movement Model root. In the menu that displays, select New Host to display the Host tab of the Host Properties dialog.
-
Enter information on the Host tab, as follows:
Field
Description
Label
Enter a unique host name for use in the model.
Machine [network] name or IP address
Enter the name or IP address of the host computer as it is known to the TCP/IP network.
Platform type
Select the type of host operating system.
Listener port number (required)
Enter the port used for communication with the database. This is the same port number entered during Connect CDC installation on this host. 1701 is the default port.
Note: A single Connect CDC Listener can support multiple models, but a single model cannot support multiple Connect CDC Listeners on a host.
Preassign a data port number [optional]
One of the following:
-
If selected, you can optionally, pre-assign a data port number for use on a network with firewalls.
-
If unchecked, uses an available port.
Note: You need to open the Connect CDC Listener port (for the CLiP socket) and this data port number (for the data socket to the kernel). If you want to run multiple models, you need to open a different data port for each model because you are talking to a different kernel for each model.
Use alternate IP address for connections to this host (e.g. firewall)
Select if you want the system to attempt a connection to an external IP address first. If the IP address is not given or the attempt fails, the machine name/IP address is used in a second attempt. This enables you to specify an external IP address for use from outside a firewall, and an internal IP address (or machine name) to be used from inside a firewall.
Connect CDC creates sockets that specify the local host IP address; it is the one given in the Machine name field on this tab.
When connecting to a particular host, Connect CDC first attempts to connect to the external IP address, if given. This works from a host machine outside a firewall connecting to the host inside the firewall. The external IP address is thus the one assigned to the host by the firewall and used outside the firewall to connect to the host.
If Connect CDC is trying to connect to the host from inside the firewall, the above connect will fail and it tries again using the internal machine name/IP address. The machine name is the only name/IP address needed if all machines are behind a firewall (or no firewall is involved).
IP address
Provide this value if using a second (external) IP address for connection.
Store XML locally at this host
Select to keep XML files at this host; otherwise, they must be available globally.
Access this host via
-
Model default socket type
-
Standard (unsecure) sockets
-
Encryption—both authentication and encryption
For information on Encryption, see Implement model authentication and encryption.
Three static fields display the name of the operating system in use at the host, its version, and the JVM version in use. These are available after a connection has been made to the host, including a test connection.
-
-
Click OK to accept your changes and close the dialog.
When the host is defined, an icon for it appears in the EDMM on a separate branch, along with the host’s model name and port number.
-
Right-click the host name, then select Test Connection.
A successful test establishes a persistent connection (socket) to a Connect CDC process (Connect CDC Listener) on that machine. If you select Disconnect from the host’s context menu, the socket will be closed.
You can create multiple hosts this way. When done, go to Create servers.