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…
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.
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.
The data warehouse is an established concept and discipline that is discussed in books, conferences, and seminars. Indeed, data warehouses are a...
Data modeling is data governance. We define data governance as the execution and enforcement of authority over the definition, production, and usage...
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.
For over three decades now, data modeling has been the leading discipline for understanding business data requirements and representing them in a...
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.
The time has passed when data models could hide in an ivory tower (IT) and locked behind bars only for the IT in‐crowd to be consulted. It is their...
Data modeling produces a set of structures for a relational database management system (RDBMS). First, we build the conceptual data model (CDM) to...
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.
Today, you cannot pick up a magazine, read a blog, or hear a webcast without the mention of big data. It has had a profound effect on our...
Many data modelers are finding out that their traditional data modeling processes are not a good fit for modern software development methods, such...
When teams work together with a common goal and a passion for success, their projects succeed. When the opposite occurs, everyone loses, including...
In this post, I’m sharing an example of a macro which allows you to generate a report from your model.
What is metadata? The term metadata arises often when discussing data architecture. Summarizing, it refers to data about data. However,...
Are your data models supporting data governance? Most data professionals have been involved in data governance programs in our careers. These...
IDERA helps business intelligence (BI) and data warehouse (DW) architects to better design, document, and reuse data elements to create a more...
Greater dependence on enterprise-class applications has created a demand for centralizing organizational data in their support. Imperatives such as...
Metadata management is not a new concept. However, it is gaining new adherents as we recognize the value of enterprise data governance. We may have...
Much of the conventional guidance about implementing a data governance program focuses on organizational structure and the protocols for defining...
For over three decades, organizations have relied on data warehouses to support the needs for descriptive analytics of business information...
Logical data modeling is the second of the three stages of data modeling and one of three types of data model. The three types of 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.