EnterpriseDB, a provider of enterprise-class Postgres products and database compatibility solutions, has released a new Postgres extension to connect MySQL and Postgres databases, giving end users the ability to get more value from their data by combining systems for a single view.
It is common for enterprises to have a mix of different database management systems, and evolving technologies, mergers and acquisitions, geographic expansion and other factors create silos of data stored in disparate systems. By using extensions called foreign data wrappers (FDWs), Postgres Plus Advanced Server, EDB’s database, can be used to federate data from multiple disparate systems.
According to EnterpriseDB, the open soruce postgres community created the foundation for integrating Postgres with external databases in 2011 when it released PostgreSQL 9.1 with support for the SQL standard SQL/MED (SQL Management of External Data).
This paved the way for the development of FDWs. Enhancements in PostgreSQL 9.3 expanded the ability of FDWs to write data to external sources in addition to the read capability added with 9.1
EDB recently developed and released to the open source community an FDW for MongoDB and announced development of an FDW for Hadoop.
The FDW for MySQL was also released to the open source community and can be found on EnterpriseDB’s GitHub repository.
Based in Bedford, MA, EnterpriseDB is backed by strategic and other investors including Red Hat and IBM.