EnterpriseDB Releases New Postgres Extension to Connect MySQL and Postgres Databases By CIOReview Team

EnterpriseDB Releases New Postgres Extension to Connect MySQL and Postgres Databases

CIOReview Team | Saturday, 27 June 2015, 06:44 IST

  •  No Image

Postgres software provider EnterpriseDB announces the release of a new Postgres extension that lets users seamlessly connect MySQL and Postgres databases.

The extensions  enables Postgres to federate data and gives end users broad new powers to realize greater value from their data by combining systems for a single view of customer and other data.

 An enterprise typically comprises a mix of different database management systems. Evolving technologies, acquisitions or mergers, geographic expansion and other factors create silos of data stored in disparate systems that companies struggle to integrate. 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. 

 “Enterprises commonly run databases from a mix of vendors in their data centers. There is a huge benefit to having one database to examine sales orders, web activity, product management, invoicing and supply chain information, combining structured and unstructured data without sacrificing ACID compliance,” says Marc Linster, Senior Vice President, Products and Services at EnterpriseDB.

The open source Postgres community laid 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), making 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.

CIO Viewpoint

Artificial Intelligence & The Disruptive Chatbot

By Vishal Sinha, President & CIO, Tranzlease Holdings

IoT: Technology Trends to Watch Out for in 2021

By Sudeep Agrawal, AVP and Head IT, ReNew Power

Reskilling IT with IOT, Cloud & AI

By Uttam Kumar, Head - IT Innovations & New Technology, Aircel

CXO Insights

4 Must Have IT Security Skill sets To Counter...

By Sunil Sharma, Managing Director - Sales, India & SAARC, Sophos

How Low-Code Is Transforming The Future Of Work...

By Deepak Pargaonkar, VP - Solution Engineering, Salesforce

The Path To Managing Data As An Asset

By Lenin Gali, VP, Data Engineering, Quotient Technology

Facebook