The data warehouse is an established concept and discipline that is discussed in books, conferences, and seminars. Indeed, data warehouses are a...
ER/Studio Data Architect
Discover why data modeling is data governance
Data modeling is data governance. We define data governance as the execution and enforcement of authority over the definition, production, and usage...
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.
Understand the return on investment (ROI) in data modeling
For over three decades now, data modeling has been the leading discipline for understanding business data requirements and representing them in a...
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.
Agile data modeling is not an option but essential
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...
Model data for MongoDB and JSON
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 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.
Ensure a sustainable architecture for data analytics
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...
Agile versus fragile data modeling workflow
Many data modelers are finding out that their traditional data modeling processes are not a good fit for modern software development methods, such...
Build stronger data architecture teams
When teams work together with a common goal and a passion for success, their projects succeed. When the opposite occurs, everyone loses, including...
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 for better data governance
Are your data models supporting data governance? Most data professionals have been involved in data governance programs in our careers. These...
Master data modeling for master data domains
Greater dependence on enterprise-class applications has created a demand for centralizing organizational data in their support. Imperatives such as...
Make the most of your metadata
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...
Empower operational data governance with data lineage
Much of the conventional guidance about implementing a data governance program focuses on organizational structure and the protocols for defining...
Enable customer business intelligence with data catalogs, business glossaries, and data governance
For over three decades, organizations have relied on data warehouses to support the needs for descriptive analytics of business information...
Align data governance with business-driven data architecture
The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...
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.
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.2
ER/Studio 19.2 delivers a whole new approach to modelling hierarchical structures such as document-based NoSQL platforms and file formats, with...
How to Use Data Modeling When Migrating to the Cloud
Over the past decade or so, cloud providers have steadily expanded their portfolio of offerings. This has complicated the process of migrating...
Why Data Modeling Makes Information Resources More Valuable
Enterprise data comprises one of an organization’s most valuable resources. The ability to compete with market rivals is directly impacted by...
IDERA’s ER/Studio Selected as Best Database Management Software of 2021
We are extremely pleased to announce the inclusion of IDERA’s ER/Studio Data Architect in Digital.com's list of the Best Database...
Top Six Data Modeling Benefits
Data modeling benefits the modern, data-driven organization greatly. It provides organizations with a blueprint and process for planning, creating...