The SQL Replication provides near real-time replication of the core Eclipse Universe files to SQL Server. This technology is built into the core Eclipse architecture and utilizes the Epicor Data Warehouse platform for fast and efficient replication of data.
After installing the Data Warehouse platform, register the Eclipse system with the Data Warehouse and enable replication. The Data Warehouse can support multiple Eclipse instance registrations against it. Each Eclipse instance that is registered with the Data Warehouse receives a unique SQL database created and assigned to the replication of that Eclipse instance.
The Data Warehouse platform that was installed to support Eclipse SQL Data Replication must be configured in Eclipse. Enter the IP Address and port where you installed the Data Warehouse. The Data Warehouse utilizes two ports: one for the Application Programming Interface (API) and one for the Data Replication.
To enable replication and configure the SQL server:
From the System > User Custom Menu menu, select SQL Server Configuration to register the Eclipse instance with the Epicor Data Warehouse.
Complete or modify the fields, as needed:
Field |
Description |
IP Address |
Enter the IP Address and port where you installed the Data Warehouse. |
API Port |
Modify the port ID for application programming interfaces (API), if needed. The system defaults to the an assigned port, such as 8180. |
Data Port |
Modify the port ID used for and data replication, if needed. The system defaults to the an assigned port, such as 3000. |
Domain |
Enter the unique domain name that was assigned to your company from Epicor. This domain name is the same domain used when installing the Data Warehouse platform. |
Database Name |
Name the SQL database that you want created during the registration on the SQL Server. Note: We recommend naming the server so as to identify the instance clearly, such as PRODUCTION or TEST. |
Login |
Provide the user name and password of an Eclipse system account that you would like to use for communication to the Data Warehouse. Note: This user setup in Eclipse with full system privileges. |
Password |
|
Shared Key |
Enter the Shared Key that was created for the Eclipse system. You can access this key by going to the following link: http://[youreclipseserver]:2080/ds/home |
See Also: