Cloud-based application communication with hierarchical databases
A gateway may allow for a cloud-based application to connect to a hierarchical type database. The gateway may identify a connection route between a cloud instance and the hierarchical type database. The gateway may translate a SQL call from the cloud-based application to a DL/I call to access data on the hierarchical type database.
1. A method comprising:
receiving, by a computer-based system, a structured query language (SQL) call from a cloud-based application;
generating, by the computer-based system, a virtual server instance to handle the SQL call;
identifying, by a gateway executed in the computer-based system and based at least in part on the SQL call, an information management system (IMS) database;
establishing, by the gateway, a routing path to the virtual server instance;
translating, by the gateway, the SQL call to a (DL/I) call;
transmitting, by the gateway, the DL/I call to the IMS database;
receiving, by the gateway, a response from the IMS database; and
transmitting, by the gateway, the response to the virtual server instance using the routing path.
2. The method of claim 1 , wherein the virtual server instance transmits the response to the cloud-based application.
3. The method of claim 1 , wherein the gateway comprises IMS Connect.
4. The method of claim 3 , wherein the IMS Connect is exposed to the cloud-based application as an API as a service.
5. The method of claim 1 , further comprising referring, by the gateway, to a mapping table to identify the IMS database.
6. The method of claim 1 , wherein the SQL call is received in a data request comprising at least one of: a get request, a put request, a post request, or a delete request.
7. The method of claim 1 , wherein the virtual server instance is running on a cloud network.
8. A system comprising:
a processor; and
a tangible, non-transitory memory configured to communicate with the processor, the tangible, non-transitory memory having instructions stored thereon that, in response to execution by the processor, cause the processor to perform operations comprising:
receiving, by the processor, a structured query language (SQL) call from a cloud-based application;
generating, by the processor, a virtual server instance to handle the SQL call;
identifying, by a gateway executed on the processor and based at least in part on the SQL call, an information management system (IMS) database;
establishing, by the gateway, a routing path to the virtual server instance;
translating, by the gateway, the SQL call to a (DL/I) call;
transmitting, by the gateway, the DL/I call to the IMS database;
receiving, by the gateway, a response from the IMS database; and
transmitting, by the gateway, the response to the virtual server instance using the routing path.
9. The system of claim 8 , wherein the virtual server instance transmits the response to the cloud-based application.
10. The system of claim 8 , wherein the gateway comprises IMS Connect.
11. The system of claim 10 , wherein the IMS Connect is exposed to the cloud-based application as an API as a service.
12. The system of claim 8 , the operations further comprising referring, by the gateway, to a mapping table to identify the IMS database.
13. The system of claim 8 , wherein the SQL call is received in a data request comprising at least one of: a get request, a put request, a post request, or a delete request.
14. The system of claim 8 , wherein the virtual server instance is running on a cloud network.
15. An article of manufacture including a non-transitory, tangible computer readable storage medium having instructions stored thereon that, in response to execution by a computer-based system, cause the computer-based system to perform operations comprising:
receiving, by the computer-based system, a structured query language (SQL) call from a cloud-based application;
generating, by the computer-based system, a virtual server instance to handle the SQL call;
identifying, by a gateway executed in the computer-based system and based at least in part on the SQL call, an information management system (IMS) database;
establishing, by the gateway, a routing path to the virtual server instance;
translating, by the gateway, the SQL call to a (DL/I) call;
transmitting, by the gateway, the DL/I call to the IMS database;
receiving, by the gateway, a response from the IMS database; and
transmitting, by the gateway, the response to the virtual server instance using the routing path.
16. The article of claim 15 , wherein the virtual server instance transmits the response to the cloud-based application.
17. The article of claim 15 , wherein the gateway comprises IMS Connect.
18. The article of claim 17 , wherein the IMS Connect is exposed to the cloud-based application as an API as a service.
19. The article of claim 15 , further comprising referring, by the gateway, to a mapping table to identify the IMS database.
20. The article of claim 15 , wherein the SQL call is received in a data request comprising at least one of: a get request, a put request, a post request, or a delete request.