2021.1

The DataMapper
The DataMapper is the tool to create a data mapping configuration. Data mapping
configurations are used to extract data and transpose that data into a format that can be shared
amongst different layouts and outputs created with the OL Connect Designer and Workflow.
The original data, located in a file or database outside of OL Connect, is called a data source.
The first step in the data extraction process is making settings for the input data (see "Data
source settings" on page224), including boundaries for each record inside the data sample.
When you define the boundaries, you are actually defining a series of records inside your data
sample file.
After configuring these settings you can start working on the logic to extract data from each of
those records. You need to identify and extract data from each record. To achieve this, you will
create a data mapping workflow, consisting of multiple steps (extractions, loops, conditions and
more) (see "Data mapping workflow" on page221 and "Extracting data" on page231).
When this process is complete, the result is a Data Model. This model contains the necessary
information to add variable data to OL Connect Designer templates. (see "The Data Model" on
page267 for more information). It has a generic format with an emphasis on content, free from
any restrictions imposed by the file types or the origin of the data. This allows a same layout or
output to be populated with data from different sources and formats without the need to modify
it.
DataMapper basics
Connect’s DataMapper lets you build a data mapping workflow to extract data from a variety of
data sources. The data mapping workflow consists of multiple 'steps' which process and extract
data from each record of a data source and store it in a new, extracted record set. The data
mapping workflow is saved in a data mapping configuration.
1. Create a new data mapping configuration.
Run the Designer and start creating a data mapping configuration by selecting a data
source. See "Data mapping configurations" on the next page.
2. Configure settings for the data source.
The data source can be a file (CSV, PDF, TXT, XML, JSON) or a particular database.
Configure how the data source is read by the DataMapper and create a record structure.
See "Data source settings" on page224.
Page 196