Business Integration Solutions Documentation

Walkthrough: Customer Replication

About this walkthrough

This walkthrough provides an overview on how to synchronize customer master data.

In this replication scenario, we demonstrate how you can publish the NAV data in a different XML structure and also how you can subscribe to it.

Prerequisites

You can choose to create two companies for demonstration purpose. In the following scenario we have:

• CRONUS International Ltd. [as a Publishing Company]
• CRONUS Sales [as a Subscription Company]

Template	Description	Type	Company
TI_RM_CUSTOMER.OUT	STAEDEAN Template-Publish Customers for Synchronization	Publication	CRONUS International Ltd.
TI_RM_CUSTOMER.IN	STAEDEAN Template-Subscribe Customers for Synchronization	Subscription	CRONUS Sales

Template - Publish Customers

Story

• This connection uses the Timer Event to trigger the Pipeline.
• The Connection contains an XML Generator which creates an XML-file, based on the internal document.
• A Mapper is used to map the internal document to an external document to help export the NAV data in external structure.
• The created XML-file is stored on a file location by the File Writer Endpoint.

Setup

1. Select the publishing company.
2. Import Publication-TI_RM_CUSTOMER.OUT.zip configuration package.
3. Open the TI_RM_CUSTOMER.OUT connection. On the connection page, edit the File Writer settings and provide the Folder Name.

Process

1. Process the connection.
2. Check the output folder location.

Result

One XML-file with a complete overview of your Customers is created and available on the specified location.

Template - Subscribe Customers

Story

• This connection uses the File Reader Endpoint to read the published file from the file system.
• The XML-file contains a complete list with Customers, so for a proper traceability the Splitter Activity is added to the connection.
• The Mapper Activity maps the external document to internal NAV table structure.
• The Record Generator Activity creates records and updates the NAV tables (Customer, Gen. Business Posting Group and VAT Business Posting Group) based on the internal document.

Setup

1. Select the subscription company.
2. Import Subscription-TI_RM_CUSTOMER.IN.zip configuration package.
3. Open the TI_RM_CUSTOMER.IN connection. On the connection page, edit the File Reader settings and provide the Folder Name.

The File Reader Endpoint contains some typical Replication Management properties, like Leave File on File System, Read New Files Only and Last Processed at. In many cases the Internal Document from the Publication Connection can be reused for the Subscription Connection.

Process

1. Process the connection.
2. Check the Transaction Log to see more details.

Result

The Customers are imported. You can also use the Transaction Log to see more details for each import.