Db2

You can connect your Db2 database as a source connection in Etleap. This page focuses on the connection setup required when using Db2 as a source.

Source Setup

Step 1. Create a Database User

To create a user that will allow Etleap to connect to your database, please complete the following:

1. Create a user at the operating system level . You must have root authority to create a user.
2. Set the password for the user.
3. Grant Usage permission to the tables you would like to extract data from.

   GRANT SELECT ON TABLE <table_name> TO USER <user_name>;

This user can now be used to set up a new connection in Etleap.

Step 2. Whitelist Etleap’s IP Addresses

Etleap’s IP addresses must be whitelisted in Db2. There are different addresses to whitelist depending on your deployment model. Review the IP Whitelisting article for more information on which to use.

Version Compatibility

Etleap supports Db2 versions 11.5.x running on Linux systems. Newer versions and differnt OSs may be compatible, but have not yet been confirmed.