Featured Blog

ER/Studio Data Architect 20.1 General Availability

We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.1 ER/Studio 20.1 delivers a variety of improvements and bug fixes to SQL generation to support your design projects. This makes ER/Studio more reliable, faster, and with better-documented output. Get the latest version today! ER/Studio Data Architect 20.1 Updates to Data […]
Read More

ER/Studio 20.0 GA

We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.0

ER/Studio 20.0 delivers a variety of performance improvements, usability features, security improvements, and bug fixes. As a bonus, we’ve improved scalability for enterprise-level usage. Get the latest version today!

read more

Macros – The Voice of Data Architect

ER/Studio Data Architect supports programmatic event handling.
To better understand when these events are triggered, I’ll share an updated script of the sample macro: ERSBasicHandlers.bas
Moreover, I’ll also share a second macro which speaks the definition of the selected entities|tables.

read more

Macros – Bulk Harvesting from Excel Spreadsheet List

In a previous post, we have seen how to schedule a reverse engineering of a database using a macro and a quick launch file.
Likewise, I’ll share a macro which also uses the reverse engineer function, through the DiagramManager.ReverseEngineerObject.
However, instead of using a quick launch file, the macro directly extracts the connection settings from an Excel workbook.

read more

Macros – Quickly update the Dimensional Model Table Types

Many different models and notations are supported by ER/Studio Data Architect. A model has one of these 2 model notations: Relational or Dimensional.
When we use a Dimensional diagram, there’s an additional tab available in the Table editor, Dimensional, where we can select the Dimensional Model Table Type and the Table Type and Data Architect updates how the diagram objects are displayed.
In this blog post, I’ll share a macro which replaces the Dimensional Model Table Type and the Table Type for all the Tables|Entities or a selected subset.

read more

Macros – Using macros to import/export attachment bindings to Excel

When we use ER/Studio Data Architect, we can create Submodels to document specific metadata.
For example, we can create Submodels to manage our Conceptual Data Model, to display the datatypes and Null option, or to show the Attachments and Data Security Information bound to the Entities | Tables.
In this blog post, I’ll share 2 different macros which can also export|import the entity and attribute attachment binding information to|from Excel.

read more

Macros – Generate lookup tables from Reference Values

With ER/Studio Data Architect, we can use the Data Dictionaries to define Reference Values and to bind them to our Attributes|Columns.
I’ll share a script to generate the lookup tables for all the columns of the selected Tables which use Reference Values Lists. With Physical Data Model, it also generates in the Post SQL tab of the created Reference table, the Insert statements.

read more