Updated: July 13, 2020 7:33am

Day-to-Day Replication

Day-to-Day (D2D) Replication refers to the sending of data on a regular basis between two Prism servers (or between the Prism HQ server and its RIL Oracle database). Whereas initialization is typically a one-time operation that replicates all available data, Day-to-Day replication is typically more focused, sending only a subset of data types, i.e. data types that are likely to have new or updated records.

D2D replication is carried out by creating a profile that includes the desired resources and then linking that profile to the appropriate connection. When creating profiles for D2D, you can select only those specific resources needed by the receiving location. This reduces the time and computing resources required. Resources that are unlikely to change, like Departments or Vendors, can be excluded from D2D. You can use the Advanced Filters feature to apply fine-grained control over the specific records that are replicated. You can create as many profiles as you need and assign the profiles to connections on an as-needed basis. Remember, the profiles you create must be assigned to an active connection before any data included in the profile will be replicated. In addition, a profile must be linked for each direction in which data will be replicated.
Note: In certain situations (e.g. a small data set), the same profile that is used for initialization can also be used for D2D replication.

Day-to-Day Replication Guidelines

D2D between PrismHQ and RIL Oracle
At the PrismHQ installation, you will need to create a Prism to RIL profile for replicating data from PrismHQ to RIL, and a RIL-to-Prism profile for replicating data from RIL to the PrismHQ. The Prism-to-RIL profile should include Documents, Customers and X/Z-Out reports. The RIL-to-Prism profile should include any data types regularly created or updated in RIL like inventory, departments, vendors, purchase orders, etc.

D2D between PrismHQ and non-root POA or Store Server
The PrismHQ will need a Prism-to-Prism profile for D2D replication with subordinate systems (child POAs or store servers). Depending on the retailer's needs, the same D2D profile could be linked to multiple connections, or a custom profile could be created for each connection. The D2D profile for sending data from PrismHQ to subordinate systems may include resources like inventory, adjustments, purchase orders, and any other resources needed by the subordinate systems. The subordinate systems will need to create a Prism-to-Prism profile to send data back to the PrismHQ. This will typically include Documents (transactions), Customers and any other records needed by the PrismHQ server.
At the non-root POA or store server, create a Prism-to-Prism profile for sending data from this server to the POA server (named something like "POA1-to-PrismHQ D2D").

D2D between non-root POA and Store Server
A non-root POA will need a Prism-to-Prism profile to send any new or updated records down to the store servers. A store server will need a Prism-to-Prism profile to send documents, new customers and other info generated at the store server up to the POA.