Embarcadero DT/Studio®, a cost-effective, scalable, and easily extensible ETL solution, helps organizations transform, migrate, and integrate large quantities of data from a variety of data sources in weeks, not months. Its visual environment and pre-built functionality speed data source analysis, simplify complex development, and reduce project risk. By leveraging metadata to capture, analyze, and document data assets, DT/Studio improves the quality of data and ensures confidence in data integration projects.

To harness valuable business data that resides in disparate systems across the enterprise, companies need to be able to integrate it. Successful integration requires a thorough understanding of existing data structures and data flow throughout the organization. DT/Studio provides visibility into data sources and the related metadata for reliable integration in less time, with less effort. DT/Studio's Data Flow Designer makes data movement visible, starting from the macro view of sources and targets through to designing and creating the data flow to reduce errors and increase productivity.

As data grows in volume and importance to operations, ETL projects need to scale efficiently. Improperly designed homegrown solutions can destroy or corrupt data. DT/Studio's advanced clustering and parallel processing capabilities support large load demands, improve server efficiency, and ensure future scalability. Detailed automatic email notifications for task failure or completion enable quick and accurate troubleshooting. Tasks can be easily restarted from the last point of processing to reduce failure recovery time and ensure that processing time is not wasted. A high-performance Java-based engine ensures platform-independent performance.

Open APIs and custom transformations allow developers to extend DT/Studio by customizing processes for specific business needs including custom calculations, business logic, or transformers or by interfacing with other applications. New functionality can be added to applications allowing legacy code to be fully leveraged. Using common industry standards, Java and JavaScript, means developers can build on existing knowledge instead of having to learn a proprietary scripting language.

By offering connectivity support for the latest versions of popular database platforms, DT/Studio allows organizations to meet extensive data access requirements without compromising on the use of the latest technologies. Out-of-the-box support for leading relational database platforms eliminates custom connectivity coding, reduces development and maintenance costs, speeds application delivery, and meets enterprise-scale data access requirements.

• Visual Data Modeling and Analysis - Leverages detailed wizard-driven visual interfaces to understand data flows and transformations
• Reverse-engineering Wizard - Creates a data model from a database using a wizard-driven interface
• Data Model Synchronization - Controls, compares, and merges with models in ER/Studio or with actual physical schemas at a granular level
• Dimensional Modeling - Captures and represents all aspects of dimensional models; organizes information into structures that correspond to how analysts want to query data in a data warehouse
• Metadata Import/Export and Integration - Imports from and exports to a wide range of business intelligence platforms, modeling applications, and industry-standard exchange formats (CA ERwin®, Sybase® PowerDesigner®, Oracle® Designer®, Business Objects®, Cognos®, DB2® Cube Views, XML schemas and DTDs, and OMG's CWM/UML XMI)
• Data Profiling - Analyzes the data at any point using both column-level statistics and domain pattern matching

• Visual Data Flow Designer Wizard - Creates transformations by visually diagramming data sources and targets, specifying the data flow, and identifying dependency relationships
• Pre-built Data Transformers - Solve common data integration problems using1000+ ready-to-use transformations
• Reusable Task Segments - Encapsulates common components of transformation tasks (i.e., task segments) and easily shares them across a project
• Visual Task Chain Layout - Manages task sequencing and interdependencies among processes through a visual interface
• Version Control (Tasks) - Enables comparison and rollback of task versions to effectively manage tasks and support regulatory compliance
• Impact Analysis ('where used') - Generates impact analysis reports to update associated tasks when data sources change
• Customized Transformations (Java/JavaScript) - Extends DT/Studio through JavaScript and Java APIs to create custom calculations or transformations

• Engine-level Clustering - Balances tasks and task chains across multiple engine nodes and runs dependent tasks in parallel and manages task assignment at a granular level
• Pure Java-based Engine - Extends the DT/Engine to interface with other applications through migration of the DT/Engine into a J2EE container

• HTML, XML, RTF Documentation - Generates highly-readable data integration reports detailing data models and transformations tasks

• Remote Management - Manages and monitors DT/Studio engines from a single location, even with dispersed business sites
• Task Scheduling - Uses a visual console to schedule and sequence tasks based on the status of preceding tasks
• E-mail Notification Attachments - Attaches logs, error records, and general runtime reports to email notifications
• Task Restart - Restarts a task at the last point of processing if an error causes the task to abort
• Event-based Directory Listener - Automatically extracts and delivers data to the target when a new file appears in the specified directory
• DT/Studio Security Plug-in - Integrates DT/Studio authentication with an organization's own systems through a Java API
• Open Runtime Architecture - Allows DT/Studio to interface with a wide variety of applications through command-line, Java Client, and XML APIs, and through access to the Repository Database
• Cluster Monitoring - Monitors clusters, and identifies which tasks are running on a particular engine to optimize performance

• Relational Databases Platforms - Supports Oracle®, Teradata Warehouse, Microsoft® SQL Server, Sybase®, IBM® DB2®, MySQL®, Informix®, and PostgreSQL databases through JDBC, ODBC, and native bulk facilities
• Change Data Capture (CDC) - Delta Agent - Reduces overhead and improves performance by capturing and sending only changes from the source system to the targets
• Other Data Sources - Supports Java. Message Service (JMS), XML, Flat Files, and Microsoft Non-relational (MS Access, MS Excel)

DT/Engine

• Windows® 2000, Windows XP, Windows 2003 (32-bit & 64-bit), Red Hat® Linux® 6.2 or later, Red Hat Linux AS 2.1 or 3.0, Sun. Solaris. 2.7, 2.8, or HPUX® 10.x or 11.x, IBM®AIX® 5.1 or 5.2
• 600MHz or faster Pentium CPU or equivalent
• 250 MB disk space
• 256 MB RAM, 1 GB recommended

DT/Designer

• Windows 2000, Windows XP, Windows 2003 (32-bit and 64-bit)
• 600MHz CPU minimum, 1GHz recommended
• 128 MB RAM minimum, 512 MB recommended
• 225 MB disk space

DT/Console

• Windows 2000, Windows XP, Windows 2003 (32-bit and 64-bit), Red Hat Linux 6.2 or later, Red Hat Linux AS 2.1, Solaris 2.7, 2.8
• 128 MB RAM
• 100 MB disk space