ODBC ACCESS TO EXTERNAL SERVICES

摘要

The present disclosure involves systems, software, and computer implemented methods for providing access to an external service using a SQL query. One example method includes identifying a request for an ODBC (Open DataBase Connectivity) connection. The request identifies the external service and the identified request is associated with a SQL (Structured Query Language) query. The ODBC connection is created. An HTTP (Hyper Text Transfer Protocol) request to be provided to the external service is generated. The HTTP request is generated based on the SQL query. The generated HTTP request is sent to the external service. An HTTP response is received from the external service in response to the HTTP request. A query result set table is populated based on the received HTTP response.

主权项

1. A method of providing access to an external service, comprising:
identifying a request for an ODBC (Open DataBase Connectivity) connection, the request identifying the external service and wherein the identified request is associated with a SQL (Structured Query Language) query; creating the ODBC connection; generating an HTTP (Hyper Text Transfer Protocol) request to be provided to the external service, wherein the HTTP request is generated based on the SQL query; sending the generated HTTP request to the external service; receiving an HTTP response from the external service in response to the HTTP request; and populating a query result set table based on the received HTTP response.