DataPower

Tenant configuration with SQL Data Source in DataPower

On physical DataPower appliances with the Tenant feature, you can create and manage tenants with respective license installed. Tenants provide runtime-isolation and upgrade flexibility among API Connect and traditional DataPower workloads without business disruption. In other words, the landlord and tenants can run any combination of release independent but supported firmware versions. Each tenant uses a tenant-specific firmware image that is available from IBM Fix Central.

Installation of landlord and tenant on physical box can be done in two modes.

Install Landlord firmware image :

1. Using CLI mode 

• Ssh to physical box : 
• Enter config mode : config
• copy image to DP's file system : copy source-address image:image-name
• Enter flash mode : fl
• Install image: boot image accept-license image-name

2. Using WebGUI mode

• Login to DataPower as Deafult domain.
• Search and navigate to System Control > Boot image

• Click on upload symbol
• Select the firmware image and click on Upload button

• Select I accept terms of license agreement checkbox and click on Submit button

Install Tenant firmware image on the landlord:

Install tenant firmware image on the physical box using the same above instructions differs only in installation command.

tenant-install accept-license tenant1 tenant-name

Once the tenant is installed, configure its properties on the landlord using CLI mode or WebGUI

Using WebGUI:

1. Search and navigate to Tenant configuration

2. Click on Tenant, enable administrative state, and set properties

• Telnet address : access tenant through Telnet  
• Telnet port
• SSH address : access tenant through SSH  
• SSH port
• Web management address : access tenant through WebGUI  
• Web management port
• XML Management address : access tenant through XML
•  XML Management port
• REST Management address : access tenant through ROMA
•  REST Management port

Using CLI: https://www.ibm.com/docs/en/datapower-gateway/10.0.1?topic=commands-tenant

Note: tenant shares same address as of landlord with different port number. 

SQL Data Source configuration on Tenant:

You would need to have respective license installed to use this feature. 

• ssh to Physical box : ssh ipaddress
• enter config mode : config
• show license 
  

To configure SQL on webgui:  

1. Login to Tenant using webGUI address as ‘Default’ domain.

2. Search and navigate to SQL Datasource

3. Click on Add button to create new object

4. Set object name and enable administrative state

4. Set database types out of 4 available types Db2, Microsoft SQL, Oracle and Sybase

5. Enter user name and configure password alias

1.    6. Click on Apply button to add password alias

2.    7. Select encryption method as none or TLS

1.    8. Configure encryption details if selected as TLS

2.    9. Click on ‘+’ to add or edit button to modify trust store

  10. Click on ‘+’ to add certificate and then click on Apply button

11. Click on Upload button to add certificate and then click on apply button

12. Click on Add button to add the certificate

    13. Click on apply button to add all the changed configurations to the SQL object and save the configurations

14. Additional parameters must be configured to get trace logs for further debugging

2.  15. Navigate to Advanced configurations and click on Add button to add additional parameters

    16. Configure name and value for the log store and click on Apply button

17. Once the configurations is done, is connection established successfully, object status is shown as up

18. To configure SQL object on CLI : https://www.ibm.com/docs/en/datapower-gateway/10.0.1?topic=commands-sql-source