BEDFORD, Mass., July 24, 2014 –
New Foreign Data Wrappers expand PostgreSQL’s ability to support data integration and connect data silos
EnterpriseDB (EDB), the leading worldwide provider of enterprise-class Postgres products and Oracle database compatibility solutions, today announced the first release of two new extensions that expand PostgreSQL’s ability to seamlessly integrate information from big data and NoSQL-only solutions. Providing a single view of data across multiple sources breaks down barriers between the siloes created by big data and NoSQL-only solutions and deepens end user insight into their data.
EDB has released an updated Foreign Data Wrapper (FDW) for MongoDB to the open source PostgreSQL community and is planning to release one for Hadoop in fall. The Foreign Data Wrappers take advantage of expanded capabilities that were introduced in PostgreSQL v9.3. EDB further optimized the MongoDB FDW for performance and long-term code stability through the use of the new MongoDB Meta Driver.
“Specialized database technologies that target a single problem can be useful in some cases. But they introduce complexity into the enterprise data environment by creating data silos that erode corporate standards in application logic,” said Marc Linster, senior vice president, products and services, at EnterpriseDB. “The new Foreign Data Wrapper makes data in silos residing in MongoDB deployments more useful by integrating it with the enterprise database management systems. This provides a seamless experience for gaining deeper insight from a greater variety of data types and eases data governance problems.”
As new data technologies and solution sources emerged, developers in the open source community built capabilities for using Postgres to work with data from outside sources. Foreign Data Wrappers were made possible in 2011 with the release of PostgreSQL 9.1, which featured support for the ANSI SQL Standard implementation of SQL/MED (SQL Management of External Data). FDWs enable users to integrate structured and unstructured data within their Postgres databases, where they can read and write SQL queries to foreign data sources.
Postgres has Foreign Data Wrappers for MongoDB, CouchDB, Informix, MySQL, Neo4j, Oracle, Redis and others. They can map to the JDBC, LDAP and ODBC interfaces and work with such non-traditional data sources as files, HTTP, Amazon’s S3 and Twitter.
Find a technical overview of the FDW and implementation examples here.
About EnterpriseDB Corporation
EnterpriseDB is the leading worldwide provider of Postgres software and services that enable enterprises to reduce their reliance on costly proprietary solutions and slash their database spend by 80% or more. With powerful performance and security enhancements for PostgreSQL, sophisticated management tools for global deployments and Oracle compatibility, EnterpriseDB software supports both mission and non-mission critical enterprise applications. More than 2,500 enterprises, governments and other organizations worldwide use EnterpriseDB software, support, training and professional services to integrate open source software into their existing data infrastructures. Based in Bedford, MA, EnterpriseDB is backed by top-tier venture capitalists and strategic investors like Red Hat and IBM. For more information, please visit https://www.enterprisedb.com.