
Dedicated tools are used to integrate systems by sharing data between users, organizations and applications from common database allowing different data types. These data types could be in the form of tables, documents and data sets which are to be merged by the users, organizations and applications are known as database based integration tools. Database integration indicates the capability to access the data from any source which is present inside or outside the organization and use this information in virtually any system or application. The data stored in database could be in formats such as VSAM, Oracle, MySQL, DB2, FOCUS db, SQLServer and Essbase. Some of the key benefits of database based integration tools are reduction in the development cost of organizations, increase in the data handling speed, reduction in the time required to execute business processes and products' or services' time to market. Other than real time data integration, these tools also enable data replication and verification between operational and analytical enterprise system, transformations and transactional change data capture.