Source System Direct Connections

Companies are increasingly requesting the ability to query source systems directly to obtain data instead of creating flat file extracts that users then manually load into target systems. Finit Solutions has helped many companies develop integration scripts that directly query general ledger systems, staging tables and data warehouses to extract data that is then imported in to FDM. Points to consider regarding source system integration include:

• The process can be developed using the standard FDM user-driven "4 fish process" or by utilizing FDM's batch processing functionality.
• The combination of direct source system integration and FDM batch processing can result in a completely hands-off process in which there is absolutely no manual user intervention between the source and target systems.
• Once the source system integration script is created, it executes the same way every time; there is no need to worry about the user extracting a file in an incorrect format or using incorrect parameters.

Finit's clients use source system integration to greatly improve the controls around the data extract and load process.