SAP BODS 4.2 SP 8 : how to execute a python script in a script

[former_member593409]

SAP BODS 4.2 SP 8 : how to execute a python script in a script

could anyone share some sample of how to execute .py python script within a bods script ?

need to execute a python script that inturn runs HIVE QL scripts for data load into HIVE.

Responses with detailed explanation appreciated since i am new to DS

[former_member772934]

Hi Srihari,

I have similar question, are you able to achieve this please let me know

Thanks

Madhu

[jmuiruri]

Greetings mobireddy,

Please see the solution provided in the Knowledge article below

• 2715479 - Execute Python script through exec() - Data Services
• Python
  

Best Regards,

Joseph

[former_member772934]

Thanks Joseph,

I am able to achieve this and below is the syntax to execute python Script from BODS Script

exec('ksh', '-c "sudo python3 path of the python script/file.py"', 😎

The Sudo - may or may not be required

Thanks

Madhu

[former_member635361]

If DS has built in Python, does that mean Python is already installed on the job server or would I need to install it myself - if so, would it need to be a specific Python version so I don't interfere with the existing UDT version?

If indeed it is possible, I would prefer to call Python via DS script and not through the UDT.

[former_member427802]

Hi, srihari.

You can use User_Defined Transform in Data Services for this purpose.

You can execute your python script within BODS or use classes and functions from your custom python module in the following way:

1. Put your script to the file server at an accessible location.
2. Insert User_Defined Transform in BODS Job and import your python script using "imp" module and use classes and functions from your custom script.

import imp
myscript = imp.load_source('myscript', '//job_server/lib_path/myscript.py')
myscript.myFunction()

[Rishabh_Awasthi]

Use exec function to call the python script:

exec('E:\Python34\python.exe', '<ScriptLocation>\HIVEScript.py , '8');

The Python exe file path is relative to BODS server.

Regards,
Rishabh