appINTERFACE orchestrates data exchanges using FTP Service, appLOAD Service or SOA Service. It is a web based product completely compatible with the cloud and is capable of accepting data from and delivering data to an unlimited number of source and target systems.
appINTERFACE supports data integrations in Batch, Asynchronous and Synchronous modes. It handles very large volume of data and complex business validations. Synchronous Integrations with data exchange in less than 3 seconds have been achieved.
No programming needed
Intuitive and easy to use
250+ Configuravle Adapters
Scalable Data Management
Ready for Fusion Applications
Available in SaaS, Cloud
appINTERFACE supports SQL Extractions which can be built using a wizard or through SQL queries. Databases successfully supported include Oracle, SQL Server, DB2, Progress, Informix, Clipper, IBM AS/400, Ingres, IMS, MS Access, Sybase, Teradata, Unify etc.
More complicated extractions can be performed using PL/SQL procedures. This is applicable only for Oracle Databases.
appINTERFACE also supports extractions using Java Methods and Web services. It can process data from secure FTP servers. Some of the data formats supported includes XML, CSV, XLS, and XLSX. The product supports incremental data extraction using Audit Trails and Database Streams. (Change Data Capture)
appINTERFACE provides a powerful logical data transformation tool, capable of logically modifying existing data or creating data in predefined fields. For example, if a different general ledger account is used in the source system, appINTERFACE makes the necessary data transformation.
appINTERFACE includes a number of tools to support data cleansing. Data can be compared to locate duplicate records with alias key identifiers based on sound, key words (Levinstein Distance Method) and custom configured logical relationships.
All objects and attributes in the data mart are available for edit if needed.
An audit trail is created for all changes.
appINTERFACE provides ready to use Web Services for Inbound and Outbound Interfaces for Oracle E-Business Suite or SAP. These Web Services are highly secure and data is encrypted during transmission.
appINTERFACE will perform prevalidation of the data in the data mart using the same criteria as the target instance.
Additional rules may be added to the appINTERFACE prevalidation.
An on-line error report is presented and the user may make corrections as required.
A tool to assist in the correction of errors (by suggestion) is also provided.
All data correction information is collected, maintained and is available in an electronic document form.
When Oracle EBS is the target, appINTERFACE uses standard EBS Application Programming Interfaces (APIs) and ensures that data is validated in accordance with the EBS rules. Where standard APIs are not provided by EBS, appINTERFACE uses custom APIs and Open Interface Rules.
For Siebel as target, appINTERFACE uses EIM/EAI, for Salesforce it uses bulk APIs and for SAP it uses BDC/BAPIs.
Load executions may be scheduled automatically using Secure File Transfer Protocol (SFTP).
Synchronous load supports real time integration.