Configuring a DB2 Data Source

From Explore Analytics: The Wiki
Revision as of 16:41, 23 September 2015 by Gadiyedwab (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Overview

Explore Analytics supports two modes of connecting to your DB2 database:

  1. Direct - if your database is accessible directly from the cloud, for example if it resides on Amazon AWS, then you can directly connect to it.
  2. Agent - if your database resides in your private network, the Explore Analytics Agent facilitates the communication between Explore Analytics and your database.

If the agent is required, please see the section Installing the Explore Analytics Agent for installation instructions.

The agent should be installed on a Windows computer that has access to the database. For example, you may install it on the computer that hosts the database.

Unless you're using a direct connection, the rest of this page assumes that you have the agent installed and running. You're now ready to setup a DB2 data source and create live reports that draw data directly from your database.

Creating the Data Source

To create the data source, go to the "Data" menu and select the option "Add a new data source", then select "DB2". You will see the following dialog. Select "Direct" or "Agent".

Add db2 data source.png

You will then see the following dialog. If you selected "Direct", then the agent drop-down selection will be absent. We show the dialog with some example inputs already populated. We then explain each entry.

Add db2 agent data source.png

Data Source Name

Give this data source a name that would identify it.

Description

Optional description. This is shown when you list data sources to help users choose the correct data source.

Agent Service Account

The choices for this field are typically pre-populated for you, and there's usually only one choice. This is the name of the Explore Analytics account through which the agent connects to Explore Analytics. You will need to make a selection here only if you have multiple agents that service different data sources.

DB2 Host

This is the host name (computer name) of the computer on which DB2 resides. If the agent is installed on the same computer as the database, then you can typically refer to the host as "localhost" as in our example. If the database is on another computer, enter the name or IP address of that computer.

DB2 Port

You can specify the TCP port that your DB2 server listens on by adding it to the DB2 Host and separating using a colon. For example, port 50000 on localhost is written as localhost:50000

DB2 User

This is the name of the database user through which we connect to the database to access data.

DB2 Password

The password of the user entered in the previous field.

DB2 Database Name

Your database manages several "databases" each one has a database name (this is a DB2 terminology). The data source is for one such database. Please specify the name of the database (in our example it is "SAMPLE", an example database for DB2).

Getting Help

Setting up an agent-based data source is the most difficult task in Explore Analytics. Don't hesitate to seek help. You can contact Explore Analytics Support.