Skip to main content


Configure SQL data source in IBM Datapower Gateway

IBM DataPower Gateway is a purpose-built security and integration platform for mobile, cloud, API, SOA and B2B workloads. The current business model for nearly all industries relies mostly on data. The database has become a very important component of an enterprise’s IT structure providing more sophisticated and flexible options than the databases available a decade before. This digital transformation has placed demands on Enterprise Service Bus (ESB) products to connect with databases at higher speeds with the options of supporting multiple types of databases.

According to a report generated in September 2016, Oracle, My SQL, Microsoft SQL server and DB2 are the most popular Relational DBMS used all over the world. Considering the wide use of these databases, IBM Datapower gateway ( Firmware edition V7.5) is designed to connect to most of the popular databases and they are listed below:

  • Oracle
  • Sybase
  • DB2
  • Microsoft SQL Server
  • IMS

Database usage report

The configuration of a data source to connect to a database through IBM Datapower gateway is achieved through a component called SQL data source. This article will provide the steps to configure a SQL data source in Datapower gateway. The database used for this illustration is Microsoft SQL server 2014 and the IBM Datapower Gateway firmware version is 7.5.

Step 1:

Obtain the following details about the database from the concern team.

  • Database Type
  • IP address / Hostname of the server in which the database is configured
  • Port number in which the database is configured
  • Username
  • Password
  • Database name

Step 2:

In this example the database used is Microsoft SQL server and the sample values for the above mentioned parameters will be as follows:

  • Database Type – Microsoft SQL server
  • IP address –
  • Port number – 57498
  • Username – datapoweruser
  • Password – Ibm@12345
  • Database name – testdb

MS SQL Server login

MS SQL Server test database

Note: The user type used for authentication should be SQL server authentication. Please don’t use a user account with Window’s authentication.

Step 3:

Login to the Datapower gateway physical or virtual appliance and navigate to the Password map alias component under Objects > Configuration Management setting. Create a password alias configuration with the password of the user account which will be used in the SQL data source object.

Password Map alias

Datapower password map alias

Once configured, click Apply and save the configuration.

Step 4:

Navigate to the SQL data source object available under network > Other setting to create a new SQL data source object.

SQL data source datapower

Step 5:

Create a new SQL data source and configure the details with the details gathered about the database.

Datapower SQL data source

Once configured, click Apply  and save the configuration.

Step 6:

Enable debug level logging to verify if the configuration is correct. In case any of the detail is incorrect or a network connection is blocked, the SQL data source object will be in a pending status.

Datapower debug logs



Thoughts on “Configure SQL data source in IBM Datapower Gateway”

  1. This post should be updated to include a sample SQL statement and instructions on how to actually pull data from a DB through the Datapower appliance. Currently the post only includes the configuration information. As frustrating as Datapower can be, this portion of the GUI is very user friendly. The next steps are where people run into trouble.

  2. Hi Karthik, I have a requirement to use an AD service account to connect to SQL data source which will use windoes authentication.
    Kindly suggest how to use SQL data source object to do windows authentication.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Karthik Selvaraj

More from this Author

Follow Us