draw.io is an online diagramming tool with integrations with Jira, Google, and Confluence available free online or at cost depending on integration chosen.
$5
per month
ER/Studio
Score 9.9 out of 10
N/A
ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.
$2,687
per year per user
Pricing
draw.io
ER/Studio
Editions & Modules
Up to 10 Users
$5
per month
Up to 20 Users
$11
per month
Up to 50 Users
$27.50
per month
Up to 75 Users
$41.25
per month
Up to 100 Users
$55
per month
Up to 200 Users
$95
per month
Up to 500 Users
$152.50
per month
Up to 750 Users
$190
per month
Up to 1,000 Users
$227.50
per month
Up to 2,000 Users
$377.50
per month
Up to 5,000 Users
$827.50
per month
Up to 10,000
1,577.50
per month
Standard
$2,687
per year per user
Professional
$3,693
per year per user
Enterprise
Custom
per year per user
Offerings
Pricing Offerings
draw.io
ER/Studio
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
Pricing for new customers only, first year maintenance included. Maintenance includes access to technical support and product updates for the defined period of the agreement.
draw.io can be more suitable for technical documentation for architectures, flow diagrams/charts, and conceptual images of an application infrastructure. However, this tool is not made for business intelligence work nor for dashboarding to monitor the technical components. From the administrative standpoint, this is not well suited for agile ceremony structures like retrospective boards or planning or even quarterly planning boards. The strength of draw.io lies strongly in being a lightweight diagramming tool.
Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms
Draw.io offers a lot of shapes and customizability of how the diagrams are laid out. We've been able to create a lot of different things with it, and have barely scratched the surface of the sorts of things that we could do.
Draw.io is fairly intuitive in the way that you draw shapes and connect shapes together, I was able to figure it out without a tutorial.
Draw.io is fast and performant for me compared with some of the alternatives.
ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type.
ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names.
My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models.
ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running.
The repository can be slow when the model count gets larger. By large I mean 20 to 30 models.
A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two.
The UI is intuitive. It allows a new user to start diagramming almost instantly. Manipulating elements, linking them together, etc. are all easy to do. Draw.io nevertheless a broad variety of diagram templates to help get started and also of shapes to use in diagrams. Some situations can make it a bit tricky to use, such as when having multiple shapes on top of each other (e.g. shapes placed within swimlanes) but that's a minor issue.
The support for draw.io is pretty decent, considering it is a free website. I had a question one time when I was trying to do something, so I sent an email to their support email and got a response fairly quickly with an answer to my question. They also have some excellent support tools on their support website for helping you get more familiar with their program, and I found that very helpful.
I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.
draw.io is open-source and free for many uses, which means minimal upfront cost and good value.It works in the browser, also has a desktop version (so you can use offline) which helps teams that may not always be online or want local backups. Useful when you want a diagram tool that “just works” without huge ecosystem lock-in.For organisations that value control, less vendor-dependency, this is a plus.
ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase.
