08-16-2017, 11:00 PM
Enterprise Database Integration implies the ability to access relational and non-relational data sources from back end systems such as Oracle, DB2, SQLServer, Essbase, and VSAM, from a common framework using one tool or set of tools. Access to the data is usually in the form of a query, but can also include update capabilities, and can happen in bulk, real-time, or near real-time.
The proposed system is made possible using intelligent data adapters that contain logic and metadata to perform simple or complex SQL-based data manipulation against target systems.
The adapters can provide statistics on their usage and performance characteristics, and when used in ETL processes a full audit trail can be achieved from source to target. The result is easier data warehousing, ETL process development, EAI, BPM, business intelligence, and application development.
The proposed system will accelerate business integration by simplifying it dramatically - eliminating custom integration code, and replacing it with the straightforward assembly and configuration of off-the-shelf components. The system will provide everything necessary to achieve real-time, near-real-time, or batch integration more quickly and easily than competing tools and the "roll-your-own" approach.
This system can develop using J2EE or .NET