question

ValentinFeulner-4381 avatar image
0 Votes"
ValentinFeulner-4381 asked ValentinFeulner-4381 commented

Odata for data export from blob storage

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ValentinFeulner-4381 commented

Hello @ValentinFeulner-4381 ,

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




image.png (17.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ValentinFeulner-4381,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello @ValentinFeulner-4381,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Thank you for your Help, due to your response my issue is solved.

0 Votes 0 ·
HimanshuSinha-MSFT avatar image
1 Vote"
HimanshuSinha-MSFT answered

Hello @ValentinFeulner-4381 ,

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 .

@SumanthBMarigowda : 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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ValentinFeulner-4381 avatar image
0 Votes"
ValentinFeulner-4381 answered ValentinFeulner-4381 edited

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.