Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Oracle Eloqua Reporting.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Oracle Eloqua Reporting, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Oracle Eloqua Reporting Stored Procedures
| Name | Description |
| CreateSchema | Generates a schema file that defines the structure of a specified Eloqua table or view. |
| GetOAuthAccessToken | Retrieves an OAuth access token for authenticating API requests to Eloqua. |
| GetOAuthAuthorizationURL | Returns the OAuth authorization URL used for user consent and application access in Eloqua integrations. |
| RefreshOAuthAccessToken | Renews the OAuth access token to maintain authenticated API sessions with Eloqua. |