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
- SQL Server
- Oracle
- Hive
- Sybase ASE
- Azure SQLDB and
- MongoDB
However, there are still databases out there that need to be reverse engineered.
Why do you need to reverse Engineer MySQL / PostgreSQL?
- Ability to gather the database design
- Remodel the database
- Push the changes back to the database
What you will need
ER/Studio Data Architect
If you want to reverse one of the core products you can get a single platform license specifically for that product. Check with us which products are offered on this basis.
For the others we offer a multi platform license which include a wide range of products. Again check with us what we are currently supporting.
MySQL and PostgreSQL ODBC Drivers
They can be downloaded from the respective of vendor's websites.
Steps
- Setup the ODBC Data Source for either the data sources
- Configure the Data source from the article link
http://docwiki.embarcadero.com/ERStudioDA/170/en/Configuring_ODBC_Data_Source_and_Target_Connections
- Follow these steps to reverse engineer the database
http://docwiki.embarcadero.com/ERStudioDA/170/en/Reverse_Engineering_an_Existing_Database
- And you should be done.
For more details please download a free Trial of Data Architect here: IDERA Data Architect