Open Data Services includes a built-in remote stored procedure called sp_sqlexec that enables users to retrieve data from an external data source by making a remote stored procedure call to the Open Data Services server application. The user specifies the language request as an sp_sqlexec string argument.
When Open Data Services receives an sp_sqlexec procedure, Open Data Services first converts the contents of the string into a language statement and then directs the statement to the Open Data Services language event handler. To the language event handler, the request appears as a standard language request. The language event handler can pass the language statement directly to an external data source and retrieve the results. To the client, results are returned as remote stored procedure results.