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.
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.
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.