Connect to IBM Db2

​

IBM db2 Data Source

​

Create an IBM db2 tabular Data Source

1. From the navigation pane, click Data > Data Sources.
2. Click Create a Data Source.
3. In the New Data Source window, from Select Data Store, select DB2.
4. Enter the Host. Valid values are <host string>:<port> or <host string>. If no port is specified, the default is 50000.
5. Enter the name of the Database.
6. Enter the Data Source Name.
7. Optional: Enter a Description to explain the purpose of the Data Source to others.
8. Click Next.
9. Specify the credentials for authenticating to db2, only Basic authentication is supported
10. Select whether Everyone can access this Data Source or just Specific users or organizations.
11. Select who can view and use the Data Source in projects.
12. Click Finish Setup.

​

Direct connection

​

Python and ibm_DB2

​

Environment setup

RUN pip install ibm_db ibm_db_sa

​

Credential setup

• db_username
• db_password

​

Usage

• You have set up the environment variables with the db_username and db_password.
• You’ve replaced my.host.name with the host name for your machine.

import ibm_db
import ibm_db_dbi
import pandas as pd

hostname = 'my.host.name'
port = 50001
username = os.environ['db_username']
password = os.environ['db_password']

def query_db(sql):
 ibm_db_conn = ibm_db.connect("DATABASE=IBMPROD;HOSTNAME={};PORT={};PROTOCOL=TCPIP;UID={};PWD={};".format(hostname, port, username, password), "", "")
 conn = ibm_db_dbi.Connection(ibm_db_conn)

 df = pd.read_sql_query(sql, conn)
 ibm_db.close(ibm_db_conn)
 return df

sql_cmd = """

SELECT
 *
FROM
 table

"""

df_cmd = query_db(sql_cmd)

df_cmd

​

R and ibmdbR

​

Environment setup

RUN R -e 'install.packages("ibmdbR")'

​

Next steps

• After connecting to your Data Source, learn how to Use Data Sources.
• Share this Data Source with your collaborators.