AudienceView Connect
AudienceView Documentation

Using the Dataloader

The dataloader is an application that allows organizations to load large quantities of organization data into the AudienceView database. The use of the dataloader makes the process of entering large amounts of transactional data into AudienceView more concise and less time consuming. The dataloader performs a high-speed loading of information by circumventing the presentation layer of the application and works directly with the application layer and its underlying functionality.

By using the internal AudienceView operations in the application layer, this ensures that all data is integrated properly into the database, ensuring that all data records and entities are logically entact. All connections between data entities and all system-created identifiers and GUIDs are created as if a user was entering the data via the presentation layer and the UI. The difference is that the information is entered much faster.

Typically, it is legacy customer and order data that is loaded into AudienceView using the dataloader. However, any large amount of data can be added into the system as long as the same information could be added manually by a user. More generally, if the data entity to be loaded already has a business object (BO) and a collection object (CO), the dataloader can be used to load the data related to that object.

To use the dataloader, you must create a control file that lays out the data that is to be entered. The control file organizes the data that is entered via the data file and interfaces with the AudienceView application layer to enter the data.

It is critical that the control file is created correctly in order to ensure that data is imported properly. Work with your System Delivery representative to ensure that the control file is created correctly.

It is also critical that the control file and associated data file are loaded onto the server in a specific folder or else they will not be made available for use in the dataloader. Again, ensure that you have consulted with your System Delivery representative to ensure that the files reside in the appropriate folder on the server.

The AVScheduler service that runs on your server is used to run the dataloader. Ensure that the AVScheduler user (sched in most cases) has the necessary permission(s) to log in and performn the commands identified in the control file.

The following sections describe how to work with the dataloader: