Skip to main content Skip to complementary content

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.

Procedure

  1. Double-click the tFixedFlowInput component to open its Basic settings view on the Component tab.
  2. 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.

  3. 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.
  4. Double-click the tAzureStorageOutputTable component to open its Basic settings view on the Component tab
  5. 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.
  6. In the Table name field, enter the name of the table into which the employee data will be written, employee in this example.
  7. 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.
  8. Click Advanced settings to open its view.
  9. 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".

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here