gplink is a program I wrote that makes it possible to create an External Table in Greenplum that connects to ANY JDBC connection through a gpfdist process.

When to Use
Use this for either loading data into Greenplum from a JDBC source. This is similar to Outsourcer but that tool automates far more tasks and only works for SQL Server or Oracle.

You can also create federated queries between Greenplum and a JDBC source. Please use caution when doing this as the External Table does not do predicate push down so the entire query must complete in the source database before any filters can be applied.

Documentation and Source Code
gplink Github Repository

Download Version 1.0.3

2 thoughts on “gplink

  1. Paul Johnson

    With regards to Teradata, this is not always true: “- You want to use FASTEXPORT for better performance.”

    For small/medium data volumes FEXP is overkill, and is also subject to the system-wide limit on the number of utilities that can be executed concurrently, which some sites intentionally set to a low number (<10).

    I would test with/without FEXP on a case-by-case basis. As always, YMMV.

    Still a great tool though 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.