This post follows the previous one, “Macros – Add custom properties to specific objects”, where we shared scripts to automatically bind Attachments to ER Objects….
ER/Studio Data Architect
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- 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 – 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,…
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…
Macros – Sample macros to import Logical and Physical Data Models from Microsoft Visio to ER/Studio Data Architect
Visio can draw charts, plans and diagrams. Some people have used Visio to create their Logical and/or Physical Data Models and they would like to…
IDERA Newsletter August 2020 (Database Developer edition)
Product Release New! Aqua Data Studio 20.6 We are delighted to announce that the latest release of Aqua Data Studio is now available....
IDERA Newsletter April 2020
The Latest News from IDERA Product Release Updates, Vote IDERA, and Learn Something New Introducing SQL Inventory Manager v2.6 Get Complete...
Large Financial Organization Using ER/Studio to Manage Data – Case Study
This is one of our larger clients. They are a huge financial organization. They use ER/Studio to document and design data assets. As they say...
Benefit from these free resources to learn more about the cloud
This blog post is an update to the previous blog post “Learn more about the cloud with these free resources” from Thursday, May 3, 2018....
Back to Basics: Build a Foundation for Data Governance in 2019
Those who are watching the data management industry have definitely seen an increase in the volume of posts, whitepapers, and webinars on the topic...
Could Your Merger or Acqusition Detect a Data Breach?
It seems like we hear about a new data breach on an almost daily basis. This past week, we heard about two newsworthy data breaches that were...
Reverse Engineer SnowFlake from IDERA ER/Studio
Howdy! In this short and concise blog post, I am really excited to be sharing on how to reverse engineer from ER/Studio via ODBC. Step 1 -->...
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...
These are a few of my Favorite Macros!
Howdy! ER/Studio Users, Prospective Users and Data Modeling Enthusiasts.. In this short blog post , I would like to list out some of my Favorite...
Data Breaches Are Common – Are You Prepared?
October is National Cybersecurity Awareness Month. In preparation for that, I thought I might take a moment to ponder some security issues...
IDERA Now Offers Safyr for ER/Studio
Hopefully you’ve seen the news by now, but if you haven’t, you should know that earlier this month, Silwood Technologies announced that...
Is Data Governance important to you? Then Data Modeling should be too!
Data governance is a hot topic lately. Companies are trying to devise and implement governance programs in order to provide some structure around...
Announcing ER/Studio 17.1 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1 ER/Studio 17.1 contains improvements and enhancements in a number...
Why Data Breach is a Significant Part of GDPR
Last week I spoke at DAMA Day in NYC. The day was focused on GDPR and all of the implications in the regulation. I decided to focus my talk on why...
Data Lineage – The Power to Connect the Dots in ER/Studio
Howdy! Ever considered or wanted to know how Data would move around the organization? Data Lineage is a key driver that ensures on connecting 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...
Beyond Cloud: The Multi-Hybrid Data Ecosystem
Last week, Idera, Inc. sponsored Enterprise Data World 2018 in San Diego, CA. As usual, it was a fantastic event, organized by the great team...
Learn More about the Cloud with these Free Resources
You may already know that the cloud provides always-on architecture, automatic monitoring and management, enterprise-class security, fast access to...
Diving into Data Architecture in San Diego
Idera, Inc. enjoyed participating as a sponsor for this year’s Enterprise Data World event, run by the great folks at DATAVERSITY in San Diego...
April SQLChat on DataGovernance (on Twitter)
This week I had the honor to host the #SQLChat on Twitter on the topic of Data Governance. Here's some quick highlights from hour long...
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...
Learning from Facebook’s Data Harvesting Mistakes
At the moment, Mark Zuckerberg is testifying in front of Congress. Facebook is under the microscope because they allowed an app to take data that...
Setting up ER/Studio in the Google Cloud Platform – Part I – Setup
Hi All, In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud. In Part...
Is Redshift giving you the Blues? ER/Studio has the cure.
In my 35 years of data modeling many data platforms have come and gone, while others continue to change. For many, maintaining pace with the...
Battle the Dark Side of Data Governance
In recent years, there has been a re-awakening, with organizations recognizing the importance of data not only as an operational imperative, but...
ER/Studio 17.0.2 is available
We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.0.2 ER/Studio 17.0.2 contains improvements and enhancements in a...