ER/Studio Data Architect

Macros – Colorize specific attributes

Macros – Colorize specific attributes

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 automatic layouts, custom colors and fonts for our objects, and relationship line control.
To make our model more attractive and easier to read, we can change the background, outline, and font colors along with the font type entities/tables, attributes/columns, views, and relationships in our data model. We can use specific colors and/or fonts to help us organize our data model.
In this blog post, I’ll share a macro which shows how to manage the colors from a script. With the macro, we can search for a string and colorize the attributes and columns which match the string.

read more
Macros – Switch domains from one data dictionary to another one

Macros – Switch domains from one data dictionary to another one

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 dictionary and available in the target data dictionary (with the same name). If there’s no domain with the same name in the target data dictionary, the domain binding will remain unchanged.
For instance, if you intend to replace the domain bindings from the local data dictionary with those included in an Enterprise Data Dictionary.

read more
Macros – The Voice of Data Architect

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

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

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

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

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
Macros – Using macros to create Data Vault objects

Macros – Using macros to create Data Vault objects

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 Vault providers implement common objects but the attributes can differ. In this blog post, I’ll share an archive with some macros which can create hubs, satellites and links.

read more
Macros – Sample macros to import Logical and Physical Data Models from Microsoft Visio to ER/Studio Data Architect

Macros – Sample macros to import Logical and Physical Data Models from Microsoft Visio to ER/Studio Data Architect

Visio can draw charts, plans and diagrams.

Some people have used Visio to create their Logical and/or Physical Data Models and they would like to import their drawings in a data architecture and design tool: ER/Studio Data Architect.

In this blog post, I’ll share 2 scripts which can import Entities & Attributes from a Visio Drawing page. I have tested it with 2 different samples…

read more
Macros – Shortcuts: a macro to rule them all

Macros – Shortcuts: a macro to rule them all

In this post, I’ll share a script which lets you add shortcuts to macros that you may want to quickly access from various places in ER/Studio Data Architect.

This code will allow you to quickly manage your macro shortcuts and associate them with any existing macros, including those in any subfolders beneath your Macros Directory.

read more
Using C# and .Net to access Data Models

Using C# and .Net to access Data Models

In my previous blog post, I shared a PowerShell Script which uses the ER/Studio Data Architect COM automation interface.

During this post, we’ll create an application, using the Microsoft .NET Framework with the language C#, which can also connect to ER/Studio Data Architect.

read more
Using PowerShell to organize Data Model Projects

Using PowerShell to organize Data Model Projects

Years after years we are creating new models. Maybe we save all the different projects to the same folder. After a while, we can have many projects in this directory.

This blog post shares a PowerShell Script which copy|move the project files to subfolders created by using the Copyright Year of the projects.

read more
1 2 3