Embarcadero Technologies

Embarcadero Technologies

Company type	Private company
Industry	Database Tools, Database administration tools, Software development
Founded	San Francisco, USA (1993)
Headquarters	San Francisco, USA
Key people	Wayne D. Williams, Chief Executive Officer
Products	DBArtisan, Rapid SQL, Change Manager, ER/Studio, Performance Center etc.
Revenue	1000M $ (2007)
Number of employees	270
Parent	Idera
Website	www.embarcadero.com

Embarcadero Technologies is an American software company founded in October 1993 by Stephen Wong and Stuart Browning with just a single database tool for Sybase DBAs — Rapid SQL (released in December the same year). It currently produces tools for database design, development and management, for platforms including Oracle, Microsoft SQL Server, IBM DB2, Sybase and MySQL.

History

In April 2000, Embarcadero Technologies was listed on NASDAQ. In November the same year, the company acquired GDPro, a UML design solution provider. In October 2005, a data security solution provider, Ambeo, was acquired. Two years later, in June 2007, Thoma Cressey Bravo bought Embarcadero and it became a private company. Wayne Williams was appointed chief executive officer of Embarcadero Technologies in 2007.

The company headquarters are in San Francisco with other offices in Toronto, Melbourne, Munich, Maidenhead (United Kingdom) and Iaşi (Romania). The company currently has an annual revenue of $US 60 million and has more than 270 employees.

On May 7th 2008 Borland Software Corporation announced that its software development tools division, CodeGear, was to be sold to Embarcadero Technologies for an expected $23 million price and $7 million in CodeGear accounts receivables retained by Borland. The acquisition closed on 30 June 2008 for approximately $24.5 million.

Product Information

Since its foundation, Embarcadero Technologies has released several database-related products:

Rapid SQL

The Integrated cross-platform SQL IDE for increased database development efficiency

Embarcadero Rapid SQL, a leading cross-platform SQL IDE, helps database developers produce high quality SQL code faster. A rich development environment simplifies SQL scripting, query building, object management, project management, and version control in live databases or offline source code repositories. Intuitive editing, debugging, and optimization tools help create high-performance SQL code. Our version 7.5 supports DBMS versions: Oracle 10g, Sybase 15, SQL Server 2005 and DB2 v9. RapidSQL offers:

• Deep cross-platform functionality

• Highly usable, integrated, Windows-compliant GUI

• Comprehensive, integrated application

• Extensive SQL script and job execution capabilities

DBArtisan

The Leading cross-platform database administration solution for maximum availability, performance, and security

Embarcadero DBArtisan, the leading cross-platform database administration tool, helps DBAs maximize availability, performance and security. DBArtisan's comprehensive graphical editors and wizards boosts productivity, streamline routine tasks and reduce errors so DBAs can manage larger, more complex databases. DBArtisan supports all major database platforms allowing organizations to standardize on one solution. 8.5 supports DBMS versions: Oracle 10g, Sybase 15, SQL Server 2005 and DB2 v9 with complete datatype support, improved object editors and a new interface to deliver greater reliability and an improved user experience. DBArtisan offers:

• Highly scalable for managing large, complex datasets

• True cross-platform capabilities from one integrated console

• Performance monitoring and tuning

• Advanced storage and capacity planning

ER/Studio

The best Data modeling tool for designing and understanding your databases

Embarcadero ER/Studio, an industry-leading data modeling tool, helps companies discover, document, and re-use data assets. With round-trip database support, data architects have the power to easily reverse-engineer, analyze, and optimize existing databases. Productivity gains and enforcement of organizational standards can be achieved with ER/Studio's strong collaboration capabilities. ER/Studio offers:

• True separation of logical and physical models
• Heterogeneous DBMS support
• Diagram layout engines and navigation
• Flexible architecture

Change Manager

The best Database change management tool

Embarcadero Change Manager offers database administrators and developers a powerful set of tools to simplify and automate the database change management lifecycle. Change Manager's schema compare and alter, data compare and synchronization, and configuration auditing capabilities report on database changes, roll out new releases, and pinpoint database performance problems that result from both planned and unplanned changes. Change Manager offers:

• Capture of schema archives, which provide a record of database schema at a point in time
• Live-to-live, live-to-archive, and archive-to-archive compare jobs
• One-to-many compare
• Advanced alter generation
• Manage user, server and system objects
• Cross-DBMS data compare and automated object mapping
• Archive and compare database configuration settings
• Source Code Control Integration
• Command Line API and notification

Performance Center

The most robust 24/7 database performance monitoring tool

Embarcadero Performance center is a 24x7 database monitoring tool that helps ensure database availability and performance throughout the enterprise. Customizable alert thresholds, notifications and escalation paths let administrators access historical performance analysis data as well as identify and diagnose problems occurring in real-time. The Performance Center "Health Index" provides a single, at-a-glance, indicator that shows the overall performance level of every monitored database.

Performance Center also offers detailed performance reports that are highly customizable for different audiences including CIOs, IT managers as well as business unit managers for assessing SLA and performance requirements. Performance Center monitors IBM DB2 for LUW, Microsoft SQL Server, Oracle and Sybase ASE from one easy to read interface. Performance Center offers:

• Customizable thresholds, alerts and notifications, and escalation paths
• "Agentless" server-side solution
• Detailed performance reports for different audiences including CIOs, IT managers
• Monitors IBM DB2 for LUW, Microsoft SQL Server, Oracle and Sybase ASE from one easy to read and configurable interface

DT/Studio

A Data transformation, migration, and integration tool

Embarcadero DT/Studio, a cost-effective, scalable, and easily extensible ETL solution, helps organizations consolidate 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. With DT/Studio, organizations achieve higher quality data and ensure confidence in their data integration projects. Embarcadero DT/Studio, a cost-effective, scalable, and easily extensible ETL solution, helps organizations consolidate 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. With DT/Studio, organizations achieve higher quality data and ensure confidence in their data integration projects. DT/Studio offers:

• Data source analysis and modeling
• Streamlined task development
• Performance and scalability
• Reporting and communication
• Administration and maintenance
• Comprehensive data source connectivity

Schema Examiner

Now you can validate and fine-tune database schema with comprehensive diagnostics and reporting database tools.

Embarcadero Schema Examiner ensures the integrity of database schema by performing a comprehensive set of diagnostic tests that validates the schema and ensures that the rules of the relational model are enforced. Detailed reporting and graphical documentation simplify the process of pinpointing and reviewing discrepancies. Schema Examiner also recommends changes to database schema and can automatically generate scripts to fix problems, providing an efficient and consistent approach to improving database design. Validate and fine-tune database schema with comprehensive diagnostics and reporting. Schema Examiner offers:

• Simplifies the process of testing and validating database schema
• Reverse-engineer existing schema
• Detailed diagnostic reports increase productivity
• Recommends changes and automatically generates scripts to fix problems

EA/Studio

Perform real-world process and database modeling

Embarcadero EA/Studio Business Modeling Tool is a tool for creating a graphical representation of your business from the core concepts that describe the business, to the processes that detail how your business operates. EA/Studio allows you to easily model your business processes and how those processes use data. EA/Studio Conceptual Modeling provides an intuitive way to outline subject areas and concepts that can then drive the creation of detailed data models. EA/Studio offers:

• Conceptual Modeling for top down database design
• Business Process Modeling based on the BPMN standard
• Intuitive interface suitable for both business and technical users
• Support for Stewardship, Business Rules, and Business Units
• Capability to link business processes with underlying data
• Impact analysis and reporting
• ER/Studio Import/Export
• Publish models to the web
• Visio and Excel Import

In March 2007,

PowerSQL

SQL IDE for Application Developers

Embarcadero PowerSQL simplifies SQL development for application developers with many features for improving productivity and reducing errors. A rich SQL IDE with code completion, real–time error checking, explain plans, and on–the–fly tuning streamlines coding tasks while producing quality code. PowerSQL offers native support for IBM® DB2® for LUW, Oracle®, Microsoft® SQL Server, and Sybase® as well as JDBC. PowerSQL is available as a stand-alone application or as an Eclipse plugin. PowerSQL features:

• SQL Code Assist ensures 100% object name accuracy, even when not connected to a database, plus real-time SQL syntax alidation
• SQL Project Insight provides project-level SQL file cataloging and search features to help streamline project organization and maintenance
• Migration Wizard imports data sources from Eclipse DTP (Data Tools Project) or Quest TOAD
• Data Source Explorer enables users to easily navigate, search, extract DDL, execute commands, and even browse an outline view without opening the SQL file
• Oracle Quick Fixes provide real–time performance improvement suggestions that can be implemented with the click of a button.

In March 2008 the following article appeared in NewsWireToday and

DBOptimizer

Does your database require SQL Profilingand Tuning IDE

Embarcadero DB Optimizer maximizes database performance by enabling developers and DBAs to quickly discover, diagnose, and optimize poor-performing SQL. DB Optimizer eliminates performance bottlenecks by discovering data intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (CPU, I/O, wait times), and optimizing any problematic statements. DB Optimizer offers:

• Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
• Hyperlinked drill-downs for locating detailed activity information for an individual SQL statement
• Explain plans for a better understanding of how SQL will be executed and the performance costs
• Real-time Quick Fixes to flag and correct inefficient SQL automatically (Oracle)
• Batch tuning of DML statements, stored routines, entire SQL files and the System Global Area (Oracle)

Embarcadero Technologies currently offers database tools that share a cross-platform foundation and cover the database life cycle.

Download Trial of Products

If you would like to try a 14 day trial of Embarcadero Technology Products, click the product name below:

• Rapid SQL, use for increased database development efficiency
• DBArtisan, leading cross-platform database administration solution
• ER/Studio, the industry leading data modeling tool
• Change Manager, the leader in database change management
• Performance Center, best used for 24x7 database performance monitoring
• DTStudio, should be your 24x7 database performance monitoring
• Schema Examiner, is a comprehensive 24x7 data validation tool able to fine-tune your database
• EA/Studio, real world conceptual data modeling tool
• PowerSQL, robust tools for SQL IDE for Application Developers
• DB Optimizer, will give you the best SQL Profiling and Tuning IDE toolbox

External links

• Database Tools and Application Development website
• German website
• edageek.com, Thoma Cressey Bravo and Embarcadero transaction
• eWeek.com Data Modeling with Templates
• dnjonline.com Database Professionals
• Database Security Best Practices
• Intelligent Enterprise EA/Studio Put-to-the-Test
• ER/Studio Tutorial