This chapter includes the following sections:
Oracle Data Integrator (ODI) seamlessly integrates data in a Microsoft Access database. Oracle Data Integrator features are designed to work best with Microsoft Access, including mappings.
The Microsoft Access concepts map the Oracle Data Integrator concepts as follows: An Microsoft Access database corresponds to a data server in Oracle Data Integrator. Within this server, a schema maps to an Oracle Data Integrator physical schema.
Oracle Data Integrator provides the IKM Access Incremental Update for handling Microsoft Access data. This IKM integrates data in a Microsoft Access target table in incremental update mode.
The IKM Access Incremental Update creates a temporary staging table to stage the data flow and compares its content to the target table to identify the records to insert and the records to update. It also allows performing data integrity check by invoking the CKM.
Consider using this KM if you plan to load your Microsoft Access target table to insert missing records and to update existing ones.
To use this IKM, the staging area must be on the same data server as the target.
This KM uses Microsoft Access specific features. It is also possible to use the generic SQL KMs with the Microsoft Access database. See Generic SQL for more information.
When reverse engineering MS Access, primary keys are not retrieved. Primary key constraints have to be added manually to the datastores for IKM Access Incremental Update to work correctly.
Note:Microsoft Access supports only the Standard reverse-engineering and its capabilities entirely depend on the driver being used.
There are no specific requirements for using Microsoft Access in Oracle Data Integrator.
Note:ODI does not come with a driver to use Microsoft Access and you have to acquire one from third-party vendors.
To install drivers from third-party vendors, refer to:
For ODI Studio — Adding Libraries to ODI Studio
For Standalone Agent or Collocated Agent — Adding Libraries to a Standalone or Standalone Collocated Agent
JEE Agent — Adding Libraries to a Java EE Agent
To know more about the supported data types, refer to Microsoft Access documentation.