To read data from Adobe Experience Platform and write to a flat file, perform the following tasks:
Create an Adobe Experience Platform connection to read data from an Adobe Experience Platform source.
Create a flat file connection to write data to the flat file.
In Data Integration, click
New
Mapping
Create
.
The
New Mapping
dialog box appears.
Enter a name and description for the mapping.
Add a Source transformation. Specify a name and description in the general properties.
On the
Source
tab, perform the following steps:
In the
Connection
field, select the configured Adobe Experience Platform connection to connect to Adobe Experience Platform.
In the
Operation
field, select an object or a dataset.
The following image shows the source objects and datasets:
In the
Request Options
section, specify a blank JSON object {} .
The following image shows a blank JSON object in the request message:
In the
Advanced
section, you can set the start time and duration for which you want to read the data.
On the
Field Mapping
tab, select the elements that you want to map to the output fields.
The following image shows the response structure on the left pane in a hierarchical format and the output groups on the right pane in a relational format:
The output groups and primary and foreign keys are auto-generated.
Add the Target transformation. Specify name and description in the general properties.
Select a flat file connection for the target transformation.
Draw a link to connect the Adobe Experience Platform source to the flat file.
The following image shows the Adobe Experience Platform mapping: