MongoDB Foreign Data Wrapper Guide

The MongoDB Foreign Data Wrapper (mongo_fdw) is a Postgres extension that allows you to access data that resides on a MongoDB database from EDB Postgres Advanced Server. It is a writable foreign data wrapper that you can use with Postgres functions and utilities, or in conjunction with other data that resides on a Postgres host.

The MongoDB Foreign Data Wrapper can be installed with an RPM package. You can download an installer from the EDB website.

This guide uses the term Postgres to refer to an instance of EDB Postgres Advanced Server.

• What’s New
• Requirements Overview
  • Supported Versions
  • Supported Platforms
• Architecture Overview
• Installing the MongoDB Foreign Data Wrapper
  • Installing the MongoDB Foreign Data Wrapper using an RPM Package
    • On RHEL 7
    • On RHEL 8
    • On CentOS 7
    • On CentOS 8
  • Installing the MongoDB Foreign Data Wrapper on a Debian or Ubuntu Host
• Features of the MongoDB Foreign Data Wrapper
  • Writable FDW
  • Connection Pooling
  • Automated Cleanup
• Configuring the MongoDB Foreign Data Wrapper
  • CREATE EXTENSION
  • CREATE SERVER
  • CREATE USER MAPPING
  • CREATE FOREIGN TABLE
    • Data Type Mappings
• Example: Using the MongoDB Foreign Data Wrapper
• Identifying the MongoDB Foreign Data Wrapper Version
• Conclusion