Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Certinia.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Certinia, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Certinia Stored Procedures
| Name | Description |
| AbortJob | Terminates an active Salesforce job before completion. |
| CloseJob | Closes a Salesforce job to indicate it is complete and no longer accepting new data. |
| CloseJobV2 | Closes or aborts a Salesforce job based on its current state. |
| ConvertLead | Converts a Lead record into an Account, Contact, and optionally an Opportunity. |
| CreateBatch | Creates a batch job in Salesforce for bulk processing of records. |
| CreateCustomField | Adds a new custom field to a specified Salesforce object. |
| CreateJob | Initiates a new Salesforce job for processing bulk data operations. |
| CreateJobV2 | Creates a new job for asynchronous data processing in Salesforce, supporting bulk API operations. |
| CreateSchema | Generates a schema file for a specified Salesforce table, defining field structure and types. |
| DeleteJobV2 | Deletes a job in Salesforce, provided it has a status of UploadComplete, JobComplete, Aborted, or Failed. |
| DownloadAttachment | Downloads attachments related to a specific Salesforce entity. |
| DownloadContentDocument | Retrieves documents stored in Salesforce Content Library. |
| DownloadDocument | Downloads documents from Salesforce for offline access or external use. |
| GetBatch | Retrieves details about a specific Salesforce batch job. |
| GetBatchRecords | Fetches the original submitted records of a completed Salesforce batch job. |
| GetBatchResults | Fetches the results of a completed Salesforce batch job. |
| GetDeleted | Returns a list of records deleted within a specified timeframe for a given object. |
| GetJob | Retrieves details about a specific Salesforce job, including its status and associated records. |
| GetJobBatchIds | Fetches batch IDs for all batches associated with a specific Salesforce job. |
| GetJobInfoV2 | Retrieves details of a Salesforce job, including its processing status and metadata. |
| GetLimitInfo | Fetches API usage and limit details for the Salesforce organization. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Salesforce APIs. |
| GetOAuthAuthorizationUrl | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| GetUpdated | Returns a list of records updated within a specified timeframe for a given object. |
| GetUserInformation | Fetches personal details of the authenticated Salesforce user. |
| Merge | Combines up to three records of the same type into a single record while preserving relevant data. |
| MetadataDeploy | Deploys metadata components to a Salesforce organization, enabling changes to object structures and configurations. |
| MetadataDeployDetails | Retrieves additional details about a metadata deployment job in Salesforce. |
| MetadataRetrieve | Retrieves metadata components from a Salesforce organization for backup or modification. |
| QueryBatch | Executes a batch query in Salesforce, allowing large dataset retrieval in multiple chunks. |
| QueryParallelResultsV2 | Fetches the results locators in parallel for a query job once the job has completed processing. |
| QueryResultsV2 | Fetches results for a query job once the job has completed processing. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Salesforce resources without requiring reauthorization from the user. |
| Undelete | Restores records previously deleted and stored in Salesforce's Recycle Bin. |
| UploadAttachment | Uploads an attachment and associates it with a specific Salesforce record. |
| UploadContentDocument | Uploads a document to Salesforce Content and associates it with relevant records. |
| UploadDocument | Uploads a document to Salesforce, making it available in the document repository. |
| UploadJobDataV2 | Uploads a CSV file as job data for processing within Salesforce bulk operations. |