This post follows the previous one, “Macros – Add custom properties to specific objects”, where we shared scripts to automatically bind Attachments to ER Objects….
data modeling
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 – Using macros to create Data Vault objects
Some years ago, Sultan shared a post regarding Data Vault modeling with ER/Studio. I strongly recommend to read it before this one. The different Data…
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…
Improve data modeling with Aqua Data Studio
Data architects spend a major time of their job on data modeling. As such, they need to ensure that change to their data stores is controlled and...
Best IDE for data analysts
Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
Easier database management with Aqua Data Studio
Database administrators spend most of their time keeping databases running with little time to focus on performance and future-proof the...
Aqua Data Studio: IDE with visual analytics and automation
Aqua Data Studio accelerates data management processes by simplifying common tasks and automating routine operations. Visual analytics Run visual...
Manage schema, models, files and servers with confidence
Aqua Data Studio simplifies data-centric tasks by working on data sources without exposure to complex technical elements, detailed technical skills,...
Manage data with Aqua Data Studio
Aqua Data Studio is the industry-leading, multiple-platform, integrated development environment (IDE) for data. It provides many benefits to a...
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...
Agile is the new Waterfall
With changes in software development methodologies, the role of the data modeler has changed significantly. In many organizations, data...
Resolutions for your Data Management Strategy
As 2019 has just begun, it’s a good time to assess what you accomplished last year and what goals to set for the new year. It's also a great...
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...
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...
Data Modeling Still Important in a Big Data, Analytics World
As more organizations embrace big data and analytics to gain insight from extremely large data sets the tools and systems that we use to manage data...
IDERA Honored in DBTA’s “Big Data 50” List
We’re proud to announce that for the second straight year IDERA was named to the “Big Data 50” list published annually by...
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...
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within...
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...
Creating a Data Culture Through Continuous Improvement
Far from a one-off effort, data quality and data culture require continuous improvement and optimization. Industry leading organizations recognize...
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...
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...
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...