Writing data into an Azure Storage table

Configure the tFixedFlowInput component and the
tAzureStorageOutputTable component to write the employee data
into an Azure Storage table.

Double-click the tFixedFlowInput component to open its
Basic settings view on the
Component tab.
Click next to Edit schema to open the
schema dialog box and define the schema by adding six columns:
Id, Name,
Site, and Job of String type,
Date of Date type, and Salary
of Double type. Then click OK to save the changes and
accept the propagation prompted by the pop-up dialog box.

Note that in this example, the Site and
Id columns are used to feed the values of the
PartitionKey and RowKey
system properties of each entity and they should be of String type, and the
Name column is used to feed the value of the
EmployeeName property of each entity.
In the Mode area, select Use Inline
Content(delimited file) and in the
Content field displayed, enter the employee data that
will be written into the Azure Storage table.
Double-click the tAzureStorageOutputTable component to
open its Basic settings view on the
Component tab
From the connection component drop-down list, select the component whose
connection details will be used to set up the connection to the Azure Storage
service, tAzureStorageConnection_1 in this example.
In the Table name field, enter the name of the table
into which the employee data will be written, employee in
this example.
From the Action on table drop-down list, select the
operation to be performed on the specified table, Drop table if exist and create in this example.
Click Advanced settings to open its view.
Click under the
Name mappings table to add three rows and map the
schema column name with the property name of each entity in the Azure table. In
this example,
- the Site column is used to feed the value of the
  PartitionKey system property, in the first
  row you need to set the Schema column name cell
  with the value "Site" and the Entity
  property name cell with the value
  "PartitionKey".
- the Id column is used to feed the value of the
  RowKey system property, in the second row you
  need to set the Schema column name cell with the
  value "Id" and the Entity property
  name cell with the value
  "RowKey".
- the Name column is used to feed the value of the
  EmployeeName property, in the third row you
  need to set the Schema column name cell with the
  value "Name" and the Entity property
  name cell with the value
  "EmployeeName".