This guide will help you learn how to read/write data from/to IBM DB2 tables.

Description

Apatar works with IBM DB2 through ODBC-JDBC bridge. DB2 driver is included in the installation package but still requires a license file to work with user's DB2 database. The process of selecting the license can be done within the Connector Configuration window. Also, "Manage Licenses" button is available at the bottom of the Properties grid.

Configuration

To gain access to EnterpriseDB tables, please do the following:

1. Drag-and-drop connector for DB2 to Apatar's work panel.
   
   
   
   
2. Double-click on the connector.
3. Fill in the authorization details (database name, user name, password, and host name or address).
4. If necessary, change the port number. Connector Configuration window:
   
   
   
   Input fields specification (all fields are mandatory, except for user password):
   
   
   • UserName - user login name
   • Password - user password (required if a table is protected)
   • Host - host where DB engine is running
   • Port - port where DB engine is running
   • DBName - database name
     
     
5. Manage licenses (please read the paragraph below)
6. Click Next.
7. The list of DB2 tables occurs. Make a selection and choose the table you would like to extract data from or write data to.
8. Click Next. If all the previous actions were performed correctly, you will see the names of the data fields.
9. Click Finish.
   
   

Manage licences

     To add a new DB2 license or change an existing one, click on Manage Licenses in DB2 connector properties window. License list is empty by default.

          

• To add a license,
  
  a) please click the Add button
  b) enter the license name
  c) enter the license path or select it using the Browse button
  d) click Ok
  
  
  
  
• To edit a license,
  
  a) select a license from the list
  b) click the Edit button
  c) change the license name
  d) change the license path or select it using the Browse button
  e) click Ok
  
  
• To delete a license,
  
  a) select a license or several licenses from the list clicking Ctrl+A or holding Shift or Ctrl and clicking on the licenses
  b) click the Delete button
  c) click OK to confirm selecting the license in the Confirmation window

     Close the Manage DB2 Licenses window.

Preview

     If necessary, you can preview data. To do so, right-click on the connector and choose "Preview Results".