Most substantial enterprises, which have been in business for 20 years or more, now find themselves with a complicated IT infrastructure. They have a number of core business systems that are based on different technologies, some old, using proprietary languages and legacy data structures, some new, usually based on .NET or Java and using RDBMS data.
One of the challenges facing businesses in this situation is that, in order to maximize operational efficiency, and enable timely access to data for reliable business intelligence, they need to find ways of enabling integrated access to all of the business data, whatever the source.
Transoft was recently contacted by a company in this situation. They have a 20 year old custom-built application, operating on legacy data structures, that is absolutely fundamental to the operation of the business. Their problem was that they were unable to easily and efficiently extract data for business intelligence and also had problems in integrating the legacy data with new business systems.
In many cases, application integration tools provide the solution to these problems but, in this case, with no access to the source code of the application, options for application integration were very limited.
An alternative approach, provided by Transoft’s DBIntegrate, is to capture changes to the legacy data structures, as they happen, and use those changes to keep an integrated BI database synchronized with the operational data in ‘near real-time’. DBIntegrate Data Sync has been designed to ensure minimal impact on the operational system while updates to the RDBMS happen just milliseconds after the operational data is updated.
DBIntegrate has now been deployed at the company in question. A SQL Server database is updated with operational data captured from the legacy system, cleansed and transformed to provide real-time data quality controls. The SQL Server database provides the basis for BI reporting and also enables integration with other systems, without having any impact on the operational systems.
Click here to find out more about our solution.
Data Synchronization.pdf (1.39 mb)