EDB Data Adapters

Transparent data integration for Postgres-based digital business solutions

With EDB Postgres Data Adapters you can eliminate data silos and gain a holistic view of your data.

Built on Postgres Foreign Data Wrappers and a component of the EDB Postgres Platform, EDB Postgres Data Adapters implement SQL/MED (SQL’s Management of External Data specification) to enable traditional BI applications to analyze NoSQL data using SQL through EDB Postgres. EDB Postgres becomes a single integration point for viewing and managing data from remote relational or non-relational databases. MongoDB®, Hadoop®, and MySQL™ sources are supported.

With no need to copy data across servers, you can combine data from various data sources – for example, archived data, ERP data, and/or clickstream data – to gain valuable benefits such as 360-degree customer views and end-to-end supply chain insights.

Graphic of database with plugs

How EDB Postgres Data Adapters Work

EDB Postgres Data Adapters, which are part of the EDB Postgres Platform, provide transparent data integration by presenting remote data as if it were stored in a local Postgres table.

Icon

EDB Postgres Data Adapter for MongoDB®

Allows read/write access from EDB Postgres Advanced Server and PostgreSQL to MongoDB. Predicate pushdown for SELECT and WHERE improves the result set returned via the network, and predicate pushdown to JOIN, LIMIT, various aggregates, and sort is planned.

Icon

EDB Postgres Data Adapter for Hadoop®

Allows read access from EDB Postgres Advanced Server and PostgreSQL to Hadoop Hive. EDB Postgres connects to a mapping table in Hive to access data stored in HDFS (Hadoop Distributed File System). Predicate pushdown for SELECT and WHERE improves the result set returned via the network. The Adapter is Hortonworks Yarn certified, and certified to run on Apache Spark using the Spark Thrift Server.

Icon

EDB Postgres Data Adapter for MySQL™

Allows read/write access from EDB Postgres Advanced Server and PostgreSQL to MySQL. Predicate pushdown for SELECT and WHERE improves the result set returned via the network, and predicate pushdown to JOIN, LIMIT, various aggregates, and sort is planned.