Consume SQL table on Python Operation in SAP Data Intelligence

[former_member759762]

Hi,

I am trying to do data processing using python operator. The data is coming from sql server. I am using table consumer to load the data from sql server. But on the python operator read the input data as empty dictionary. Does someone have an example to process the table that coming from SQL or SAP DWC on python operator? and also sample python script.

Apologize if the question is duplicate.

Thank you.

[Dokon]

Hi Agus,

You can use "Table To Message Converter" Operator in Structured Data Operator Category.

Thanks,

Dokon

[former_member759762]

Hi,

Thank you for your help. I have tried it and on python operator it reads as message. Do you have example python script how to process the message on the python operator?

Again, thank you.

Regards,

Agus

[Dokon]

Hi,

You can find "File to File Python" graph in Modeler -> Graph Tab.

Thanks,

Dokon

[michal_majer]

Yes, Table to Message looks like a best approach for this case.

[former_member759762]

Hi, Don-kon Kim,

Thank you for the example, that's really helps.

In the end of the process I want to write the data to Data Warehouse Cloud or SAP DI Data Lake. The data is a data frame how I set the output for the python operator. And what output port that I should choose?.

Thank you.

Regards,

Agus