Read from VORA into HANA

[Cal_Loudon]

Hi all,

I'm wondering if someone can help me with a Data Pipeline scenario I'm trying to implement. I have a pipeline which loads data from APIs into Vora tables as a staging area, I then select and join the reporting relevant fields together via a Data Transform and put this data into a new In-Memory table still within Vora. I want then load this data into HANA and I cannot seem to work out how to choose the table / column from the Vora that I want to load. Currently I'm using the Vora Client operator and HANA Client operator.

Can anyone provide any clarity over my approach or suggest alternatives?

Thanks in advance,

Cal

[former_member272504 · Accepted solution]

Hi,

Your requirement is to merge non-workflow operators and workflow operators. I have a work around for this but not recommended by Data Hub.

in your pipeline after the datatransform,

-- > Place a constantgenerator operator and connect the output of datatransform to in of constantgenerator.

-- > Write a SQL select statement in the content area of the constantgenerator operator. example as below

SELECT PRODUCTID, ZCNTRY, ZREGION, SENTIMENT, NUM_OCCURRENCES FROM "DAT263"."SENTIMENTANALYSIS";

-- > Place SAP Vora Client operator and connect to constantgenertor.

-- > Point SAP Vora connection to to your vora system.

downside in this approach is output of the vora would be column B, C, D, A though the vora columns order is A, B,C, D. To rearrange the columns just as we need... we will have to use formatconverter operator.

we can call this as data preprocessing...

-- > The last step is to convert this output now into a message and ingest into HANA.

Attaching a example pipeline file in txt, save it as .json file and import.