Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT operations with Amazon S3.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Amazon S3, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Amazon S3 Stored Procedures
| Name | Description |
| CopyObject | Copies an object from a source bucket to a destination bucket, preserving data and metadata unless otherwise specified. |
| CreateBucket | Creates a new S3 bucket in the configured AWS region. |
| DeleteBucket | Deletes an empty S3 bucket. Non-empty bucket attempts return an error. |
| DeleteObject | Removes an object from a specified bucket, permanently deleting its data and associated metadata. |
| DownloadObjects | Downloads objects from a specified bucket to a local environment or external application. |
| GeneratePresignedURL | Creates a presigned URL granting temporary, secure access to an object without requiring AWS credentials. |
| GetCallerIdentity | Returns details about the IAM identity used to authenticate the request, including the AWS account ID, user/role ID, and ARN. |
| GetOAuthAccessToken | Retrieves an OAuth access token for authenticating API requests to Amazon S3. |
| GetOAuthAuthorizationURL | Generates an authorization URL for user consent, required when integrating S3 access into web applications via OAuth. |
| GetObjectACL | Retrieves the access control list (ACL) for an object. |
| MoveObject | Transfers an object from one bucket to another by combining copy and delete operations. |
| PutBucketAcl | Applies or updates an ACL on a bucket, setting permissions for specific users, groups, or the public. |
| PutObjectAcl | Applies or updates an ACL on an object, customizing access rights at the object level. |
| RefreshOAuthAccessToken | Refreshes an expired or soon-to-expire OAuth access token to maintain API authentication. |
| UploadObject | Uploads a new object to a bucket in a single operation, including optional metadata and storage class settings. |