ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Azure Data Lake Storage の単純なSELECT 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAzure Data Lake Storage から関連するレスポンスデータを返します。

CData SSIS Components for Azure Data Lake Storage ストアドプロシージャ


Name	Description
CopyFile	Copies a file from one location to another within Azure Data Lake Storage, preserving the original file while creating a duplicate at the target path.
CreateFile	Creates a new file in a specified filesystem and path, enabling you to upload or initialize content directly in Azure Data Lake Storage.
CreateFileSystem	Creates a new filesystem (container) in Azure Data Lake Storage by specifying its name, providing a dedicated namespace for organizing files and folders.
CreateFolder	Creates a folder within a filesystem at the specified path, allowing you to structure and organize files into logical directories.
DeleteFileSystem	Deletes an existing Azure Data Lake Storage filesystem by name, permanently removing all the folders and files it contains.
DeleteObject	Deletes a specified file or folder from Azure Data Lake Storage, with the path indicating the exact object to remove.
DownloadFile	Downloads a file from Azure Data Lake Storage to a specified local path, requiring both the file path in storage and the destination download path.
GetFileSystemProperties	Retrieves metadata and configuration properties of a given filesystem, such as quota or access settings, by specifying its name.
GetOAuthAccessToken	Retrieves an OAuth access token for authenticating against Azure Data Lake Storage, enabling secure access to resources.
GetOAuthAuthorizationURL	Generates the OAuth authorization URL for Azure Data Lake Storage. Use this link in a browser to grant consent and obtain an access token for secure connections.
LeaseBlob	Creates and manages a lease on a blob, providing a lock that controls write and delete access to prevent conflicting operations.
RefreshOAuthAccessToken.rsb	Usage information for the operation RefreshOAuthAccessToken.rsb.
RenameObject	Renames a file or folder in Azure Data Lake Storage by specifying the current path and the new target name.
SetFileSystemProperties	Updates or configures filesystem properties, such as access policies or storage options, by specifying the filesystem name.
UploadFile	Uploads a file from a local system to Azure Data Lake Storage by providing the target path and the local file path.