Customer Export Requirement

Objective

Export the Customer master data from the partition into a CSV file using an IM Template. You should properly map the customer attributes from the master table into the CSV columns and export to folder location on the SFTP server.

Resources

Use the following data sources and structures for this task:

• Customer Data

o Customer Master

• CSV Data:

o Export_Customer CSV file

Data Layouts

There are multiple files related to this requirement and below are the layouts of the CSV files.

Layout of the Export Customer CSV file:

• Customer ID

• Customer Name

• Account Group

• Top Level Hierarchy

• Top Level Hierarchy Name

• Parent Field

• Parent Field Name

• Continent

• Region

• Country

• Address

• Zipcode

• Product Line

• City

• State

• Classification

• Industry

• Customer Segment

• Currency

• Sales Org

• Customer Rank

• Sales Person

• SFDC Customer

Acceptance Criteria

Develop a solution using the export IM template(s) that successfully migrates the customer master data into a CSV file. Your solution should contain the following components:

1. PlatformManager/IntegrationManager:

a. IntegrationManager Instance and companion SFTP server

b. Outbound SFTP folder(s)

c. Utilization of case study partition

d. Utilization of IM template(s) to create:

i. Mappers

ii. Routes

iii. Connections

Â