AudienceView Connect

How the Dataloader Works

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.