Writing data into an 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 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".