Appendix A: Configuration Worksheets

This appendix contains worksheets on which you can 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.

**Table A-1: Replication Server information (Chapter 3)**
	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
Host name of Database Server	3.k	primary_ase
Port number where DB is listening	3.l	5000
User name	3.m	sa
Password	33.n

**Table A-2: JMS System information**
	Example	Maps to RepConnector Manager Wizard
Destination Type	queue	Outbound or inbound messaging – JMS information
JMS Provider URL	iiop://localhost:9000
Initial Naming Context Factory	com.sybase.jms.IntialContextFactory
Connection Factory	javax.jms.QueueConnectionFactory
Destination Name	sampleQueue
User Name	jagadmin
Password
Topic Subscribers
Status Destination

**Table A-3: TIBCO RBV Messaging System information**
	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

**Table A-4: IBM WebSphereMQ Messaging System information**
	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

**Table A-5: Database system information**
	Example	Maps to
JDBC Connection URL	jdbc:sybase:Tds:localhost: 5000	See Chapter 3 Worksheet
Driver Class	com.sybase.jdbc2.jdbc. SybDriver
User Name	sa
Password

**Table A-6: Database system information**
	Example	Maps to
JDBC Connection URL	jdbc:sybase:Tds:localhost: 5000	See Chapter 3 Worksheet
Driver Class	com.sybase.jdbc2.jdbc. SybDriver
User Name	sa
Password