ODBC access to external services
First Claim
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;
creating the ODBC connection;
receiving a SQL (Structured Query Language) query that is associated with the ODBC connection and includes information to be provided to the external service;
translating the received SQL query into an HTTP (Hyper Text Transfer Protocol) request to be provided to the external service, wherein translating the SQL query into the HTTP request comprises identifying information in one or more predicates included in a WHERE clause of the SQL query, wherein each of the one or more predicates includes a predefined column of a predefined table, an operator, and a request parameter value, each predefined column in the predefined table corresponds to either an HTTP request parameter or an HTTP response parameter, and each column included in the SQL query corresponds to a predefined column included in the predefined table;
sending the translated HTTP request to the external service;
receiving an HTTP response from the external service in response to the HTTP request;
translating the received HTTP response into a query result set table; and
providing the query result set table in response to the received SQL query.
3 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
17 Claims
-
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; creating the ODBC connection; receiving a SQL (Structured Query Language) query that is associated with the ODBC connection and includes information to be provided to the external service; translating the received SQL query into an HTTP (Hyper Text Transfer Protocol) request to be provided to the external service, wherein translating the SQL query into the HTTP request comprises identifying information in one or more predicates included in a WHERE clause of the SQL query, wherein each of the one or more predicates includes a predefined column of a predefined table, an operator, and a request parameter value, each predefined column in the predefined table corresponds to either an HTTP request parameter or an HTTP response parameter, and each column included in the SQL query corresponds to a predefined column included in the predefined table; sending the translated HTTP request to the external service; receiving an HTTP response from the external service in response to the HTTP request; translating the received HTTP response into a query result set table; and providing the query result set table in response to the received SQL query. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system comprising:
-
one or more computers; and a non-transitory computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations comprising; identifying a request for an ODBC (Open DataBase Connectivity) connection, the request identifying the external service; creating the ODBC connection; receiving a SQL (Structured Query Language) query that is associated with the ODBC connection and includes information to be provided to the external service; translating the received SQL query into an HTTP (Hyper Text Transfer Protocol) request to be provided to the external service, wherein translating the SQL query into the HTTP request comprises identifying information in one or more predicates included in a WHERE clause of the SQL query, wherein each of the one or more predicates includes a predefined column of a predefined table, an operator, and a request parameter value, each predefined column in the predefined table corresponds to either an HTTP request parameter or an HTTP response parameter, and each column included in the SQL query corresponds to a predefined column included in the predefined table; sending the translated HTTP request to the external service; receiving an HTTP response from the external service in response to the HTTP request; translating the received HTTP response into a query result set table; and providing the query result set table in response to the received SQL query. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A computer program product encoded on a non-transitory storage medium, the product comprising non-transitory, computer readable instructions for causing one or more processors to perform operations comprising:
-
identifying a request for an ODBC (Open DataBase Connectivity) connection, the request identifying the external service; creating the ODBC connection; receiving a SQL (Structured Query Language) query that is associated with the ODBC connection and includes information to be provided to the external service; translating the received SQL query into an HTTP (Hyper Text Transfer Protocol) request to be provided to the external service, wherein translating the SQL query into the HTTP request comprises identifying information in one or more predicates included in a WHERE clause of the SQL query, wherein each of the one or more predicates includes a predefined column of a predefined table, an operator, and a request parameter value, each predefined column in the predefined table corresponds to either an HTTP request parameter or an HTTP response parameter, and each column included in the column list included in the SQL query corresponds to a predefined column included in the predefined table; sending the translated HTTP request to the external service; receiving an HTTP response from the external service in response to the HTTP request; translating the received HTTP response into a query result set table; and providing the query result set table in response to the received SQL query. - View Dependent Claims (14, 15, 16, 17)
-
Specification