IBM Cloud Docs
Connecting with third-party tools

Connecting with third-party tools

You can connect third-party command-line interfaces, applications, and tools to your IBM Db2 SaaS database.

Data integration

Segment

You can integrate Segment with a IBM Db2 SaaS database. Segment is a single platform that collects, stores, and routes your user data to hundreds of tools.

Segment

Data visualization & BI

Looker

You can connect Looker to a IBM Db2 SaaS database. Looker is a business intelligence app and big data analytics platform with which you can explore, analyze, and share real-time business analytics.

Connecting Looker

Tableau

These instructions explain how to connect Tableau to a IBM Db2 SaaS database and apply to Tableau Desktop , but you can use similar steps for other Tableau tools.

Prerequisites

Before attempting to connect to your IBM Db2 SaaS database, verify that you have the prerequisites.

Procedure

  1. In Tableau Desktop, open the window or page in your tool that is used to define a database connection.
  2. From the start page, click Connect to data.
  3. From the Data Sources list, select the data source or driver to use for your database connection. In the On a server section of the list, select IBM Db2.
  4. From the IBM DB2 Connection window, enter the connection information by using the definitions in Table 1.
  5. Click Connect to establish the connection. Tableau offers several options for connecting to your data. To make full use of your IBM Db2 SaaS database, choose the Connect Live option.
Table 1. Fields in Tableau for connection information
Tableau field Db2 connections information field
Step 1: Enter a server name Host name
Step 2: Port Port number
Step 3: Enter a database on the server Database name
Username User ID
Password Password

Microsoft Excel

These instructions explain how to connect Microsoft Excel to a IBM Db2 SaaS database.

Prerequisites

Before attempting to connect to your IBM Db2 SaaS database, verify that you have the prerequisites.

You must have the Db2 driver package or the IBM® Data Server Driver Package installed on your local computer.

Restriction: Connections between Excel and IBM Db2 SaaS are supported on only the Windows operating system.

Procedure

  1. In the web console, go to the Run SQL page.
  2. Type one or more SELECT statements in the editor text box.
  3. Click one of the Run options.
  4. Click Excel ODC File.
  5. Download and open the BLUExcel.odc file in Excel. If a security notice is displayed, click Enable.
  6. Click Open to connect to the IBM Db2 SaaS database. The Connect To DB2 Database dialog box opens.
  7. Type the user ID and password that you use to log in to IBM Db2 SaaS. To obtain the user ID and password, click Connect in the web console or Connect > Connection Information in the web console.
  8. Ensure that the connection mode is Share, and then click OK.

Results

The query results are displayed in an Excel spreadsheet. These results are the same results that are displayed in the Results viewer. Now you can generate charts and reports and analyze your data by using Excel. For more information about how to generate charts and reports and how to run SQL queries on your data from the web console, see:

Data science

SAS

These instructions explain how to create a connection from SAS to a IBM Db2 SaaS database.

Prerequisites

Before attempting to connect to your IBM Db2 SaaS database, verify that you have the prerequisites.

Procedure

For steps on how to connect from SAS to a IBM Db2 SaaS database, see the SAS documentation: