using SAP HANA as sink in ADF

reddy reddy 1 Reputation point
2020-11-06T04:19:35.853+00:00

Hi,
Can we use sap hana as a sink in adf pipeline. My requirement is to load some files from blob storage to sap hana tables. If we can use, can we auto create tables in hana from adf pipelines before loading files?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,679 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,736 Reputation points
    2020-11-06T04:40:15.227+00:00

    Looks like it is not SAP Hana is not fully supported as target but there is a workaround given in below document. I don't see auto create table option.

    https://video2.skills-academy.com/en-us/azure/data-factory/connector-sap-hana#sap-hana-sink

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.