OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. This is being used to communicate with Excel files. QCommission utilizes a technology called QXchange to integrate to other applications including Excel file. Specific data access plug-ins (DAP) for different systems can be added to QXchange to integrate with various data sources. A special DAP for Excel allows QCommission to exchange data with Excel files.
A key requirement is the ability to only import transactions for the particular commission period that is being currently processed. The QCommission system automatically understands the date range being processed and only brings in the transactions necessary for proper calculations.
In addition to transactional data, QCommission can import master data such as Customer, Item, Vendor, etc. The data imported can include the hierarchy structure. This becomes very useful in calculating commissions based on these various criteria.