File Location Azure Blob Storage Connection via HTTPS
Mar 13, 2017 at 05:07 PM|510 Views
Hi,
I am extracting Data from SAP Systems into the Azure Blob Storage using SAP Data Services. From what I could find out about the protocol being used by Data Service to upload the Data into the blob storage it establishes a connection via Microsoft-HTTPAPI/2.0
But we require a HTTPS-Connection.
Is there any way to change the connection type of the Azure Cloud Storage Protocol?
In BODS you can create a file location which uses the azure cloud storage protocol.
You need
Account Name: Can be found in Azure
Account Shared Key: Can be found in Azure
Local Directory: Some folder on you Data Services Server or on a network drive. BODS will transfer the file to the local directory and upload it afterwards to the blob storage.
Container: Container in your blob storage. This can be created in Azure or BODS will it create during the batch job.
This file location can be associated to a flat file format
The flat file format can be used in every batch job.
First BODS copies the file to the local directory. When this is done, it will be uploaded. So BODS does it sequentially.
You should consider a script which deletes the file after a succesfull upload. Otherwise you local storage will be full sooner or later.
Since BODS is not able to write into Append Blobs, you are not able to update the data in the blob. Except you overwrite the file when you use the same name. If you do a full load every time, it would be an option.
Otherwise I recommend using a variable for the filename with a timestamp. (you can see it in the screenshot above).
Add comment