ER/Studio Archives

Macros – Display or hide the projects tabs

Within ER/Studio Data Architect, we have the option to view one tab for each opened project or to hide these tabs. In this post, I’ll…

Macros – Also add Data Security Information

by William W.

This is the third post regarding the binding of custom properties to specific ER objects. In this one, we’ll support some new ER objects (Models,…

Macros – Add even more custom properties

by William W.

This post follows the previous one, “Macros – Add custom properties to specific objects”, where we shared scripts to automatically bind Attachments to ER Objects….

Macros – Add custom properties to specific objects

by William W.

Sometimes, you may need to specify custom properties for various objects such as Entities, Tables, Attributes, etc. The macros I’ll be sharing in this post,…

Macros – Import objects from a diagrams.net | draw.io XML file

by William W.

A script that imports a particular diagrams.net XML file (formerly draw.io) including specific Data used to retrieve the properties required to create the Entity Relationship…

Macros – Colorize specific attributes

by William W.

Using the data modeling features of ER/Studio Data Architect we can create automatic and customized data model diagrams. ER/Studio Data Architect provides functionality such as…

Macros – Add or Remove the Relationships in the Submodels

by William W.

ER/Studio Data Architect provides an important navigation feature called Submodels. In this post, I’ll share a macro which can be used to add|remove the relationships…

Macros – Switch domains from one data dictionary to another one

by William W.

In this post, I’ll be sharing a macro based on this sample, updated to switch the bindings for all the domains included in the source…

Macros – How to edit the Definitions and Notes with Excel

by William W.

In this post, I’ll share a video which shows how to export your Definitions and Notes from ER/Studio Data Architect, edit them with Excel, and…

Macros – The Voice of Data Architect

by William W.

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…

Macros – Bulk Harvesting from Excel Spreadsheet List

by William W.

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,…

Macros – Quickly update the Dimensional Model Table Types

by William W.

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…

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

by William W.

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…

Macros – Generate lookup tables from Reference Values

by William W.

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…

Macros – Remove diagrams from the repository using an Excel workbook

by William W.

After a while, you may have added lots of projects in your ER/Studio Repository. In this blog post, I’ll share a script which can generate…

Webinar extracts – Do you need to model hierarchical data such as JSON, MongoDB, and Google BigQuery?

by William W.

On August the 22nd, I have presented a webinar: Do you need to model hierarchical data such as JSON, MongoDB, and Google BigQuery? In this…

Macros – Using macros to create Data Vault objects

by William W.

Some years ago, Sultan shared a post regarding Data Vault modeling with ER/Studio. I strongly recommend to read it before this one. The different Data…