addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

PostgreSQL Federation: Joining to Oracle, Mongo and more...

As more and more alternative data stores come into use, the problem of being able to easily use and report on the data scattered across those data stores becomes increasingly difficult. PostgreSQL has a feature called Foreign Data Wrappers that allows external data sources to be queried from PostgreSQL and look like a standard table. Using Foreign Data Wrappers, users can create a report that joins data residing in Oracle, Hadoop and MongoDB all in a single query.

In this talk, Jim will discuss how to set up a Foreign Data Wrapper for various data sources and the pros and cons of using them. We'll also discuss the growing ecosystem of Foreign Data Wrapper and a little about how to write one. 

Join or login to comment.

  • Aaron B.

    Follow-up Q: Has anyone used multiple FDWs in parallel? If so, can you comment on the performance of say, unioning tables (same columns, different data) across them?

    July 15, 2014

    • Jim M.

      You can use multiple FDWs in a single query, but PostgreSQL will serially access them

      July 15, 2014

    • Aaron B.

      OK, thanks for the knowledge, both that provided at the meetup and here!

      July 15, 2014

  • john A.

    Very good coverage of the topic; felt I knew enough to get started by the end.

    July 15, 2014

  • Michael R.

    Sorry, I have a conflict

    July 14, 2014

11 went

Our Sponsors

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy