Integrating MQ and DataBase with APIConnect
Here in this blog, we are going to explain the steps involved for IBM DataPower DataBase Connectivity and MQ connectivity and Integrating MQ and DataBase with APIConnect
Integrating MQ with APIConnect
Datapower MQ Queue Manager:
Follow the following steps to connect the MQ to DataPower.
Steps:
- Obtain the following details about the MQ from the concerned team
Let us configure it in MQ.
Details of QMGR
QMGR name : test2
Channel name : chl
LocalQueue name : lqm
Listener port : 1415
2. We should configure IBM MQ Queue MANAGER in DataPower.
3. Go to API Manager and develop an API as below.
Sample code:
4. Now test the API.
5. Now go to the local queue and browse the message
Integrating SQL datasource with API CONNECT
Datapower MQ Queue Manager:
Follow the following steps to connect the MQ to DataPower.
Steps:
- Let us configure SQL Data Source in DataPower. To configure Data Source we need below details. Obtain the following details about the DataBase from the concerned teamDetails of SQL Database.Database Type : OracleConnection User Name : systemConnection Password Alias : tigerOracle Identifier Type : SDI
Data Source ID : xe
Data Source Host : 192.168.x.xx
Data Source Port : 1521
- Now let us configure it in DataPower.
3. Now go to API Manager and develop an API as below.
Sample code:
4. Now test the API.