Overview
Configuration is provided for establishing connections with Azure Blob Storage service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this task, we will show you step-by-step how to create a connection to Azure Blob Storage REST API using COZYROC's REST Connection Manager.
In this task, we will show you step-by-step how to create a connection to Azure Blob Storage REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Azure Blob Storage. Set [account] to the desired storage account in the Server host parameter. Then click New in the Token File parameter to create a new token file.
Step 3: In Next Wizard specify your credential values for client_id, client_secret and tenant_ id for the parameters mention in the grid below. The version parameter can be kept as default.
Step 4: Provide Email Address. Then press 'Next' button.
Step 5: Provide Password. Then press 'Next' button.
Step 6: Save generated access token to file. Specify token protection password. Click OK.
Step 7. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Azure Blob Storage instance.
In this task, we will show you step-by-step how to create a connection to Azure Blob Storage REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Azure Blob Storage. Set [account] to the desired storage account in the Server host parameter.
Step 3. In the grid below specify your Storage Account and key and then press Test Connection.
Congratulations! You have now established a connection to your Azure Blob Storage instance.
In this guide, we will show how to store file from the Azure Blob Storage in your local machine using the COZYROC File Transfer Task component. For details regarding how to setup COZYROC File Transfer Task visit https://www.cozyroc.com/ssis/file-transfer-task
Step 1. In Control Flow canvas drag and drop the File Transfer Task component can be found in SSIS Toolbox.
Step 2. Open the File Transfer Task component and setup the required parameters Action, Local, Connection, Remote etc. A little overview about these parameters is mention below. For detail information please visit https://www.cozyroc.com/ssis/file-transfer-task
Action Specify the task action Recieve Files. This parameter has the options listed in the following table.
Local Select an existing File connection manager, or click
Connection Select the Azure Blob Storage Rest Connection Manager you have setup.
Remote Select remote path on the remote server.
Parameters like Remote can also be configured using SSIS variable.
Step 3. Execute your package to download the file locally.
Bravo! You have now learned how to download files from Azure Blob Storage using COZYROC File Transfer Task and Azure Blob Storage Rest Connection Manager.
In this guide, we will show how to upload file from your source to Azure Blob Storage using the COZYROC File Transfer Task component. For details regarding how to setup COZYROC File Transfer Task visit https://www.cozyroc.com/ssis/file-transfer-task
Step 1. In Control Flow canvas drag and drop the File Transfer Task component can be found in SSIS Toolbox.
Step 2. Open the File Transfer Task component and setup the required parameters Action, Local, Connection, Remote etc. A little overview about these parameters is mention below. For detail information please visit https://www.cozyroc.com/ssis/file-transfer-task
Action Specify the task action Send Files. This parameter has the options listed in the following table.
Local Select an existing File connection manager, or click
Connection Select the Azure Blob Storage Rest Connection Manager you have setup.
Remote Select remote path of th directory/container where you want to uplaod the file.
Step 3. Execute your package to upload the file
Bravo! You have now learned how to upload files from source to Azure Blob Storage using COZYROC File Transfer Task and Azure Blob Storage Rest Connection Manager.
Configuration
Base URL address: https://[account].blob.core.windows.net.
- OAuth
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}.The authentication has the following user-defined parameters:
- client_id: Required. Identifier of application that is associated with the authentication token.
- client_secret: Specify application client secret. Optional.
- tenant: Required. Specify tenant identifier.
- version:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}} -
x-ms-version:
{{=token.version}}
Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/authenticate-oauth.
- Shared Key
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- Storage Account: Required. Specify storage account.
- Key: Required. Specify key.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
{{=azurest.authorizationHeader (request, connection)}} -
x-ms-date:
{{=request.requestToSign.headers['x-ms-date']}} -
x-ms-version:
{{=request.requestToSign.headers['x-ms-version']}}
Documentation: https://learn.microsoft.com/en-us/azure/storage/common/storage-rest-api-auth.
Knowledge Base
Related scripts
What's New
- New: Included SAS authentication.
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.