August 15, 2023

Retrieving data from the Azure Storage table – Docs for ESB 6.x

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.

  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 components-button_three_dot.png 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 Button_Plus.png under the
    Name mappings table to add one row and set the
    Schema column name cell with the value
    "Name" and the Entity property
    cell with the value "EmployeeName"
    to map the schema column name with the property name of each entity in the Azure

    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.

Document get from Talend
Thank you for watching.
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x