Synchronization

Synchronizing a large number of records (in the millions) takes a considerable amount of time.

If you have millions of records, consider whether the history of synchronization is really needed and if the history is not required, use the database dump workflow with the ExtractDataToDelimitedFile activity. Alternatively, use the data extraction framework provided through DBExtractor.

You can read data directly from the database tables using an ETL tool such as Kettle.