ストアドプロシージャ

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

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

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


Name	Description
CopyFile	Copy a file from a source to a destination.
CreateFile	Create a file. Path is required for a successful operation.
CreateFileSystem	Create a filesystem by specifying the name.
CreateFolder	Create a folder. Path is required for a successful operation.
DeleteFileSystem	Delete a filesystem. The name of the filesystem for a successful operation.
DeleteObject	Delete a file or a folder. Path is required for a successful operation.
DownloadFile	Download a file. Path and DownloadPath are required for a successful operation.
GetFileSystemProperties	Get the properties of a filesystem. The name of the filesystem is required for a successful operation.
GetOAuthAccessToken	Gets the OAuth access token from SharePoint.
GetOAuthAuthorizationURL	Gets the SharePoint authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to SharePoint.
LeaseBlob	The LeaseBlob operation creates and manages a lock on a blob for write and delete operations.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with SharePoint.
RenameObject	Rename a file or a directory. Path and RenameTo are required for a successful operation.
SetFileSystemProperties	Set the properties for a filesystem. The name of the filesystem is required for a successful operation.
UploadFile	Upload a File. Path and FilePath are required for a successful operation.