Configuration Worksheets

You can use the worksheets to record all the configuration information for your RepConnector environment, Replication Server information, database information, application server information, messaging system information, and RepConnector information.

Fill out the worksheets as you configure each component in the system. Make a copy for each RepConnector connection profile and/or messaging system you have.

Replication Server Information

Current Value

Example

Maps to RepConnector Manager Wizard

DSI info

1) Used by Replication Server to identify where RepConnector connection will run; this is the information added to the Replication Server interfaces file.

2) Used when the create connection command is executed at Replication Server to add the connection, including setting the user name and password.

3) Used in subscription for RepConnector at Replication Server.

DSI Name

3.a

RepConnector

Replication Server Inbound Information page of New Connection wizard

Protocol

3.b

TCP

DSI Host Name

3.c

localhost

DSI Port

3.d

7000

DSI User Name

3.e

sa

DSI Password

3.f

Replication Server System Database Information

1) Used by Replication Server.

2) Used by RepConnector.

RSSD Name

3.g

RepServer_RSSD

Replication Server System Database Information window of New Connection wizard.

RSSD Host Name

3.h

localhost

RSSD Port Number

3.i

5000

Replicated Database Information Needed by Replication Server

1) Used in create table for replication at database.

2) Used in create replication definition for RepConnector at Replication Server.

Primary DB to be Replicated

3.j

pubs2

Not needed in the New Connection wizard

Host Name of Database Server

3.k

primary_ase

Port Number where DB is Listening

3.l

5000

User Name

3.m

sa

Password

3.n

JMS System Information

Current Value

Example

Maps to RepConnector Manager Wizard

Destination Type

queue

Outbound or inbound messaging – JMS information

JMS Provider URL

jnp://localhost:1099

Initial Naming Context Factory

org.jnp.interfaces.NamingContextFactory

Connection Factory

java:/ConnectionFactory

Destination Name

queue/sampleQueue

User Name

guest

Password

Topic Subscribers

Status Destination

TIBCO RBV Messaging System Information

Current Value

Example

Maps to RepConnector Manager wizard

Message Type

RCVM

Outbound or inbound messaging – TIBCO messaging information

MQ Daemon

7500

Encoding Type

localhost

Host Name

tcp\:7500

Channel

sample.Subject

Queue Manager/Factory

 

Queue Name

SAMPLE.CM1

User Name

0

Password

Status Definition

IBM WebSphereMQ Messaging System Information

Current Value

Example

Maps to RepConnector Manager wizard

Message Type

MQ

Outbound or inbound messaging – MQ messaging information

MQ Daemon

 

Encoding Type

utf

Host Name

localhost

Channel

Channel1

Queue Manager/Factory

MyManager

Queue Name

SAMPLEQ

Username

mquser

Password

mqpass

Status Definition

Database System Information

Current Value

Example

Maps To

JDBC Connection URL

jdbc:sybase:Tds:localhost: 5000

Outbound type properties for an outbound type of database

Driver Class

com.sybase.jdbc2.jdbc. SybDriver

User Name

sa

Password

Customization Information

Current Value

Example

Maps To

Message Formatter Plug-in Class

sample.MyMessageFormatter

Customization

Message Formatter Properties

sample.MyMessageFormatter.prop

Sender Processor Plug-in Class

sample.FileClient

Sender Processor Properties

sample.FileClient.prop

RepConnector Profile Properties

Current Value

Example

Maps To

Profile Name

JBoss:8080

RepConnector Manager, Connection Profiles

Host Name

localhost

Port Number

8080

User Name

repraadmin

Password

RepConnector Connection: General Properties

Current Value

Example

Maps To

Inbound Type

Replication

RepConnector Manager, General Properties

Outbound Type

JMS

DBEventStream XSD URL

http://localhost:8080/RepraWebApp/dtds/dbeventstream.xsd

Log Level

INFO

Auto Start Connection

FALSE

Customized Plug-in Class

FALSE

Inbound RepConnector Connection: DSI Properties

Current Value

Example

Maps To

DSI Name

RepConnector

RepConnector Manager, Inbound Properties

DSI Port

7000

User Name

sa

Password

Inbound RepConnector Connection: RSSD Properties

Current Value

Example

Maps To

RSSD URL

jdbc:sybase:Tds:localhost:5000/REP_RSSD

RepConnector Manager, Inbound Properties

User Name

sa

Password

Grouping

FALSE