Howdy! In today's blog post we will carry on with the actual setup and scripts needed to create the repository user and the instructions for...
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, Submodels, Business Data Objects) and we’ll filter the types of ER objects that can be bound to each Attachment Type.
Even more importantly, we’ll also integrate the Data Security Information so it can also be automatically bound to their relative ER Objects.
IDERA TeamServer Core Database Creation – Oracle Edition – Pluggable Database – Part 1
Howdy! In this short blog post, we shall explore on how to create a Pluggable database for our teamserver database Here are the SQL*Plus commands to...
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.
In this one, we will share new versions of the different scripts that allow using shared Attachments for various types of ER Objects (instead of duplicating them for each ER Object), and also support Relationships and Views.
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, allow us to:
– Export the attachments from the current project
– Import attachments from an Excel Workbook
– Bind the attachments to specific objects (Entities, etc.).
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 Diagram.
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.
Quick Start Video Guide – ER/Studio MetaWizard Import/Export Bridges
Are you ready to streamline your data management processes effortlessly?
Look no further!
We are thrilled to announce the release of our latest video guide: “ER/Studio MetaWizard Import/Export Bridges – Quick Start Video Guide.”
How to Set Up IDERA ER/Studio Repository Database on SQL Server
This tutorial guides you through the process of setting up IDERA ER/Studio Repository on a Microsoft SQL Server. It is essential to ensure that the SQL Server environment is correctly configured to support ER/Studio Repository.
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 to|from the submodels.
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.
Using the Glossary Tool Tips
With Team Server, you can easily manage your Business Glossaries and Terms. You can directly create them in Team Server or you can synchronize them with Collibra.
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 finally import the updated Definitions and Notes back to ER/Studio Data Architect.
Why Data Model? Part 5: We Data Model to be Smart
Author This blog post was authored by Todd Schraml. Always Normalize Logical Data Models The logical data model reflects the common language of the...
Why Data Model? Part 4: We Data Model to Give Proper Focus to the Enterprise
Author This blog post was authored by Todd Schraml. Unify the Enterprise With Data Modeling Acting locally can be very different than acting...
Why Data Model? Part 3: We Data Model to be Efficient Developers
Author This blog post was authored by Todd Schraml. Why Are Logical Data Models So Important? The logical data model is the foundational artifact...
Why Data Model? Part 2: We Data Model to Communicate Better
Author This blog post was authored by Todd Schraml. Why Are Entity-relationship Diagrams So Important? One of the IT-only curse words across the...
Why Data Model? Part 1: We Data Model to be Good Business Partners
This blog post was authored by Todd Schraml. How Did Data Modeling Get Started? Back when dinosaurs still ruled the world, or at least wax figurines...
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.
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.