SAP Data Intelligence: data type conversion

[former_member714408]

Hello everyone,

i built a graph in Data Intelligence that is reading data from different HANA tables into a data transform operator. The output of that operator is a final table that i would like to push into our SAC by using the SAP Analytics Cloud Formatter operator. Now i have the problem of different data types and i don´t know how i can convert the output from the data transform so that i can use it as input for the Analytics Cloud Formatter.

Thanks for any help!

[shaktik]

Hi,
What is the output data format of data transform operator ?You can try converting data from data transform operator to CSV format (may be using custom operator if needed) and then use decode table operator (com.sap.table.decode - This operator decodes tabular data from one of the supported formats into table messages. Currently, only CSV input is supported.) to push data to SAC.

Thanks
Shakti

[former_member714408]

Hi shakti,

thanks for your input. Output data type is "table" with data type ID "generated.datatransform1_out". How can i convert that into CSV format, is there a standard operator? What do i need to do in a custom operator? Unfortunately i haven´t gathered any experience with custom operators yet.

[rajeshps]

Hello ramymonirr

simon.ye2016

martin.boeckling

941002jannis

shaktik

martin.boecklingJSON STRING TO TABLE DATA TYPE

I have similar query which is blocking the graph completely, please require your inputs.

Thankyou!

[martinboeckling]

Hi Jannis,

within DI you should find an operator called Table to message converter which should meet your requirements. The documentation for the operator can be found here.

Depending on the case you want to achieve you could also prevent using the SAP Analytics Cloud Formatter as the output of the Table to message converter operator is already of type message if you want to use for example the SAP Analytics Cloud Producer operator.

Best regards,

Martin

[former_member714408]

Hi Martin,

are you referring to the "ToMessage Converter"? Because i´m not able to connect the output port of the data transform to the input port of the converter. I cannot find a "Table to Message Converter" though.

[martinboeckling]

Hi Jannis,

what kind of DI system are you using? Within Data Intelligence Cloud you should see the operator under the Structured Data Operators as it is shown within the referenced documentation in my answer.