Database Reference
In-Depth Information
stores via a Java Database Connectivity (JDBC) interface; InfoSphere Streams;
InfoSphere Information Server (specifically, DataStage); and more. In this
section, we'll delve into the details of some of the integration points, and
merely highlight others; where we simply highlight an integration point, we
cover details in the corresponding chapters later in this topic.
The Analytics-Based IBM PureData
Systems and DB2
You can exchange data between BigInsights and any of the analytics-based
IBM PureData Systems (both the Analytics and Operational Analytics ver-
sions, or earlier versions of Netezza, or DB2 for Linux, UNIX, and Windows)
in two ways: from your database server, or from your BigInsights cluster.
These IBM database technologies can both connect and interact with BigIn-
sights through a set of user-defined functions (UDFs) that can be installed on
the database server. BigInsights can connect to the IBM PureData System for
Analytics and Netezza through a special high-speed adapter. BigInsights can
connect to the IBM PureData System for Operational Analytics or DB2
through the JDBC module (described in a later section).
BigInsights UDFs
The integration with BigInsights, the analytics-based IBM PureData Systems,
Netezza, and DB2 has two main components: a set of UDFs installed on the
database server, and a Jaql server (to listen for requests from these UDFs) on
the BigInsights cluster. The Jaql server is a middleware component that can
accept Jaql query processing requests from any system that's powered by
Netezza (running Netezza Analytics version 2.0 or later) or DB2 server
(version 9.5 or later) technology. Specifically, the Jaql server can accept the
following kinds of Jaql queries from a supported database DB2 server:
•
Read data from the BigInsights cluster.
•
Upload (or remove) modules of Jaql code in the BigInsights cluster.
•
Submit Jaql jobs (which can refer to modules you previously uploaded
from supported database servers) to be run on the BigInsights cluster.
•
(IBM PureData System for Analytics only) Write data from the data
warehouse to the BigInsights cluster.
