Chapter 4: Configuring the Messaging System

This chapter provides an overview about the requirements and procedures for configuring each messaging system RepConnector supports.

The specific configuration details for the messaging system in your environment depend on which messaging system you are using. This chapter does not attempt to cover all of those details. See the documentation for your messaging system for more information.

The procedures in this chapter refer to values that you can record in Appendix A, “Configuration Worksheets,” which can make the configuration process easier.

The configuration of a RepConnector connection requires one messaging system configured at one end of the route, either from the Replication Server to a messaging queue or from a message queue to the database.

You can configure a RepConnector connection to deliver the database replication events from the Replication Server to the target messaging system, or to read the Data Manipulation Language (DML) operations from the messaging system and execute them over the target database system. In any connection configuration, you must configure the messaging system to communicate with the RepConnector connection. To route the replication events to the target messaging system, you must configure the messaging system to be the outbound end of the connection. To execute SQL commands over the target database, you must configure the messaging system as the inbound end of the connection.

If your messaging system requires you to load libraries and you use EAServer 5.2 as your application server, take these steps to load the libraries:

  1. Copy the messaging system jar files to the java/classes directory on EAServer.

  2. Use EAServer Manager to connect to your EAServer instance. See the EAServer documentation for specific information.

    Then, go to the Servers/<your server> directory and select the Server Properties menu. From the pop-up, select the Java Classes tab and click Add to add the name of the jar file, such as mycustom.jar. Click OK.

  3. Inn EAServer Manager, right-click on the Servers/Jaguar icon and select Properties.

  4. Select “Java Classes” from the tabs and add the names of the jar files you copied in Step One. Include the extension .jar when adding these names.

The following sections describe some fundamental structure about the configuration of each specific type of RepConnector connections.

NoteBoth the inbound and outbound systems must be configured and available before you can configure and run the RepConnector connection.