Importer is a companion product to i-Recs and automates the translation of reconciliation data passed between you, your trading partners and your service providers.
An intuitive, flexible and generic tool providing complete control over the reading and forwarding of data files from prime brokers, custodians and administrators, and the preparation of outbound data for transmission to clients, to management or uploading to other systems.
Importer allows the creation of a file definition containing the layout and content of source or destination data, whether in a database, a text file or Excel files. Any ODBC database can be read from or written to. Any style of text file can be defined, including delimited and fixed format. Complex layouts of source files can be read including header and footer blocks.
Importer maps contain the logic required to translate between a source and a destination definition. Maps contain sequential programming steps including mathematical, string, logical and data reference and lookup functions. At run time data is read from the source using the inbound definition, map steps are sequentially interpreted, and translated data is posted to the destination using the outbound definition.
Maps can be designed and fully tested prior to publishing. Revisions can be applied to published maps, and tested before republishing. All versions are retained by the system providing a complete audit trail.
Maps can be executed using Importer, from within i-Recs by reconciliation staff, or automatically based on the receipt of a data file in a specified location or scheduled to run as required. All execution steps are written to a comprehensive audit trail, including skipped rows or user defined warning and error messages.