FDW (Foreign Data Wrapper)

/FDW (Foreign Data Wrapper)

Video – Behold! The Power of Foreign Data Wrappers!

If you've never heard of PostgreSQL's “foreign data wrappers” -- you've been missing out on a very powerful tool to connect and integrate heterogenous databases. By leveraging FDW's, you can put PostgreSQL at the center of a integrated database federation and read and write data from other PostgreSQL servers, other relational databases (Oracle, MySQL), many NoSQL systems (MongoDB, Hadoop) [...]

By | December 10th, 2015|FDW (Foreign Data Wrapper), OpenSCG|0 Comments

BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

The BigSQL developer's bundle has added a significant new component: Cassandra 2.0.4.  All of the bundles and VM's now allow developers to get up and running with the latest Hadoop ecosystem and Cassandra.   Join our free Beta program now!   As a significant number of our clients are leveraging Cassandra for Highly Available Multi Partition [...]

By | January 16th, 2014|Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, PostgreSQL|Comments Off on BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

Hive, Postgres, and Hadoop Foreign Data Wrapper Video Tutorial

This demo shows how to run an example in BigSQL that uses Hive, Hadoop, PostgreSQL, and the Hadoop Foreign Data Wrapper to leverage the power of Hadoop from within PostgreSQL. This tutorial uses BigSQL 9.3 Release 2 - Beta2, which includes Hadoop-2.2 and Hive-0.12. You can download the newest release, or the Quick start VM [...]

By | November 25th, 2013|BigSQL, Cady PostgreSQL, FDW (Foreign Data Wrapper), Hadoop, PostgreSQL|Comments Off on Hive, Postgres, and Hadoop Foreign Data Wrapper Video Tutorial

PostgreSQL, Hadoop, and Pentaho to Analyze and Visualize Data

This tutorial shows how to use Postgres, Hadoop, Hive, Hbase, and Pig to load, refine, and store big data for visualization- all in fewer than five minutes. You can watch the BigSQL, Postgres + Hadoop, Pentaho Demo here or follow along with the written version below. [youtube url="http://www.youtube.com/watch?v=eSEe_33pImA" fs="1" rel="0"] The following tutorial shows the scripts [...]

By | September 30th, 2013|Big Data, BigSQL, Cady PostgreSQL, FDW (Foreign Data Wrapper), Hadoop, PostgreSQL, presentation|Comments Off on PostgreSQL, Hadoop, and Pentaho to Analyze and Visualize Data

HadoopFDW

With the release of PostgreSQL 9.3, it let's us do some really cool things with writable foreign tables. BigSQL has just released a Hadoop Foreign Data Wrapper that is writable into HDFS files and Hbase tables. The Hbase integration allows for full SELECT, INSERT, UPDATE and DELETE syntax through PostgreSQL and the HDFS integration allows [...]

By | September 18th, 2013|Big Data, BigSQL, FDW (Foreign Data Wrapper), Jim PostgreSQL|Comments Off on HadoopFDW

Hadoop Thrift Tutorial

At OpenSCG we have been using thrift to make a Hadoop Foreign Data Wrapper. This tool, which is already integrated into BigSQL, allows you to take advantage of the power of Hadoop from within PostgreSQL. The BigSQL Tutorial show how you can easily create a postgres table that references a Hive or Hbase table, run [...]

By | August 21st, 2013|BigSQL, Cady PostgreSQL, FDW (Foreign Data Wrapper), Hadoop, Java, PostgreSQL, Python|Comments Off on Hadoop Thrift Tutorial

Postgres FDW’s are HOT

Over the last couple years Postgres Foreign Data Wrappers (FDW's) having matured into something very powerful and complete. You can integrate with other Postgres and non-Postgres database instances natively and seamlessly. Check out this blog post from the good people at Heroku and you'll start to understand the beauty and simplicity. The postgres_fdw data wrapper [...]

By | August 5th, 2013|BigSQL, FDW (Foreign Data Wrapper), Hadoop, PostgreSQL|Comments Off on Postgres FDW’s are HOT

Meetup: Leveraging Hadoop in your PostgreSQL Environment

Our very own Jim "Jimbo" Mlodgenski will be hosting a Meetup Thursday June 27th at 6pm to discuss: Leveraging Hadoop in your PostgreSQL Environment! The event will be graciously held at: Slader 199 Lafayette Street Suite 3B New York, NY To register click here Details.... There is buzz everywhere about Apache Hadoop and rightfully so. It's an [...]

By | June 19th, 2013|Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on Meetup: Leveraging Hadoop in your PostgreSQL Environment

PostgreSQL FDW to Hadoop Hive Tutorial

PostgreSQL Foreign Data Wrapper to Hadoop Hive Tutorial 2 In our last tutorial, Hadoop Hive Tutorial – Zero to Results in 15 Minutes, we installed Postgres and Hadoop and ran some simple queries against a sample dataset directly against Hive tables.  In this tutorial we will create a FDW (Foreign Data Wrapper) in Postgres and access the [...]

By | May 30th, 2013|Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on PostgreSQL FDW to Hadoop Hive Tutorial