Learn how RAD Studio 2010 from Embarcadero supports MySQL and Oracle databases and .NET environments, and read about how the new features in the Professional, Enterprise and Architect editions help Oracle developers build RAD Web applications.
Read the other sections of this guide on Web development tools:
Toad 10: Good for database developers, good for administrators
Codeless AJAX development improves Alpha Five V10 for the Web
Oracle APEX is totally RAD for Web development
RAD Studio 2010 supports Oracle databases, .NET environments
RAD Studio 2010 from Embarcadero is a powerful rapid application development suite used for visually building GUI-intensive, data-driven end-user applications for both native Windows and .NET environments. While not specifically designed to work with Oracle databases (RAD Studio also supports several leading database vendors), the suite includes several tools that work with Oracle databases.
RAD Studio 2010 offers a collection of development tools, helping to enhance the flexibility of the product. The suite includes Delphi, a RAD development environment, C++Builder, a Visual C++ programming environment and Delphi Prism, an IDE for building .NET applications. That combination of tools allows developers to choose how they want to create applications and how those applications will be deployed.
RAD Studio 2010 is available in three editions: Professional, Enterprise and Architect. Embarcadero RAD Studio 2010 Professional is designed for software developers and teams building native Windows, .NET and touch-screen applications with (or without) embedded and local database persistence. RAD Studio includes Delphi, C++Builder and Delphi Prism.
Embarcadero RAD Studio 2010 Enterprise is designed for software developers and teams building client-server, multi-tier and Web-based applications for native Windows and .NET and offers seamless connectivity with a variety of database servers and enterprise data sources, expanded UML modeling, and a comprehensive tool set for delivering quality applications. RAD Studio Enterprise includes everything in the Professional edition, plus additional features for building client-server and multi-tier database and Web applications.
The product includes database server connectivity to Oracle, DB2, InterBase, Blackfish SQL, Firebird, MySQL, Microsoft SQL Server, Informix and Sybase.
Embarcadero RAD Studio 2010 Architect is designed for application developers and teams building data-intensive client-server GUI and Web applications for use with enterprise database systems. RAD Studio Architect combines data-driven rapid application development for native Windows and .NET with rich visual data modeling to help developers understand, design and get the most value out of enterprise databases and data structures. RAD Studio Architect includes everything in the Enterprise edition, plus powerful database modeling and design capabilities.
Oracle application developers will be best served by Embarcadero RAD Studio 2010 Architect edition, if only because it includes tools to reverse-engineer, analyze and optimize databases. It also has tools to automatically generate database code from models. In other words, the Architect edition includes management tools for working with databases, eliminating the need to purchase additional tools to model data or generate PL/SQL code.
RAD Studio 2010 relies heavily on the .NET framework for deploying Web applications, meaning that developers using the product need to standardize on Microsoft technologies and browsers to deliver their Web applications. While it is nowhere near as flexible as an AJAX-focused development tool, development for .NET does prove to be adequate for most users. Of course, developers can always leverage Microsoft’s ASP.NET technology to deliver true Web applications, and that is probably where most of a programmer’s effort should go.
With a list price of $4,299, Embarcadero RAD Studio 2010 Architect is one of the most expensive RAD/IDE suites on the market. But that price includes a bundle of development tools as well as a feature set that would take a thick book to explain. Documentation for the product is very good, as is the technical support, thanks to an extremely active development community made up of close to 1.2 million users.
For those looking to leverage Oracle databases, there are no longer any excuses not to delve into the world of Web applications. An abundance of tools are available to make Web applications a reality for almost any environment, small or large. Each of the development suites covered here offers a path to Web application development, albeit using different routes.
For those looking to explore the world of Web application development, it is pretty hard to ignore what APEX has to offer, and at a price that is impossible to beat -- free. For those looking to fully leverage the world of AJAX and create Web applications in as little time as possible, Alpha Five V10 has the wherewithal to make that a reality. For in-house developers who not only create code but are also responsible for managing an Oracle database, TOAD 10 is hard to beat, with its integrated tools for managing an Oracle database. Developers working in Microsoft shops may want to consider Embarcadero RAD Studio 2010 Architect, which works well with .NET implementations and supports much more than just Oracle on the back end. RAD Studio 2010 Architect may prove to be the most flexible tool of the bunch, and lends itself well to multi-tier, multi-vendor environments or development houses.
This was first published in February 2010