Delivering on its commitment to help data professionals enhance the availability, integrity, and security of data assets, Embarcadero? Technologies, Inc. (Nasdaq: EMBT), a leading provider of strategic data management solutions, today announced the latest release of Embarcadero DT/Studio?, its award-winning model-driven ETL solution. With new advanced data modeling capabilities, DT/Studio simplifies data source analysis and facilitates clear communication across the organization to ensure data consistency and accuracy. DT/Studio 3.0 also includes advanced clustering and parallel processing capabilities to meet large data load demands, improve server efficiency, and ensure future scalability. Enhanced monitoring and troubleshooting capabilities help to deliver high availability of mission-critical production environments. With the focus on design and development combined with a highly scalable production engine, this major new release further reduces the upfront time required to integrate information, helping to lower development costs and improve data integrity.

"Data professionals face an uphill battle when it comes to visualizing, understanding, and modeling metadata and large data volumes silo-ed in different systems. Without a strategic approach to data management, the accuracy, security, and availability of data is at risk," said Greg Keller, vice president of product management, Embarcadero Technologies. "DT/Studio 3.0's robust new dimensional modeling and scalability features, its flexibility, ease of use, and integration with other Embarcadero solutions like ER/Studio? make management of data integration teams and execution of projects far more efficient."

"Our customers look to TIBCO to provide robust, scalable solutions to integrate information and business processes across the enterprise," said Matt Quinn, vice president of Product Strategy at TIBCO. "Embarcadero's DT/Studio 3.0 offers market-leading capabilities that serve as the data integration component of our business integration platform, enabling us to provide customers with more flexible, efficient and productive solutions."

Today, many companies are undertaking initiatives to create an integrated view of their organizational data. Whether they are looking to create data warehouses and data marts to support business intelligence applications, or are looking to create master data references, they need to ensure that the information is accurate and consistent. Data integration solutions such as DT/Studio 3.0 that provide support for understanding data and automating the integration process not only speed the time to delivery, but they can also reduce manual errors to ensure the accurate delivery of information to target systems.

As companies accumulate data at a faster rate than ever before, the need to efficiently process large data volumes makes scalability an important concern in ETL environments. Also, the difficult task of analyzing and understanding existing data structures is the first step in ensuring high quality information. Too often, integration projects are stalled because ETL developers must spend significant time researching how data is currently stored. Embarcadero DT/Studio 3.0's new scalability, monitoring, and dimensional modeling features enable clearer communication across the organization, improve data quality and consistency, and boost productivity.

"Companies maximize profitability leveraging Agile's PLM Analytics applications which allow dynamic visibility and control of the product record. Embarcadero's DT/Studio product and ETL technology is a key component of our PLM Analytics applications," said Ravi Jagannathan, senior director, Product Strategy and Management, Analytics, Agile Software. "Embarcadero's DT/Studio 3.0 will simplify and automate the integration of product-related data residing in disparate locations. Its improved scalability and flexibility allows easy customizations to meet changing business needs and helps companies unlock the value from their product data."

Data and Metadata Modeling, Scalability, Monitoring and Troubleshooting

• Improved Performance and Scalability - Engine-level clustering enables users to meet demanding requirements for processing large data volumes, increases overall throughput and ensures scalability to meet future requirements. Other features include task affinity, which controls the assignment of tasks to engine nodes to optimize use of parallel processing resources, improve server efficiency, avoid bottlenecks, and process data faster.
• Expanded Metadata Capabilities - New dimensional modeling features provide an organized, flexible way to capture de-normalized metadata, and its visual environment and pre-built functionality speed data source analysis, simplify complex development, and reduce project risk. DT/Studio 3.0 captures and represents all aspects of dimensional models to illuminate understanding of data sources and facilitate communication. In addition, import/export metadata allows users to leverage standard formats such as CWM and XMI to ensure consistency and compatibility when collaborating and exchanging metadata between tools and applications. New model synchronization features allow users to simply and accurately keep all of their metadata in DT/Studio synchronized with ER/Studio, with the actual schema residing on the layouts, helping others to easily understand the sequencing of tasks.
• Extended Task Management and Monitoring - Enhanced monitoring and troubleshooting capabilities help to improve understanding of ETL task execution, reduce recovery time, and ensure high availability of mission-critical production environments. Enhanced email notification capabilities provide comprehensive information about task execution to quickly analyze and troubleshoot any issues that might arise and deal with them in an accurate and precise manner. The ability to easily restart tasks at the last point of processing reduces recovery time from failures and ensures that processing time is not wasted. DT/Studio 3.0 provides the ability to monitor clusters and identify which tasks are running on a particular engine, allowing users to optimize performance.

In addition, DT/Studio 3.0 includes extended database connectivity, leveraging native bulk facilities in the latest version of Teradata® for improved performance while also supporting ODBC and JDBC options. Support for Oracle® 10G ensures compatibility with the latest technologies and allow users to leverage new database features. Other new features such as the column map properties provide increased flexibility and simplify the process of extending DT/Studio to create custom data transformations.

About Embarcadero DT/Studio

Embarcadero DT/Studio is a java-based, model-driven data integration solution that facilitates fast access to integrated data. Supporting native and standards-based connectivity to a wide variety of data sources and providing over 1,000 out-of-the-box transformations, DT/Studio simplifies integrating data across disparate sources and enterprise applications, and drastically shortens the time that it takes to develop data integration tasks.