Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components for Oracle Eloqua Reporting Stored Procedures
| Name | Description |
| CreateSchema | Generates a schema file defining the structure of a specified Eloqua table or view. |
| GetOAuthAccessToken | Retrieves an OAuth access token for secure API calls to Eloqua. |
| GetOAuthAuthorizationURL | Returns the OAuth authorization URL required to obtain user consent for Eloqua applications. |
| RefreshOAuthAccessToken | Renews the OAuth token to extend authentication sessions with Eloqua. |