The Dataloader Interaction with the Application Layer
The dataloader uses all of the existing AudienceView application functions to load large amounts of data into the AudienceView database. This is performed using a control file, an XML document that details the layout of the data file that contains the information to be loaded.
The data file contains all of the physical records that are to be added into AudienceView. The data file comes in a tabular form, typically in a comma-separated values (CSV) format. The fields of information in the data file are labelled appropriately so that the control file is able to extract the data row-by-row and enter the data into AudienceView.
A data file used to enter customer users may look like this:
| customer_id |
default_contact_id |
language |
user_name |
password |
group_id |
role_id |
| CED4ED34-1DA3-40E6-A8FC-DABD2A8FD78B |
52608EED-9F79-444C-848C-B40C4913F3AA |
EN |
username |
password |
4DE22789-DA95-492C-AFA8-6BBEC7CBF6EF |
F40B86E3-317C-4AE7-B69C-C32B14B24602 |
The dataloader uses the control file to determine the layout of the necessary information that is used as input for the application operations in the application layer. The control file then brings the data elements listed in each row of the data file one by one and uses the AudienceView operations to load the data into the database quickly while maintaining the database integrity by ensuring the proper links are created.