Data export process

Data is exported by the ChangeDataExport agent. A single agent is responsible for FULL and DELTA extractions, and for publishing the name of the exported compressed files to the CHANGE_DATA_EXPORT.PUBLISHED event.

The agent criteria has the “Sync Type” specified as either FULL or DELTA. You must configure separate criteria for each mode of data export and run agents with those criteria at scheduled intervals. For a DELTA export to work, you must enable Change Project Management.

When the agent runs in DELTA mode, it searches the YFS_ENTITY_CHANGE table for an organization code that matches the enterprise or enterprises for which the agent is being run. The profiles are used to determine in which zip file a given change will be published. When the agent runs in FULL mode, it exports data based on the profiles defined for the enterprise or enterprises for which the agent is being run.

Note: Configuration data is not filtered, but included in its own profile.

If Sync Type is selected as Full or Delta during the Sync Profile definition, the CHANGE_DATA_EXPORT agent will only consider the sync profiles whose SyncType matches the Sync Type passed in the CHANGE_DATA_EXPORT agent criteria parameters.

For a FULL extraction, Master data is categorized by TableGroup and then extracted into profiles according to the defined filters. All the database records that match the profile filters are extracted to create a complete snapshot of the database contents at the time of extraction.

For a DELTA extraction, the records that were created since the last DELTA are considered and the data is filtered into profiles. Entities that do not have any changes are not included in the extraction.

For additional information about Change Project Management, search for the topic "Change Project Management."