Microsoft Azure Blob Storage V2 Connector > Mappings and Mapping Tasks with Microsoft Azure Blob Storage V2 > Microsoft Azure Blob Storage V2 Targets in Mappings
  

Microsoft Azure Blob Storage V2 Targets in Mappings

In a mapping, you can configure a Target transformation to represent a Microsoft Azure Blob Storage V2 object.
The following table describes the Microsoft Azure Blob Storage V2 target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Target type. Select one of the following target types:
  • - Single Object.
  • - Parameter. Select Parameter to define the target type when you configure the task.
Object
The Microsoft Azure Blob Storage V2 blob that you want to use as a target object.
Formatting Options
Opens the Formatting Options dialog box to define the format of the file.
Configure the following format options:
  • - Delimiter: Delimiter character. You can configure other parameters such as comma, tab, colon, semicolon, or others.
  • - Text Qualifier: Character to qualify text. You can configure other parameters such as single quote or double quote.
  • - Escape: Escape character.
Note: The formatting options are ignored if you select Create Table.
Operation
Target operation. Select Insert. You can only insert data to aMicrosoft Azure Blob Storage V2 target.
Number of concurrent connections to Blob Store
The number of concurrent connections to Blob Store to upload files. Default is 4.
Blob Name Override
Overrides the default file name. You must use this property when you want to write compressed blob files to Microsoft Azure Blob Storage.
Blob Container Override
Overrides the default container name.
Note: When you create a new target at the run time and select the blob container override property, the Secure Agent generates an empty header file in the container specified in the connection.
Header in the first row of Blob
Creates a header in the target file. Header will not be created in the target file if this option is not selected.
Compress newly created Blob
Compresses the newly created blob when set to True.
Write Strategy
Appends block to a blob, when you select append blob.
Blob Type
Writes data to a block blob or an append blob.
Success File Directory
NA
Error File Directory
NA

Specifying a Target

You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the agent creates the target when you run the task.
To specify the target properties, follow these steps:
    1. Select the Target transformation in the mapping.
    2. On the Incoming Fields tab, configure field rules to specify the fields to include in the target.
    3. To specify the target, click the Target tab.
    4. Select the target connection.
    5. For the target type, choose Single Object or Parameter.
    6. Specify the target object or parameter.
    7. Click Formatting Options if you want to configure the formatting options for the file, and click OK.
    8. Click Select and choose a target object. You can select an existing target object or create a new target object at run time and specify the object name.
    9. Specify Advanced properties for the target, if needed.

Target Time Stamps

When you create a target at run time, you can append time stamp information to the file name to show when the file is created.
When you specify the file name for the target file, include special characters based on Linux STRFTIME function formats that the mapping task uses to include time stamp information in the file name. The time stamp is based on the organization's time zone.
The following table describes some common STRFTIME function formats that you might use in a mapping or mapping task:
Special Character
Description
%d
Day as a two-decimal number, with a range of 01-31.
%m
Month as a two-decimal number, with a range of 01-12.
%y
Year as a two-decimal number without the century, with range of 00-99.
%Y
Year including the century, for example 2015.
%T
Time in 24-hour notation, equivalent to %H:%:M:%S.
%H
Hour in 24-hour clock notation, with a range of 00-24.
%l
Hour in 12-hour clock notation, with a range of 01-12.
%M
Minute as a decimal, with a range of 00-59.
%S
Second as a decimal, with a range of 00-60.
%p
Either AM or PM.