data architect Archives

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

by Peter

Data modeling produces a set of structures for a relational database management system (RDBMS). First, we build the conceptual data model (CDM) to...

Ensure a sustainable architecture for data analytics

by Peter

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

by Peter

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

by Peter

When teams work together with a common goal and a passion for success, their projects succeed. When the opposite occurs, everyone loses, including...

Improve data modeling for better data governance

by Peter

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

by Peter

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

by Peter

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

by Peter

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

by Peter

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

by Peter

The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...

ER/Studio 18.2 General Availability

by Jamie Knowles

We are pleased to announce the general availability (GA) of IDERA ER/Studio 18.2 ER/Studio 18.2 contains support for the Amazon Redshift database in...

ER/Studio Data Architect 18.0.1 patch release is available!

by Ron Huizenga

We are pleased to announce the availability of the ER/Studio Data Architect 18.0.1 patch release ER/Studio 18.0.1 Data Architect corrects an...

ER/Studio 18.0 is now available!

by Ron Huizenga

We are excited to announce the general availability (GA) of IDERA ER/Studio 18.0 ER/Studio 18.0 contains major usability, reliability and...

Naming Standards Templates Demystified – a Primer

by aniltexascowboy

Howdy! Welcome to the Naming Standards Templates Demystified blog post! In this post, we will achieve the following objectives This applies to all...

Back to Basics: Build a Foundation for Data Governance in 2019

by Joy Ruff

Those who are watching the data management industry have definitely seen an increase in the volume of posts, whitepapers, and webinars on the topic...

Connecting to PostgreSQL and MySQL via ODBC to IDERA’s ER/Studio Data Architect

by aniltexascowboy

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...