Configuring RepConnector

Use the RepConnector Manager to configure the RepConnector connections. See the RepConnector Configuration and User’s Guide for detailed information about RepConnector Manager, and configuration of the RepConnector connections for TIBCO EMS and IBM WebSphere MQ.

Table 5 shows the parameters for configuring RepConnector to connect with Replication Server.

Table 5: Configuring RepConnector for Replication Server

Property name

Description

Inbound Type

The inbound message type. Set as REPLICATION.

Outbound Type

The outbound message type. Specify as JMS.

DSI Name

The name of your Data Server Interface (DSI) connection, defined in the interfaces file for your RepConnector connection.

DSI Port

The port number of your DSI connection, defined in the interfaces file for your RepConnector connection.

DSI User Name and Password

The user name and password, defined for the replication connection configured with your Replication Server.

RSSD URL

The URL of the RSSD database.

RSSD User Name and Password

The user name and password to access to the RSSD database.

Required Group

Select one of the following:

  • Individual – to route a single event in a transaction.

  • Group – to route multiple events in a transaction.

Table 6 shows the parameters for configuring RepConnector to connect with TIBCO EMS.

Table 6: Configuring RepConnector for TIBCO EMS

Property name

Description

Inbound Type

Specify one:

  • JMS – for routing the events from the EMS to the target database.

  • REPLICATION – to route the replication event to the EMS queue or topic.

Outbound Type

Specify one:

  • JMS – for routing the events to route the replication event to the EMS queue or topic.

  • DATABASE – to route the SQL commands to the target database.

Destination Type

Select one:

  • Queue – if you are using a queue configured with the TIBCO EMS.

  • Topic – if you are using a topic.

JDBC Provider URL

The URL of the TIBCO EMS. The default is tcp://localhost:7222.

Initial Naming

The class of the naming context factory for TIBCO.

Context Factory

EMS. Select com.tibco.tibjms.naming.TibjmsInitialContextFactory.

Connection Factory

The name of the EMS connection factory. Select either:

  • Queue destination type – com.tibco.tibjms.TibjmsQueueConnectionFactory.

  • Topic destination type – com.tibco.tibjms.TibjmsTopicConnectionFactory.

Destination Name

The name of the destination queue or topic.

User Name and Password

The user name and password defined for the queue or topic configuration.

Topic Subscribers

The preregistered subscribers for the topic.

Status Destination

The queue or topic for storing the error message if the SQL command failed to be delivered to the target database.

Table 7 shows the parameters for configuring RepConnector to connect with your target database.

Table 7: Configuring RepConnector for the target database

Property name

Description

Outbound Type

Specify “DATABASE

JDBC Connection URL

The JDBC URL to connect to the target database

Driver Class

Specify com.sybase.jdbc3.jdbc.SybDriver

User Name and Password

The user name and password to connect to the target database