Friday, August 9, 2019

Talend ETL - How to load any files into Azure Tables Storage

Here is an example of using Talend components to connect to a Microsoft Azure storage account that gives you access to Azure storage table service, write some yearly sales data into an Azure storage table.


Process flow -
•Creating Azure Storage Connection - Connecting to an Azure storage account
•Creating File Delimited Connection - Connecting to Raw Data File
•Showing Data of Raw Data File
•Load Data into Azure Storage Tables

List of Talend components -
1.tAzureStorageConnection - to connecting to an Azure storage account
2.tInputFileDelimited – Pull the data from the Raw data file and pass to another component
3.tLogRow – allows us to write data, that is flowing through our Job (rows), to the console
4.tAzureStorageOutputTable  - Performs the defined action on a given Azure storage table and inserts, replaces, merges or deletes entities in the table based on the incoming data from the preceding component
a.Partition Key -Select the schema column that holds the partition key value from the drop-down list.
b.Row Key - Select the schema column that holds the row key value from the drop-down list.
Microsot Azure Storage Explorer - To connect with Azure Storage Account and go through all the services over there.

To Learn more, please visit our blog at - 
http://www.sql-datatools.com

To Learn more, please visit our YouTube channel at - 
http://www.youtube.com/c/Sql-datatools





3 comments:

  1. Yet, as an entryway is shared by two compared rooms, we will think about that each room oversees just the entryways Down and Right that it contains (in light of the fact that they are at the down and right sides of the cells, in our drawings). ExcelR Data Science Courses

    ReplyDelete
  2. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete
  3. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.
    python course training in Guwahati

    ReplyDelete

Popular Posts