Embarcadero ER Studio XE

The Embarcadero Technologies company, the supplier of software solutions for development and applications of databases, announced release of the new version of a packet of tools for design of databases and data modeling of ER/Studio XE3 — the most important basis of the platform for management of metadata of the company. ER/Studio XE3 improves possibilities of corporate modeling and the analysis of effects for more exact interpretation of a wide range of metadata.

The new version includes expanded functions of universal display for improvement of corporate modeling and the analysis of influence between physical, logical and conceptual models. ER/Studio XE3 also gives an opportunity of creation of the user data types, providing more complete direct and return design.

The new version of a packet of tools is also equipped with support of SQL Server 2012, Teradata, Netezza, Greenplum and Windows 8 and offers the optimized management tools large models.

Besides, ER/Studio XE3 includes the updated portal with the improved user interface, absolutely new search systems of dictionaries of data for use of metadata at more detailed level.

"Embarcadero understands needs of specialists in the software and databases — Michael Svindell, the senior marketing vice president and to Embarcadero product management said. — The latest version of ER/Studio provides our strategy of management of metadata and syndications. XE3 will allow to integrate IT architects with business colleague for collaboration in the Data Governance projects and syndication of metadata of the company. XE3 also expands the field of work ER/Studio and provides support of popular platforms for work with Big Data, such as Netezza and Greenplum which are sources of growth of volumes of corporate data".

Control functions by metadata are available in the current version of a product family of Embarcadero. ER/Studio XE3 is available to acquisition on the Internet, directly at Embarcadero and/or through partners.

2014: ER/Studio XE5

Embarcadero ER Studio XE5 is rapid application development environment (RAD) for Microsoft Windows firm Embarcadero Technologies.

On February 18, 2014 the Embarcadero Technologies company, announced XE5 release exit - tool kit for work with databases: ER/Studio, DBArtisan, Rapid SQL, DB Optimizer and DB Change Manager.

The version of Embarcadero Studio XE5 integrates Delphi XE5 and C ++ Builder XE5 in uniform integrated development environment. As a part of the version, available since February 18, 2014, support of the latests version of DBMS, including expanded support of Teradata is included.

Expanded support of the Teradata platform widely known as the solution for corporate data warehouses, allowing to manage better the available data warehouses by means of logical and physical models is added to the new version of ER/Studio XE5. New tools provide means of work with data warehouses and also scaling options of Teradata given to all users in the world who need use of Multi-Level Partitioned Primary Indexes (MLPPI) and temporary data types.

Rapid SQL XE5, the instrument of cross-platform SQL development and debugging and also DBArtisan XE5, the instrument of cross-platform administration and management of databases, includes support Oracle 12c SQL Server 2012, Sybase ASE 15.7 and IBM DB2 z/OS 10 or LUW 10. Both tools ensure native functioning in 64-bit OS now, including Windows 8.

Within the new version of CONNECT, at management of metadata and joint work, it is possible to use the advanced hints and warnings containing expanded metadata and information on security and compliance to rules.

ER/Studio XE6

On September 18, 2014 Embarcadero announced a release of the new version of tools for work with databases, including ER/Studio, DBArtisan and Rapid SQL.

The new version of XE6 tools for work with databases resolves issues from area of Big Data; gives to users new opportunities for more effective work with the DBMS main platforms.

The new release of ER/Studio provides support of Big Data and the improved performance to provide requirements for management of large, shared models.

New opportunities:

• Support of the return design for Hadoop Hive and MongoDB - platforms of work with Big Data.
• 64-bit addressing of work with memory. Improves system performance for big data sets
• Enterprise Team Edition gives the improved joint work opportunities with models and metadata for the staff of the organization.

Tools for work with databases of the version XE6, including ER/Studio, are available to DBArtisan and Rapid SQL to acquisition. Trial versions are available to loading on the website of vendor].

2015: Embarcadero released ER/Studio XE7

On April 28, 2015 the Embarcadero Technologies company announced a release of the version of the XE7 tool for design of architecture of data – ER/Studio.

In ER/Studio XE7 opportunities for improvement of architecture of data, masterings of technologies and techniques of design, increase in convenience of accomplishment of process to users are implemented.

ER/Studio XE7 is the powerful solution for design of architecture of data to different business challenges. In its structure of the simular of design of data, tools of the reporting and joint work. Use of advanced glossaries in ER/Studio XE7 improved data view and metadata, both for IT specialists, and for other employees.

The solution offers opportunities of operational management of changes. Now quickly changing databases and applications do not represent a problem — your data models will be relevant. By means of automatic application of standards of naming, it will be more convenient to work, developers consider.

ER/Studio XE7 is available in the 64-bit version that allows processing of more volume data models. Performance for the main transactions - comparisons and associations, improved.

Screenshot of the ER/Studio XE7 window, 2015

Possibilities of ER/Studio XE7

• The improved data view on all company. Advanced glossaries provide the improved data view in the company that will be estimated without fail by both developers, and other specialists. ER/Studio XE7 is closely integrated with the dictionary of data ER/Studio Data Architect that allows to browse terms and determinations of the glossary in real time to check them for uniformity, and changes in terms and glossaries can be monitored through the detailed control magazine. Employees will be able easily to find and update the necessary glossaries, terms and objects and also to make reports on them thanks to advanced function of advanced search.

• Operational management of changes. Operational management of changes in ER/Studio XE7 includes work with tasks and the version history. Developers can more simply and quicker monitor changes in models now and connect them with problems of workflow, reveal and analyze influence of data sources and provide uniformity of models due to automatic application of standards of naming.

• Convenience of work. On the new start page dynamic materials are placed (video instructions, etc.) that increases convenience of work and allows to master means quicker. Besides, in ER/Studio XE7 process of data modeling due to automatic application of standards of naming for logical and physical models is simplified.

• Support of different platforms. Embarcadero offers extensive support of platforms of the relational databases and databases which do not have schemes (Big Data). Besides, integration into other solutions, including SAP, Salesforce, JD Edwards by means of technology partnership with Silwood Technology is possible.

ER/Studio XE7 is available in three editions:

• Data Architect simular of initial level,
• Data Architect Professional with the integrated repository
• Enterprise Team for work with models and metadata in scales of the organization.

Embarcadero offers three options of licensing:

• licenses for the workstation,
• network personalized licenses
• licenses for simultaneous access,

Versions are available to one or several platforms (for all three editions).

Loading of free trial version of ER/Studio is available to the address www.embarcadero.com/data-architecture