Looker supports IBM’s DB2 database on AS400, which is discussed here.
Looker also supports IBM’s DB2 for Linux, Unix, and Windows (LUW), as described on this documentation page, and connecting to a DB2 Warehouse on Cloud (dashDB), as described on this documentation page.
To connect Looker to your IBM DB2 database on AS400, follow the steps below:
Add the AS400 Driver
lookerdirectory, create a text file named
custom_jdbc_config.ymlthat contains the following:
- name: as400 dir_name: as400 module_path: com.ibm.as400.access.AS400JDBCDriver
lookerdirectory, create a new directory called
custom_jbdc_drivers, and then under that new directory, create a new directory called
Copy the file
jt400.jarto the new
as400directory. You can download the
jt400.jaris in the
Create or update the file
lookerstart.cfgand add the following:
If Looker is running, restart Looker.
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:
Looker’s ability to provide some features depends on whether the database dialect can support them.
In the current Looker release, IBM DB2 supports the following Looker features:
After completing the database configuration, you can connect to the database from Looker using these directions.