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.
William W.
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.
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.
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.
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.
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 a worksheet with all the Diagrams added to the Repository and remove diagrams from the Repository using a list provided through a spreadsheet.
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 post, I’ll share a video with the most interesting extracts. This video provides chapters, so do not hesitate to navigate to the ones you are the most interested by.
Get French Holidays
I saw this blog post and I decided to publish this one for France. Here is a PowerShell function that gets all French holidays…
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.
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 share a video with the most interesting extracts. This video has chapters, so do not hesitate to navigate to the ones you are the most interested by.
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…
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 collapse your Business Data Objects.
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.
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.
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.
Team Server REST API – Import into Google Sheets
In my previous post, we have seen how to obtain the authorization to use the API.
In this one, we create a new blank spreadsheet in Google Sheets which uses the Team Server REST API to directly import and refresh the objects we want.
Team Server REST API – Getting Started
Team Server provides a REST based API to interact with it.
This blog post describes how we can connect to and use the Team Server REST API from an Excel workbook.
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.
Macros – How to schedule an automatic reverse-engineer from a database into a data model?
This blog post describes how you can run a macro to reverse engineer a database and call it from the Windows Task Scheduler.
Team Server Automation
This blog post describes how you can connect to and use the Team Server API from a macro used in ER/Studio Data Architect and from a custom application coded with Delphi.
Idera License Types
In this post, we will see the different kinds of licenses that are available for the users.