EDB Data Adapters

Transparent data integration for Postgres-based digital business solutions

EDB Data Adapters

EDB Data Adapters

EDB Postgres Data Adapters are Postgres Foreign Data Wrappers, implementing the SQL/MED (Management of External Data) standard to provide transparent data integration to support data federation in digital business solutions.

The remote data sources include MongoDB®, Hadoop®, and MySQL™.

Overview

Architecture

EDB Data Adapters Architecture

Data Platform

Data Platform

EDB Postgres Data Adapters build the foundation for a data platform to provide enterprises with a holistic view of data. This view might include customer data, a purchase history, social media, web logs, click stream or sensor data.

The ability to integrate remote data sources is key to unified data management. A data platform with EDB Postgres as the unifying component allows customers access to remote data sources through a single SQL interface regardless of whether the source is a relational or non-relational database or data store.

The remote data sources include MongoDB®, Hadoop®, and MySQL™.

Data Adapter for MongoDB

Data Adapter for MongoDB

The EDB Postgres Data Adapter for MongoDB allows read/write access from EDB Postgres Advanced Server and PostgreSQL to MongoDB. It presents remote data as if it were stored in a local Postgres table.

The predicate pushdown for SELECT and WHERE improves the result set returned via the network. Predicate pushdown to JOIN, LIMIT, various aggregates and sort are planned.

Data Adapter for Hadoop

Data Adapter for Hadoop

The 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). The EDB Postgres Data Adapter for Hadoop presents remote data as if it were stored in a local Postgres table.

The predicate pushdown for SELECT and WHERE improves the result set returned via the network.

The EDB Postgres Data Adapter for Hadoop is Hortonworks Yarn certified.

The EDB Postgres Data Adapter for Hadoop is also certified to run on Apache Spark using the Spark Thirft Server.

Future versions may include predicate pushdown for JOIN, and LIMIT, various aggregates, sort and write access including INSERT, UPDATE, and DELETE.

Data Adapter for MySQL

Data Adapter for MySQL

The EDB Postgres Data Adapter for MySQL allows read/write access from EDB Postgres Advanced Server and PostgreSQL to MySQL. It presents remote data as if it were stored in a local Postgres table.

The predicate pushdown for SELECT and WHERE improves the result set returned via the network. Predicate pushdown to JOIN, LIMIT, various aggregates and sort are planned.

Resources