Data Export

The Data Export task enables you to export IdentityIQ data to an external database. You can select to export any combination of identity, account, and certification data.

Before you can use the Data Export task, you must create the export database tables on your destination data source.

The task schedule user interface includes a button that generates a customized DDL which you can hand off to a database administrator for execution. Once the data source parameters are entered, click Generate Table Creation SQL.

Option

Description

Datasource Parameters

Database

Select a database type from the dropdown list.

User Name

Enter the user name parameter of the database table.

Password

Enter the password of the database table.

Driver Class

Enter the driver class used for database.

URL

Enter the URL of the database.

Object Export Options

Export Identities.

Export identity related data. You can perform a full or incremental export. Use the Export Filter field to apply any database filters.

Export Accounts.

Export account related data. You can perform a full or incremental export. Use the Export Filter field to apply any database filters.

Export Certifications.

Export certification related data. You can perform a full or incremental export. Use the Export Filter field to apply any database filters.

After you complete customizing your task options, click Save for later use or Save and Execute to save the task and run it immediately.