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 – Display or hide the projects tabs
read more
data modeling
Macros – Also add Data Security Information
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
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…
Webinar extracts – Maximize Your Productivity with ER/Studio Macros: The Magic Wand for Data Modelers
On May the 9th, I have presented a webinar: Maximize Your Productivity with ER/Studio Macros: The Magic Wand for Data Modelers In this post, I’ll…
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…
Macros – Using macros to expand or collapse Business Data Objects
In my previous post, I shared a script to quickly manage your macro shortcuts. In this one, I’ll share 3 different scripts to expand or…
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…
Macros – How to generate a report from a macro?
In this post, I’m sharing an example of a macro which allows you to generate a report from your model.
Improve data modeling with Aqua Data Studio
Data architects spend a major time of their job on data modeling. As such, they need to ensure that change to their data stores is controlled and...
Best IDE for data analysts
Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...