ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Azure Data Lake Storage の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAzure Data Lake Storage から関連するレスポンスデータを返します。
CData Excel Add-In 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. |