IBM App connect Integrates with Multiple Databases
In this blog, we will learn about IBM App Connect Integrates with multiple databases
IBM App Connect introduces new features in the latest version 12.0.10.0 different data bases (PostgreSQL, IBM Db2 and MS SQL) integration with IBM App Connect. These two types of databases integrate with IBM App Connect. To integrate the Databases with IBM App Connect you can follow below steps.
SQL Databases:
IBM Db2, IBM Db2 Warehouse on cloud, IBM Db2 on cloud, Microsoft SQL server, MySQL, PostgreSQL, Oracle Database, Amazon RDS (Relational Database Service), Microsoft Azure SQL Database
NO SQL Databases:
MongoDB, CouchDB, Cloudant
- IBM DB2 have own relational database management system.
- MSSQL server database management system developed by Microsoft.
- MySQL and PostgreSQL are an open-source object- relational database management system
- Oracle database is widely used relational database management system developed by oracle.
- Amazon RDS is a web service that makes it easier to set up, operate and scale a relational database in the cloud.
- Microsoft Azure SQL Database is a cloud-based database service provided by Microsoft Azure.
Steps to Configure the PostgreSQL with IBM APP Connect:
- Download the PostgreSQL server along with the pg Admin tools.
- Create one DSN with a username, password, port and DB Name in the ODBC configuration.
- Whatever the DSN name used at the application level (or particular message flow level),
- To define the actions, you want to perform with PostgreSQL. This App Connect Involve query data, inserting records, updating data and other database operations.
- To map the data between the source and PostgreSQL. The data being passed between the components of your flow is properly transformed to match the except format.
After integration is established, you can perform CRUD (Create Read Update Delete) operations using the PostgreSQL database. The above diagram shows how to fetch the data from PostgreSQL. Once integration is completed deploy it to the appropriate environment.
