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.

[michal_majer]

Hi Agus,

The Table Consumer comes from Structured Operators category and You need it to connect it to other operators from this category (check docu below).

You could try to use SQL Server SQL Consumer with Flowagent CSV Producer. Output content form CSV Producer could be consumed by any base operator (python, node, js, go).

Alternative way is to load the data to file - then read the file - process - etc.

If You need more details let me know.

Best,

Michal

[former_member759762]

Hi Michal,

Thank you for your help. I will try it first. Will back to you if need more detail.

Regards,

Agus