Importing Data into Aprimo

Use these System Tools modules to import data from an external database into Aprimo:

  • In the Databases module, configure the external databases that contain the data to import. When you configure a database in the Databases module, you define how the application connects to it.
  • In the Data Sources module, define the data to import into the application. When you create a data source, you perform these actions:
    • Specify the database that contains the data source.
    • Create the SQL statement used to query the database.
    • Define the field mappings between the fields in the data source and the destination fields in the application.
  • In the Data Cleansers module, clean or validate data prior to loading it into the application. Before you can associate a data cleanser with a data source, you must create the data cleanser in the Data Cleansers module. You can also use data cleansers when importing inbound form data.
Note:
If you want to use data from an external database in a segmentation, use the Databases module in Campaign Administration.
  1. If you want an OLE database connection, configure an OLE database.
  2. If you want a native database connection, configure a native database.
  3. If you want to use a custom or third-party data cleansing program, follow its directions.
  4. If you want to use the application's data cleansers, cleanse the data.
  5. In the Data Sources module, define the data to import.
  6. Validate the data source.
  7. Start the data source.
  8. The application begins the import process according to the schedule information you configure for the data source.