Skip to main content
Learn how to connect Engini to IBM DB2. Using Engini’s IBM DB2 activities, you can: create, get and update records to manage and define databases.

​
Getting Started with IBM DB2

​
Prerequisites

  • A IBM DB2 account

​
Add a connection to IBM DB2 in Engini

  1. Enter your Engini account at https://app.engini.io.
  2. Navigate to Connections page by clicking on the Connections on the left sidebar or by clicking here.
  3. Click on the “New Integration” option located at the top bar.
  4. Choose IBM DB2 option from the available applications.
  5. Enter the following details in the “New Integrations” form and press Save:
    1. Connection name - Enter a unique and descriptive name for this connection. This name will help you identify and manage the connection in your Engini account. “IBM DB2” by default.
    2. Connection Method
      • Direct Access
        • DNS name - Provide the name of the DSN
        • Port - Specify the port number that the IBM DB2 server is listening on.
        • Database name - Provide the name of the specific database within the IBM DB2 server that you want to connect to.
        • Username - Enter the username associated with your IBM DB2 This username should have the necessary permissions to access and interact with the database.
        • Password - Enter the corresponding password for the provided username. Make sure the password is accurate to establish a secure connection.
        • CCSID - Specify the CCSID used by your IBM DB2 database instance. This value must match the character set configured on the database server. Relevant only for Cloud communication channel.
        • Time Zone - Select the time zone of your IBM DB2 server. This is used to correctly interpret date and time values returned from the database.
        • Communication Channel - Choose the appropriate connection type based on your setup:
        • Cloud - If you are connecting to a database hosted in a cloud environment, select “Cloud”.
        • OPA - If your database is on-premises and you are using an On-Premises Agent (OPA) for the connection, select “OPA”. In this case, an additional field will appear: On-Prem Agent - Choose the specific On-Premises Agent that you want to use for this connection if you have multiple agents configured.
      • DSN - DSN – For ODBC connections, you must have a data source name (DSN): Creating data source names (DSN) – IBM Documentation
        • DSN name - Provide the name of the DSN
        • Username - Enter the username associated with your IBM DB2 This username should have the necessary permissions to access and interact with the database.
        • Password - Enter the corresponding password for the provided username. Make sure the password is accurate to establish a secure connection.
        • Communication Channel - Choose the appropriate connection type based on your setup:
        • Cloud - If you are connecting to a database hosted in a cloud environment, select “Cloud”.
        • OPA - If your database is on-premises and you are using an On-Premises Agent (OPA) for the connection, select “OPA”. In this case, an additional field will appear: On-Prem Agent - Choose the specific On-Premises Agent that you want to use for this connection if you have multiple agents configured.
    3. Time Zone – Defines the time zone used for all date and time values when reading from or writing to the database.
    4. Communication Channel – Specifies how the connection communicates with IBM DB2 (for example, via Cloud or on-premise infrastructure).
    5. Save Settings – Saves the connection configuration and applies the selected settings.
Note: After you’ve saved the connection, you can add additional objects and actions. On the right side of the saved connection, you’ll see three dots.
  • Click on the three dots and then click on “Select database objects”.
  • A window will open displaying all available entities and actions, just like when you saved your connection. From this window, select the new entities and actions you want to use.
Once you’ve finished selecting the additional entities and actions, click Save.

​
Actions

​
Create Record

Creates a new record in an IBM DB2 table by specifying the target table and providing the field values to insert.
  1. Table
    1. Click on the empty field and the tooltip will pop up showing all the tables you can use.
    2. All available tables will be accessible and you can select the specific table for the new record you create.
  2. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Get Records

Get Records from a specified table/view.
  1. Table/View
    1. Click on the empty field and the tooltip will pop up showing all the Tables/Views you can use.
    2. All available tables/views will be accessible and you can select the specific tables/views of the records you want to get.
  2. Top N - You can set the number of rows you want to retrieve from the table or view. This parameter limits the result set to the specified number of records, with the default being 100.
  3. Offset - If you want to skip a certain number of rows before retrieving data, you can set the offset value. The default is 0, meaning no rows are skipped.
  4. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  5. Add Sort - Click Add Sort to organize the data list by a selected field in ascending or descending order. To learn more about sorting data, click here.

​
Update Record

Updates existing records in an IBM DB2 table by specifying the target table and providing the field values to update.
  1. Table
    1. Click on the empty field and the tooltip will pop up showing all the tables you can use.
    2. All available tables will be accessible and you can select the specific table of the record you want to update.
  2. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Delete Records

Deletes records from an IBM DB2 table by specifying the target table and applying filters to identify the records to remove.
  1. Table
    1. Click on the empty field and the tooltip will pop up showing all the tables you can use.
    2. All available tables will be accessible and you can select the specific table of the record(s) you want to delete.
  2. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.

​
Create Batch of Records

This activity iterates over a selected data list and for each record in the data list create records for a designated table corresponding to the specified data list.
  1. Data List - Click on the empty field next to the data list label and the tooltip will popup showing only previous activities than contains data lists from which you can choose. Choose a data list to iterate on.
  2. Table
    1. Click on the empty field and the tooltip will pop up showing all the tables you can use.
    2. All available tables will be accessible and you can select the specific table for the new records you create.
  3. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Get Records Batch

This activity iterates over a selected data list and for each record in the data list retrieves records from a designated table corresponding to the specified data list.
  1. Data List - Click on the empty field next to the data list label and the tooltip will popup showing only previous activities than contains data lists from which you can choose. Choose a data list to iterate on.
  2. Table
    • Click on the empty field and the tooltip will pop up showing all the tables you can use.
    • All available tables will be accessible and you can select the specific table of the record(s) you want to get.
  3. Top N - You can set the number of rows you want to retrieve from the table or view. This parameter limits the result set to the specified number of records, with the default being 100.
  4. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  5. Add Sort - Click Add Sort to organize the data list by a selected field in ascending or descending order. To learn more about sorting data, click here.

​
Update Batch of Records

This activity iterates over a selected data list and for each record in the data list updates records from a designated table corresponding to the specified data list.
  1. Data List - Click on the empty field next to the data list label and the tooltip will popup showing only previous activities than contains data lists from which you can choose. Choose a data list to iterate on.
  2. Table
    • Click on the empty field and the tooltip will pop up showing all the tables you can use.
    • All available tables will be accessible and you can select the specific table of the record(s) you want to update.
  3. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  4. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Execute Customized SQL

The “Execute Customized SQL” activity is an activity that allows you to interact with a IBM DB2 system by running custom SQL queries or commands within your workflow.
  • SQL - In the SQL text field, you can write and enter your own SQL queries, which are structured commands that define what you want to do with the data in the IBM DB2 system. These queries can include operations like data retrieval, modification, or database management.

​
Execute Procedure

The “Execute Procedure” activity is an activity that allows you to interact with a IBM DB2 system by running stored procedures within your workflow.
  1. Procedure Name - You need to specify the name of a stored procedure that exists within your IBM DB2 database. A stored procedure is a pre-defined, reusable set of IBM commands that are stored in the database and can be executed on demand.
  2. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.