Tables in the Import Export Module

This chapter describes the tables that make up the Oracle Identity Analytics Import Export module.

IMPORT_RUNS Table

Structure

Index

Description

The IMPORT_RUNS table stores information about the Oracle Identity Analytics user interface while imports are taking place. It records the unique ID of the import and other valid details such as the SOURCE of the import, the IMPORT_TYPE, the START_TIME, the END_TIME, the number of records imported, and the number of accumulated errors.

Primary Keys

PK_IMPORT_RUNS - primary key on column IMPORT_ID

Foreign Keys

None

Indexes

None

IMPORT_RUN_STEPS Table

Structure

Index

Description

Importing data into Oracle Identity Analytics may require several steps. Information about each import step is stored in the IMPORT_RUN_STEPS table, where the IMPORT_RUN_ID column refers to the IMPORT_ID column located in the IMPORT_RUNS table.

Primary Keys

PK_IMPORT_RUN_STEPS - primary key on column IMPORT_ID

Foreign Keys

None

Indexes

None

IMPORT_VALIDATION_EXCEPTIONS Table

Structure

Description

Oracle Identity Analytics can connect to a provisioning system and import accounts from that system. Any exceptions that occur during this process are stored in the IMPORT_VALIDATION_EXCEPTIONS table. The type and description of the exception are also stored in the table.

Primary Keys

None

Foreign Keys

None

Indexes

None

EXPORT_RUNS Table

Structure

Index

Description

While exports are taking place, the EXPORT_RUNS table records information about the Oracle Identity Analytics User Interface. It records the unique ID of the export process and other valid details, such as the type of export, the start and end times, the number of records exported, and the number of accumulated errors.

Primary Key

PK_EXPORT_RUNS - primary key on column ID

Foreign Key

None

Indexes

None