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 engineer databases natively with 

  1. SQL Server 
  2. Oracle
  3. Hive
  4. Sybase ASE
  5. Azure SQLDB and
  6. MongoDB

However, there are still databases out there that need to be reverse engineered.

Why do you need to reverse Engineer MySQL / PostgreSQL?

  1. Ability to gather the database design
  2. Remodel the database
  3. Push the changes back to the database

     

What you will need

ER/Studio Data Architect - Any edition

MySQL and PostgreSQL ODBC Drivers

They can be downloaded from the respective of vendor's websites.

Steps

  1. Setup the ODBC Data Source for either the data sources


  2. Configure the Data source from the article link 

    http://docwiki.embarcadero.com/ERStudioDA/170/en/Configuring_ODBC_Data_Source_and_Target_Connections 

  3. Follow these steps to reverse engineer the database

    http://docwiki.embarcadero.com/ERStudioDA/170/en/Reverse_Engineering_an_Existing_Database



  4. And you should be done. 

For more details please download a free Trial of Data Architect here:  IDERA Data Architect

Anonymous