Embarcadero Database Tools

[Elisabet Schwartzkopf]

EmbarcaderoTechnologies, Inc. is an American computer software company that develops, manufactures, licenses and supports products and services related to software through several product divisions. It was founded in 1993, went public in 2000 and private in 2007, and became a division of Idera, Inc. in 2015.[1]

Embarcadero was founded in October 1993 by Stephen Wong, Stuart Browning, and Nigel Myers and released a tool for Sybase database administrators in December of the same year called Rapid SQL.[2] It later added tools for software development on Microsoft Windows and other operating systems, and for database design, development and management, for platforms including Oracle, Microsoft SQL Server, IBM DB2, and MySQL.

In November the same year, the company acquired GDPro, a Unified Modeling Language software provider. In October 2005 Embarcadero acquired data security business Ambeo. In June 2007, Thoma Cressey Bravo bought Embarcadero, and it became a private company.[4] Wayne Williams was appointed chief executive officer of Embarcadero Technologies in 2007.

On May 7, 2008 Borland Software Corporation announced 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.[5] The acquisition closed on June 30, 2008, for approximately $24.5 million.[6]

In December 2011, Embarcadero announced AppWave, an enterprise app store for PCs running Microsoft Windows instead of mobile phones. The platform supports Embarcadero software, commercial titles, and free and open source apps.[7] In April 2012 the platform was moved to a web site called AppWave Store.[8]

The corporate headquarters is located in Austin, Texas, with an international office located in Brazil.[9] As of 2012[update] the company had an annual revenue of $100 million, and around 500 employees on its payroll[citation needed].

On October 7, 2015, Idera, Inc. announced an agreement to acquire Embarcadero Technologies, Inc.,[12][13] but the Embarcadero mark was retained for the developer tools division. As of October 28, 2015, Embarcadero was listed as 'acquired'.[14]

Until 2015, Embarcadero sold products like Rapid SQL and DB Artisan, and ER/Studio, and these products are now sold by its parent company directly, Idera.Interbase, a lightweight database for desktop and mobile app development, remained an Embarcadero product in 2016.

Embarcadero DB PowerStudio 2016 is a database tool suite that empowers DBAs and data professionals with comprehensive administration, development, performance and monitoring capabilities across multiple platforms. The tool suite complements native management tools with additional functionality that dramatically increases productivity, boosts database performance and improves availability.

Aqua Data Studio provides a management tool for the Embarcadero InterBase[1] embeddable relational database with administration capabilities and a database query tool. Developers can easily manage and interface with InterBase during their application development process. Aqua Data Studio provides a more agile process and streamlined development environment with flexible encryption capabilities.

Start for FREE Use the visual administration features to browse and modify database structures, including schema objects and database storage, as well as maintain database security. The integrated query tool allows you to quickly create, edit and execute SQL queries and scripts. You can also easily import and export tools to move data between different data formats, as well as in and out of the Embarcadero InterBase database.

Subversion (SVN)

,

Git

,

CVS

,

PerforceReferences^Embarcadero InterBaseWikipedia article.InterBase is an embeddable relational database management system (RDBMS) that runs on multiple mobile and desktop operating systems. InterBase is distinguished from other RDBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture.PURCHASING

Qubole is a simple, open, and secure Data Lake Platform for machine learning, streaming, and ad-hoc analytics. Our platform provides end-to-end services that reduce the time and effort required to run Data pipelines, Streaming Analytics, and Machine Learning workloads on any cloud. No other platform offers the openness and data workload flexibility of Qubole while lowering cloud data lake costs by over 50 percent.

Aqua Data Studio by AquaFold, Inc. is a cross-platform database solution delivering more than 40 must-have tools to database developers and analysts. It is a highly-collaborative platform that allows users to develop and deploy analytic and reporting solutions at an awesomely low price. Aqua Data Studio is used by more than 300,000 data professionals to design, develop, model, and administer their databases.

BitTitan is the premier provider of cloud migration solutions that support leading cloud ecosystems, including Amazon, Google, Microsoft, and ServiceNow. BitTitan empowers IT service professionals to deploy and manage cloud technologies through its family of software solutions, including MigrationWiz, Voleer, and Perspectium. Since 2009, BitTitan successfully moved over 25 million users to the cloud across 46,000 customers in 188 countries.

Webyog creates innovative database management tools for customers ranging from enterprises to small businesses and home users. Webyog provides best-of-breed database management tools for managing popular open-source databases. Webyog consistently receives top ratings and recommendations by respected third-party media and product reviewers. More than 2.5 million users worldwide have selected Webyog to help them smartly manage, monitor and optimize their databases.

Precise offers industry-leading web-based multiplatform database performance monitoring, measuring the end-to-end end-user experience all the way from the browser through all tiers of virtual and physical infrastructure. We empower IT organizations by intelligently monitoring and optimizing database performance across Microsoft SQL Server, Oracle, Sybase, and DB2 in both cloud and on-premises deployments. Precise also provides seamless visibility into proprietary and custom applications like .NET, Java/J2ee, Oracle EBS, PeopleSoft, and more.

Idera, Inc. is the parent company of a portfolio of brands that offer B2B software including database tools, application development tools, test management tools, and DevOps tools. It is headquartered in Houston, Texas and has offices in Australia, Austria, and the United Kingdom. Idera creates tools designed to support, supplement, and augment the capabilities of Microsoft SQL Server, including SQL Diagnostic Manager, SQL Doctor, and SQL Inventory Manager. The company also offers a software as a service server backup product known as SQL Safe Backup, which allows hosting providers and others to offer their clients continuous data protection for their backups. They also offer a number of free tools for SQL Server performance, backup, and diagnostics and for Windows PowerShell.

Embarcadero's products include ER/Studio for database modelling, DBArtisan for administration, and RAD Studio for application development across Windows and mobile based on Object Pascal (Delphi) and C++.

The acquisition makes sense in bringing together two Windows-centric database tools companies, though you can expect some product rationalisation. Application development is new to Idera though. "The application performance tools deliver similar business benefits to an entirely new community of users," says Idera CEO Randy Jacops.

Delphi developers are wondering what impact the acquisition may have. Some are hopeful. "If Embarcadero is worth buying, it means that Delphi is worth betting on," says open source developer A Bouchez.

RapidSQL was one of the first graphical programming environments for relational databases, introduced in late '93. This review is based on the release version 5.7 released in April 2001. Embarcadero's goal is that RapidSQL be the development environment of choice for database programmers, and the product matches or surpasses the competition in nearly every area. It is very robust so you will not get complaints from co workers if you select this tool. It supports multiple databases transparently, integrates with Source Code Control tools, helps you manage your projects, provides build management, produces wonderful reports on any database object(s), and it has excellent help and support. The product gets 4.5 stars which is our highest rating so far, good job Embarcadero!

Back to top of fileWhat is great about this product?Robustness

Having used Procedure Builder, TOAD, SQL-Navigator and SQL-Station since July of 1997, alongside the Embarcadero suite we purchased in 99, Im convinced Rapid is made by some of the best C++ developers out there. In fact, I have never used any programming IDE for any language that is more robust than Rapid. You will not be lynched or fired for introducing Rapid to your team. Over the last two years, Embarcaderos stuff has only crashed on me twice. Even then, you could tell they worked hard on exception handling, as they had a special interface for capturing and diagnosing the memory errors. I wanted to show a screenshot of this, but I cant seem to force a crash with this tool.

Multiple, transparent database support

Despite the best intentions to stay homogenous, too often life goes awry, and the next thing you know, youre responsible for custom and 3rd party systems running on every flavor of database out there. If this is, or could be, the history of DB multiplication at your firm as well, then Embarcaderos offerings are the best investment you could make. There is nothing else that so smoothly and completely transitions from one database to another, transparently changing the features offered in the UI based on the database connected to, translating datatypes, checking syntax, etc. Rapid has facilities for real-time or scheduled execution of scripts, either on a single database, across multiple instances, or even across multiple instances of multiple databases. Other tools aim to support multiple DBs, only to be weak at all of them. Embarcadero manages to support them all well.

Integrated with leading SCC (Source Code Control) tools

Something almost no other DB IDE attempts, let alone gets right. Rapid integrates well with Microsoft VSS, PVCS and Clear Case. Since we do all our programming and project management in .sql files, and use PVCS, I found this very handy not to have to skip between Rapid and the PVCS VM.

Flexible project or non-project orientation and workspaces

If your development habits tend to project-orientation, there is a powerful facility for organizing everything you work with into separate projects and subprojects. If you do more one-off coding, you neednt use the project feature, but code and compile by individual file only. There is even the ability to automatically extract objects from a live database into an organized project with a file for each object.

Build management

This was unique among the DB programming IDEs Ive used. It is very powerful and I cant do it full justice here. You may take files or live database objects and arrange them into builds or build scripts, where you or Rapid sets the dependencies and build order. As with many of Rapids features, this may be run against multiple databases in an ad-hoc or scheduled manner. And like the other features, all statements results, and final results may be sent via email or the network for immediate notification upon error or completion.

8i support

Despite being a little late to the game, since 98 Embarcadero has impressed me keeping up with the latest 8i features in its various tools. Rapid 5.7 is no exception.

Fully functional without having to install anything on the connected databases

This is critical when you have to manage 3rd party software or production databases where you really shouldnt, or arent allowed, to install anything else on the server, let alone messing with SYS/SYSTEM connections to create new user accounts and play with grants and privileges.

Full screen mode

Most of my MDI tools get way too cluttered and its time-consuming to rearrange everything so I can see the full width of a file. Its easy in Rapid to switch workspaces, hide the organizer, or switch to full screen mode to gain that readability youre craving. Another indication of their investment in UI usability.

Context-sensitive help

Its a rare tool that puts this much effort into ensuring that I immediately access the appropriate help page from anywhere in the software.

Nice, fast reporting engine

If you're a shop where reams of documentation are required, just point one of Embarcadero's tools at it. You can immediately generate single or separate, nicely-formatted HTML reports for single or multiple DB objects of the same type. Their DBArtisan tool can produce an entire intranet site for a whole instance or individual schema. Your manager will fire you for thinking you spent weeks writing web pages without his permission. It's that good!

Although not part of the software, Embarcaderos rabid dedication to the customer

When I first evaluated the product in late '98, it was solid, but was lacking features that competing products sported. However, like the best companies in the Fortune 100, I've found Embarcadero to be fanatical about supporting and listening to its customers. They did so, and have quickly filled almost every gap they once had.

3a8082e126