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
Â