Microsoft Azure App Service API Apps for connecting to IBM systems


Microsoft Azure App Service enables enterprise developers to efficiently build web, logic and mobile solutions for a cloud first and mobile first world. For more information, read the blog post at http://blogs.microsoft.com/blog/2015/03/24/announcing-the-availability-of-azure-app-service.

Microsoft HIS Team has released into the public preview three API apps for integrating App Service with line-of-business systems that are based on existing IBM DB2, Informix, and MQ servers.


Microsoft Connector for DB2 is an API app for connecting applications through Azure App Service to resources stored in an IBM DB2 database.

  • Connector supports a set of connector-specific RESTful Web API operations and industry-standard Open Data Protocol (OData) operations that are accessed with HTTP verbs to process common parameterized and non-parameterized Structured Query Language database commands.
    • OData Web API operations (SELECT, INSERT, UPDATE, DELETE, MERGE, CALL).
    • Advanced Web API operations for Bulk (INSERT, UPDATE, DELETE), Custom (SELECT, INSERT, UPDATE, DELETE), Cursor (SELECT, SELECT UPDATE, SELECT DELETE), and Composite (custom).
    • Administration Web API operations (test connection, save metadata, view metadata, other).
  • Connector is compatible with logic app triggers (SELECT) and actions (SELECT, INSERT, UPDATE, DELETE, CALL).
  • Connector includes a Microsoft Client for DRDA supporting industry-standard Distributed Relational Database protocol and formats, defined for use by DB2 clients and servers, to connect to remote DB2 server computers across a TCP/IP network connection. Client supports DB2 for z/OS V11 and V10; DB2 for i V7R2 and V7R1; DB2 for Linux, UNIX and Windows V10.5 and V10.
  • Connector supports Azure hybrid connections to on-premises DB2 servers using the Azure Service Bus Relay.
  • Connector supports Swagger representation of Connector RESTful APIs, making it easy to understand the command syntax, parameters, and examples for using Connector operations.

 
Microsoft Connector for Informix is an API app for connecting applications through Azure App Service to resources stored in an IBM Informix database.

  • Connector supports a set of connector-specific RESTful Web API operations and industry-standard Open Data Protocol (OData) operations that are accessed with HTTP verbs to process common parameterized and non-parameterized Structured Query Language database commands.
    • OData Web API operations (SELECT, INSERT, UPDATE, DELETE, MERGE, CALL).
    • Advanced Web API operations for Bulk (INSERT, UPDATE, DELETE), Custom (SELECT, INSERT, UPDATE, DELETE), Cursor (SELECT, SELECT UPDATE, SELECT DELETE), and Composite (custom).
    • Administration Web API operations (test connection, save metadata, view metadata, other).
  • Connector is compatible with logic app triggers (SELECT) and actions (SELECT, INSERT, UPDATE, DELETE, CALL).
  • Connector includes a Microsoft Client for DRDA supporting industry-standard Distributed Relational Database protocol and formats, defined for use by Informix clients and servers, to connect to remote Informix server computers across a TCP/IP network connection. Client supports Informix for Linux, UNIX and Windows V11.5 and V12.1.
  • Connector supports Azure hybrid connections to on-premises Informix servers using the Azure Service Bus Relay.
  • Connector supports Swagger representation of Connector RESTful APIs, making it easy to understand the command syntax, parameters, and examples for using Connector operations.

 
Microsoft Connector for MQ is an API app for connecting applications through Azure App Service to messages stored in an IBM WebSphere MQ server.

  • Connector supports a set of connector-specific Web API operations and subset of industry-standard Open Data Protocol (OData) operations that are accessed with HTTP GET and POST verbs.
    • Connector Web API messaging operations include processing MQ PUT and GET commands.
    • Connector industry-standard OData RESTful APIs include processing MQ GET commands.
  • Connector includes a Microsoft Client for MQ for connecting to remote IBM WebSphere MQ servers across a TCP/IP network connection. Client supports IBM WebSphere MQ V7.5 and V8.0.
  • Connector supports Swagger representation of Connector RESTful APIs, making it easy to understand the command syntax, parameters, and examples for using Connector Web and OData APIs.

Today, you can evaluate the new technologies and tools using the App Service Public Preview. Visit https://portal.azure.com to get started.

Host Integration Server Team

Comments (2)

  1. Dan Rusu says:

    Where I can find more info regarding migration from "on premises" to azure for an informix database app?

    drmeco@gmail.com

    Tks

  2. Scott L. says:

    I was wondering if DB2 for i  V6R1 is also supported?

    Thanks,

    -Scott

Skip to main content