Epicor Replication Server is designed to replicate tables from the Epicor application database to a secondary SQL database. It is recommended that Replication Server is installed on a server other than the main Epicor application server since it's primary purpose is to allow offloading of reporting and query functions from the main transactional server.
Replication database tables are selected using profiles designed in the Epicor
application and applied to companies in the main system. One replication database can contain data from multiple companies, even if these companies are on multiple application servers, as long as the Company IDs are unique. Similarly, multiple replication databases can subscribe to data from a single application source.
D.1 Review Epicor Replication Server Types
Replication subscribing databases have two types:
* Ad Hoc. An Ad Hoc subscribing database starts as an empty SQL database and all table schemas and data are loaded from the source database. This replicated database may be used for ad hoc reporting using tools such as Crystal.
* Fully Functional. A Fully Functional subscribing database starts as an empty Epicor SQL database with all tables and stored procedures and functions pre- delivered. These empty databases are included with the Epicor application. This replicated database may be configured as the database for a running installation of the Epicor application. This database is marked as “Read Only” and Epicor application forms cannot be updated. The main purpose of this type of database is to offload query functions, such as dashboards and reports.
D.2 UnInstall Epicor Replication Server
If you have a previous version of Epicor Replication Server installed, use these steps to review options and then uninstall Replication Server.
Review PROPATH Option
Use these steps to review your Progress Explorer Tool PROPATH option if you have a previous version of Epicor Replication Server installed.
1. Open the Progress Explorer Tool.
2. Select Properties.
3. For the PROPATH option, the value contains a comma delimited list of folders.
Open the folder that ends with BPM.
4. Navigate to the Snapshots subfolder.
5. Delete all contents of the Snapshots folder.
6. Exit from the Progress Explorer Tool.
UnInstall Epicor Replication Server
1. Select Start - Control Panel - Add or Remove Programs.
2. Select Epicor Replication Server and click Remove.
3. Verify that Epicor Replication Server has been uninstalled.
D.3 Install Epicor Replication Server on a Server
Use these steps to install Epicor Replication Server on a server that will host one or more subscribing replicated databases
1. Go to the directory where your Epicor application is installed. For example, go to
\Epicor Software\Epicor905.
2. Double-click on the EpicorUtilities.exe file.
3. On the Welcome to the Epicor Utilities Setup wizard, click Next.
4. On the Epicor Utilities Setup dialog, click one of the following to start the
installation:
- For a 32-bit system: Click Install Replication Server 32 bit. - For a 64-bit system: Click Install Replication Server 64 bit.
5. On the Welcome to the Epicor Database Replication SetupWizard, click Next.
6. For the TCP/IP settings accept the Default Port 11111 or select another port.
7. Select a Destination Folder and click Next.
9. When the installation is complete, click Close.
10. Navigate to Start - Control Panel - Administrative Tools - Services. 11. Highlight to select the Epicor Database Replication Server service. 12. Click Start this service.
13. Verify that the status of the service is Started.
D.4 Verify Prerequisite Configurations
Use the following steps to verify installations and configurations of prerequisite software.
1. Verify that Sonic MQ 7.6 has been installed and properly configured.
Note! Sonic MQ 7.6 is required, but it is not included in the Replication Server installation.
2. Configure the Replication Server Services. To do this:
- Select Start - Control Panel - Administrative Tools - Services. Select Epicor Database Replication Server.
- Change the Service logon account to be a domain account.
- Verify that the TCP/IP port used by the Replication Management Console to connect to the server is not in use. To do this, open a command prompt window and type: netstat -na|more. The port is specified in the
Epicor.Mfg.Replication.Server.WinService.exe.config file located in the server installation folder.
D.5 Configure using the Epicor Application
Use the following steps to configure Replication Server using the Epicor application. See the Epicor application help system for more detailed steps, if necessary.
1. Create one or more replication profiles. To do this:
- Log into the Epicor application.
- Go to System Management - Replication - Replication Profile Maintenance. - Click New. Enter a profile and description. Click Save.
Note! If you use Epicor EPM (Enterprise Performance Management), you can review the “zEPM” profile. This profile contains the tables required by the four EPM content packs available with this release.
2. Verify the Replication settings values related to Sonic. To do this: - Go to System Management - Replication - Replication System
Maintenance.
- From the Tools menu, select Settings. The Replication Settings dialog opens. - Review the following fields:
Sonic Topic Prefix. Identifies the ID linking the publisher and subscriber. Copy and paste this value into the same field on the Replication Server Publisher Properties tab. Note that the System ID is used as a part of Sonic Topic Prefix. This value can be changed, however it should remain unique among all publishers feeding data to the same replication server.
Sonic LAN Host Name. Displays the IP address or host name of the machine running Progress SonicMQ server.
Sonic Administrator Password. Displays the password of the Sonic administrator. The value is displayed in non-encrypted format.
OpenEdge Name Server Port. Displays the number of the OpenEdge name server port. This value can also be copied from the name server Properties dialog box. To access the name server Properties dialog box, open the Progress Explorer Tool. Connect to the machine, on which the Epicor 9.05 application server is installed. Expand the Name Server node. Right-click the name server and select Properties. Copy the value in the Port number field.
Sonic Broker Port. Displays the value of the Sonic broker port. This value can also be looked up in the Sonic MQ Domain Manager log. For example, the Sonic Broker Port is marked in bold below:
[09/07/24 11:42:27] (info) Management connection (re)established (Socket[addr=localhost /10.7.92.225,port=2506,localport=1714])
Max Records Per Message. Displays the maximum number of database change records, which can be sent by the Replication Log Reader process to the Replication Server in a single Sonic message.
Sonic Connection Protocol. Select the protocol used by the publishing Epicor 9.05 system to connect to the Sonic server. Available values include: TCP, SSL, HTTP, HTTPS
3. Assign the created replication profiles to one or more companies. To do this:
- Go to System Management - Replication - Replication System Maintenance.
- In the tree view, select the company to which you want to assign a profile. - In the Available Profiles list, select one or more profiles, which you want to
assign to the selected company. Click the Add (arrow) button. Click Save. - If required, select another company and assign profiles.
4. Configure the Replication Agent process. To do this:
- Go to System Management - Replication - Replication Agent Process. - For the Continuous Processing Delay, enter the time interval (in minutes) for
starting up the task, produced by this process.
- For the Log Filename, enter or browse for the file, where replication agent data is to be stored.
5. Configure the Replication Log Reader process. To do this:
- Go to System Management - Replication - Replication Log Reader Process. - Select the Continuous Processing check box if you want the task to run
continuously, with the interval, specified as the value of the Continuous Processing Delay parameter.
- For the Log Filename, enter or browse for the file, where replication log reader data is to be stored.
- Select the Recurring check box to indicate that the process should be run on a repeating basis. This check box is available only if a schedule other than Now is selected.
- Select the Schedule option during which you would like the process to run. Options include Now, Startup Task Schedule, and any other user-defined schedules created for your company.
6. Use the Progress Explorer Tool to stop, and then restart the server.
7. Verify that the log files produced by the Replication Agent and Replication Log
Reader do not contain errors.
D.6 Configure using Replication Management Console
Use the following steps to configure Replication Server using the ReplicationManagement Console. See the Replication Management Console help system for more detailed steps, if necessary.
1. Open the Replication Management Console.
Note! Verify that the Sonic Topic Prefix setting in the Publisher properties matches the Sonic Topic Prefix indentified as a Replication Setting in the Replication System Management program.
3. Select a subscribing database. Types include AdHoc, Functional or other.
4. Select a Subscriber Class. The subscribing database is represented by a Subscriber
Class entity.
5. Add a Target Database. A target database includes connection information for the
subscribing database.
6. Add a Subscriber instance. A subscriber instance links the target database to the
publisher.
7. Define filters to specify which tables and companies should be received by the
subscriber instance.
8. Initialize the Subscriber Instance. Initializing the subscriber instance creates tables
in the target database and copies the existing data to the target database.