Businesses these days rely heavily on data to make important decisions on a day-to-day basis. The flow of correct and consistent data is of great importance for business users to make quick and well informed decisions. The flow and relationships of data need to be defined and structured to ensure best results. This process is called Data Modelling. To avoid human error and speed up the process specialised software is used to help with building a logical data model, a physical data model, creating DDL and being able to build reports to describe and share the model with other stakeholders. This list is the top tool pick from the consultants here at Data to Value.



PowerDesigner is arguably the industry’s leading data modelling tool. Its features include: fully integrated models, different modelling techniques that cater to both an IT-centric audience and non IT-centric. It also supports a powerful metadata repository and various output formats. It has a nice and polished user interface with easily readable help documentation aiding the user to quickly solve ad hoc problems.



ER/Studio is an intuitive data modelling tool that supports single and multi-platform environments, with native integration for big data platforms such as – MongoDB and Hadoop Hive. It can forward and reverse engineer models, includes a compare and merge function and is able to create reports in various formats (XML, PNG, JPEG). Built-in features automate routine tasks and supports the popular database platforms. ER/Studio is a great tool that that is easy to start working with due to its intuitive design and good user support.



Sparx Enterprise Architect

Enterprise Architect is a feature rich data modelling tool that prides itself on being the cost-efficient option. It helps business users build robust and maintainable systems quickly and can easily scale to accommodate large teams collaborating on shared projects. Enterprise Architect also has the capability of running a dynamic model simulations to verify the correctness of models and provide better understanding of how specific business systems operate.



Oracle SQL Developer Data Modeler

Oracle data modeller is a free graphical tool to help business users with data modelling tasks. This tool is robust, offering features and utilities centred around productivity. This includes easily accessible report tool, DDL preview capabilities, built in quality check tool and a sophisticated search engine.

CA ERwin

ERwin is one of the leading data modelling solutions that provides a simple, polished user interface for a complex data environment. This solution provides business agility – models and metadata can be managed in a common repository to ensure consistency and security. ERwin supports high customisation and automation allowing macro language, custom datatypes, APIs and much more. It also has an extensive user community enabling consumers to share knowledge and expertise.



IBM - InfoSphere Data Architect

InfoSphere is an innovative data modelling tool that runs on an open-source platform – Eclipse. Infopshere focuses on three key areas: efficiency, simplicity and integration. This tools helps business users create logical and physical data model diagrams which can be used for a variety of applications and systems. This end-to-end solution can be used to create, deploy and update data models in a quick and efficient manner. It also provides easy integration with other related IBM products.


About us

Data to Value are a specialist Data consultancy, based in London. We apply graph technology to a variety of data requirements as part of next generation data strategies. Contact us for more details if you are interesting in finding out how we can help your organisation leverage this approach.

Views: 165704

Tags: Big Data, DDL, Data modeling, Metadata, Software, Tools, reporting


You need to be a member of Data Science Central to add comments!

Join Data Science Central

Comment by Kayise T Reyes on May 13, 2021 at 9:05pm

Thank you so much, I was searching for the information the whole day on collecting data for my livestock farming project. Now I've got the answers to the questions I have.

Comment by Manish on November 6, 2020 at 11:47pm
Comment by Juan on March 16, 2018 at 1:07am


the article has scattered and incomplete information from the tools, and can lead to confusion among readers. For example, if you mention that ERwin has macros, you should mention them in Power Designer or ER/Studio, which not only allow macros to extract information, but also allow you to modify the model. This particular characteristic can be definitive in the choice of a new tool for a company, since the range of possibilities it opens up is immense.

Comment by gracylayla on September 20, 2017 at 3:49am


This post is much helpful for us. It was an excellent Tutorial on Data Modelling Concepts to hear from you which is very useful. Thank you for sharing.

© 2021   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service