Looker supports IBM’s DB2 database on AS400, which is discussed on this IBM Knowledge Center page.
Looker also supports IBM’s DB2 for Linux, Unix, and Windows (LUW), as described on the IBM DB2 for Linux, UNIX, and Windows (LUW) documentation page, and connecting to a DB2 Warehouse on Cloud (dashDB), as described on this IBM DB2 Warehouse on Cloud (dashDB) documentation page.
To connect Looker to your IBM DB2 database on AS400, follow the steps below:
Installing the AS400 JDBC Driver
jt400.jar file from this downloads page. You will need to extract it from
Follow the steps on the Custom JDBC Drivers documentation page using the values below:
- name: as400 dir_name: as400 module_path: com.ibm.as400.access.AS400JDBCDriver
For the step to put the driver in your dialect’s directory, the path to this file will look like this:
Users and Security
Create a user with a secure password to connect to Looker. This user should have read access to all tables to be explored in Looker.
Use the following command to create a schema:
Give the user that will access Looker write access to the schema.
In order to enable query killing, implement the following stored procedure:
For Looker to support some features, your database dialect must also support them.
In Looker 21.0, IBM DB2 supports the following Looker features:
After completing the database configuration, you can connect to the database from Looker using these directions.