The add-on was designed as a pluggable model with modules being plugged in to support multiple vendors with one module for each vendor. The add-on had a generic interface allowing any vendor to interface with the CRM application.
Multiple data formats were supported by using a XML mapping file for each vendor. Currently, customers like LowerMyBills, LendingTree, and others are supported for day-to-day transactions. CSV, XML formats, and the binary file format from Calyx Point are supported right now. The add-on has been tested for importing 100,000 binary files, 100,000 CSV records, and over 25,000 XML records.
The automated scheduler allows users to configure the import procedure from various vendors using HTTP, HTTPS and FTP protocols either in Push mode or in Pull mode.
The SQL queries have been tuned using the SQL tuning wizard to ensure that response times are within reasonable limits during the import process.