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,…
ER/Studio Data Architect
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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…
Data Architecture: The Foundation for Enterprise Architecture and Governance
"Data modeling is all about understanding the data within our organizations and then representing this data in a precise visual (the...
Connecting to PostgreSQL and MySQL via ODBC to IDERA’s ER/Studio Data Architect
Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse...
Data Vault Modeling with ER/Studio Data Architect
Overview I have been asked multiple times if ER/Studio supports Data Vault Modeling. The answer is yes, ER/Studio does support multiple approaches...
IDERA ER/Studio Repository Database Setup and Ports – Part 1 – SQL Server
Howdy! In this latest blog post, I will be covering the Database setup one would need for our IDERA ER/Studio Repository. Pre-requisites: SQL Server...
Logical to Physical Data Modeling
In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to...
Modeling Graph Data Stores in ER/Studio
Modeling Background Enterprise data environments have become increasingly complex due to a proliferation of different technologies and data...