Skip to main content Skip to complementary content

Retrieving data from the Azure Storage table

Configure the tAzureStorageInputTable component and the tLogRow component to retrieve the employee data from the Azure Storage table.

Procedure

  1. Double-click the tAzureStorageInputTable component to open its Basic settings view.
  2. 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.
  3. In the Table name field, enter the name of the table from which the employee data will be retrieved, employee in this example.
  4. Click next to Edit schema to open the schema dialog box.

    Note that the schema has already been predefined with two read-only columns RowKey and PartitionKey of String type, and another column Timestamp of Date type. The RowKey and PartitionKey columns correspond to the Id and Site columns of the tAzureStorageOutputTable schema.

  5. Define the schema by adding another four columns that hold other employee data, Name 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.
  6. Click Advanced settings to open its view.
  7. Click under the Name mappings table to add one row and set the Schema column name cell with the value "Name" and the Entity property name cell with the value "EmployeeName" to map the schema column name with the property name of each entity in the Azure table.

    Note that for the tAzureStorageInputTable component, the PartitionKey and RowKey columns have already been added automatically to the schema and you do not need to specify the mapping relationship for them.

  8. Double-click the tLogRow component to open its Basic settings view and in the Mode area, select Table (print values in cells of a table) for a better display of the result.

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