addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

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

  • Open Source Consulting Group

    OpenSCG is a financial sponsor for the Philly PostgreSQL User Group

  • Azavea

    Azavea provides a venue for the Philly PostgreSQL User Group

  • eLocal

    eLocal provides a venue for the Philly PostgreSQL User Group

People in this
Meetup are also in:

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