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

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 – 10.123.45.678
• Port number – 57498
• Username – datapoweruser
• Password – Ibm@12345
• Database name – testdb

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:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

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.

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.

Step 5:

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

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.

Reference:

http://www-03.ibm.com/software/products/en/datapower-gateway

http://db-engines.com/en/ranking