Retrieving data from the Azure Storage table - 6.4

Azure Storage Table

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Cloud storages > Azure components > Azure Storage Table components
Data Quality and Preparation > Third-party systems > Cloud storages > Azure components > Azure Storage Table components
Design and Development > Third-party systems > Cloud storages > Azure components > Azure Storage Table components
EnrichPlatform
Talend Studio
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.