Odata for data export from blob storage

Valentin Feulner 21 Reputation points
2021-04-12T07:15:11.603+00:00

Me and my team are creating forecasts with ML Services/Databricks and then store the forecasts/data in the azure blob storage. Then we want to export/query the data in the blob storage with odata and import them in the hana database of our customer. The question is, does blob storage support odata protocols for data export & how can we use them? Do we need to import the data in data-factory?

I have googled for about 5 hours and could not find a promising solution. I would be very thankful for any advice!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,648 questions
0 comments
Accepted answer
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-04-16T16:36:55.75+00:00

    Hello @Valentin Feulner ,

    Thanks for clarifying the ask . As mentioned by you , the first time when you use the ODATA to read the data and dump the records , ODATA is acting as source . But when want to write back the data using ODATA , it will be treated as a sink . Unfortunately ODATA is not supported as a sink at this time . Please read here .

    87858-image.png

    This product feature you are looking is not supported. May I request you to please log the same here .
    Product group does monitor the request and they can plan for the implementation in future .Once you log the feature request you will also be notified on the status of the request . Please do share the url of the logged issue here so that other community members are aware of the same .We expect you to keep using this forum and motivate others to do the same . You can always help other community members by answering to their queries .

    Thanks
    Himanshu

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-04-12T16:15:06.417+00:00

    Hello @Valentin Feulner ,

    Thanks for the ask and using the Microsoft Q&A platform .
    You have two question and let me answer the second one . Using Azure dafactory you can import the data from blob to HANA .I do not have a HANA instance but I am sure that you will have to install an IR to achieve this .
    Please do read more on the same here .

    Out of curiosity , can you please elaborate as to why you want to use ODATA ? I am just trying to understand more on the ask itself .

    @SumanthMarigowda : Can you please help in answering with the first ask ?

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    1 person found this answer helpful.
    0 comments
  2. Valentin Feulner 21 Reputation points
    2021-04-14T07:34:08.777+00:00

    The task itself is that we are using customer data from their database and import them with odata in data factory. After the ETL Processes we want to analyze and do forecasts with data. Then the data is stored in blobstorage. To load the data back to the customer data base, we want to use Odata, and thats where i am stuck currently, if this is possible and how is it applicable.

    Why to use Odata? Since I am a very new team member I cannot really say why my collegues want to use that protocol
    @HimanshuSinha-msft

    0 comments