Synchronizing Data Using Enterprise Data Integration (EDI)

EDI is used to synchronize data from Active Directory, Microsoft SQL Server, MySql and Oracle database to the ICPAM database. This section includes instructions to do the following:

·         Install the EDI license on the ICPAM server.

·         Download and install the EDI Studio desktop application on your PC.

·         Use the EDI Studio to define integration projects, including the database connection, schema, and synchronization schedule.

·         Import the data integration project file into ICPAM using the EDI Administration module.

·         Monitor and troubleshoot data integration events using the EDI Monitoring and Error Monitoring modules.

Complete the following instructions to create, run, and monitor EDI integration projects:

·         Before You Begin

·         Understanding Photo File Compression When Importing Personnel Records

·         Installing the EDI Licence and Desktop Application

·         Creating Active Directory Database Integration Projects Using EDI Studio

·         Creating SQL and Oracle Database Integration Projects Using EDI Studio

·         Importing, Starting, and Monitoring EDI Projects in ICPAM

o       Importing and Starting EDI Projects

o       Verifying EDI Projects (EDI Monitoring)

o       Modifying a Running EDI Project

o       Restarting a Failed EDI Project

o       Summary of EDI Administration Functions