Embarcadero Technologies, the provider of application and database lifecycle management solutions, has announced Delta Agent, a new module for DT/Studio, the company`s extraction, transformation and loading (ETL) application.
Delta Agent enables companies to leverage real-time data integration across transactional systems. In addition, the new release of DT/Studio, Version 1.8, includes features such as enhanced operating speed, a debugger and an XML reader for Web services.
Delta Agent is the first real-time ETL application to go beyond transaction data to get a complete picture of all changed data in an organisation.
"Most solutions look solely at message queues to pull data, making real-time data integration possible for only certain tables or databases that are already set up," says Alan Raubenheimer, CEO of Embarcadero Africa. "In contrast, Delta Agent looks at the changed records in the database through the database`s own transaction logs. By operating at the database level, not just message queues, Delta Agent maintains transactional integrity as data is moved across systems."
DT/Studio cuts costs by eliminating the need for customers to buy costly enterprise application integration (EAI) tools to push data into message queues.
In addition to real-time data integration, DT/Studio 1.8 and Delta Agent offer enhanced reporting. Reports created in DT/Studio contain the details and the summaries of the business rules used to extract, transform and load the data, as well as runtime statistics. These reports can now be formatted as HTML, XML or RTF documents, making it easy for integration with third-party business intelligence (BI) tools.
"As initiatives such as business activity monitoring and real-time analytics increase in importance for more companies, dealing with the data requirements in a high-performance and cost-effective manner will be a critical success factor," says Ted Friedman, senior analyst at Gartner.
"By building ETL tools on Java, Embarcadero has been able to increase functionality and usability rapidly without sacrificing speed or performance," adds Raubenheimer.
New features
* Change data capture: Focus on only the data that has changed since the last time the ETL task was run, reducing the data loads and elapsed time for the data movement process.
* Debugger: Browse the data at any point between transformers. The graphical debugger interface allows users to specify any transformer as a breakpoint and view the data streaming between those transformers in watch windows.
* XML Reader: Extract data from XML files. This feature is in addition to the enhancements to the existing readers that allow wildcarding and directory browsing at runtime.
* Increased ease of use: New wizards and dialogues assist with some of the more common tasks such as the creation of pre-populated timestamp fields and sequences.
* Reporting: Generate runtime reports in HTML or XML format from the engine meta data.
DT/Studio allows users to move and operate on data from multiple sources to any target location or application with three simple steps. First, DT/Studio reverse-engineers existing operational data, aided through seamless integration with Embarcadero Technologies` data modelling tool ER/Studio. Once the architecture of the data is established, DT/Studio transforms the data from the original source into the data format established by the user. DT/Studio then populates the target repository or application at the optimum speed required, preventing interruption in enterprise workflow with the operational data.
Share
Editorial contacts