HOUSTON, TX – December 12, 2019 – IDERA (an Idera, Inc. company) today announced the latest release of its ER/Studio data modeling tools with extensive support for Amazon Redshift, the fully managed petabyte-scale data warehouse service in the cloud.

As cloud services accelerate in popularity, Amazon Redshift has become one of the premier cloud data warehouse platforms. Companies adopting these platforms into enterprise data architecture need tools to help enforce consistency, data quality, and data governance across the organization.

ER/Studio is a business-driven data architecture solution that combines multi-platform data modeling, business process modeling, and enterprise metadata for organizations of all sizes. Data professionals who design and manage Amazon Redshift databases can use the tool to capture business requirements, translate them into design, and automatically deploy to a new Redshift platform. Furthermore, as the design evolves, ER/Studio will manage and track any modifications and deploy them to a live database. All of this can be done within a broader data governance framework.

ER/Studio’s extensive support for Amazon Redshift provides better visibility and easier updates to data structures, including:

  • Forward and reverse engineering with DDL (Data Definition Language) code
  • Compare and merge capabilities with ALTER script generation
  • Access to tables, views, columns, and constraints
  • Management of users, schemas, and procedures

“Tens of thousands of companies around the world rely on Amazon Redshift performance and reliability to run their business-critical workloads,” said Stan Geiger, director of product management at IDERA. “Maintaining the integrity of data sources and data structures is key to that success. ER/Studio embraces the power of the cloud while helping customers enable data governance, close the gaps between data modeling and development, and improve collaboration between data professionals and business users.”

With an extensive feature set, the ER/Studio Enterprise Team Edition suite provides robust logical and physical modeling with ER/Studio Data Architect, business process and conceptual modeling with ER/Studio Business Architect, business glossaries and metadata management with ER/Studio Team Server, and more, to enable the foundation of data governance programs.

To learn more about ER/Studio data modeling tools, visit: https://www.idera.com/er-studio-enterprise-architecture-solutions..


IDERA provides database tools that help IT professionals improve data quality, boost data performance and ensure data integrity across complex environments. A community of more than 100,000 users in healthcare, financial services, retail and technology rely on IDERA products to optimize business data and take advantage of new business opportunities. IDERA is a division of Idera, Inc. To learn more, visit www.idera.com.