scripts in Data services

[Former Member]

I have been learning Data services, what are the prerequisites(knowledge) needed in writing scripts in Data services ,

noticed that only SQL won't be sufficient while writing complex script.

what other programming concepts (or) language is needed?

any guidance from you guys in writing scripts will be very helpful.

Regards

PR 

[akhileshkiran · Accepted solution]

Hi

As in the above post you can use Unix and Windows line scripts.

Please refer the SAP Data Services Technical Manual  for more information about the scripts.
http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_tech_manuals_en.pdf#page=334

Refer to the 3.7 Topic in the technical manual for more about scripts and its functions.

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_tech_manuals_en.pdf#page=1790

Data Services Scripting:

Data Services Scripting Language

I hope this will help you out.

Regards,

Akhileshkiran.

[Former Member · Accepted solution]

Thanks for your information Akhilesh

[Former Member · Accepted solution]

Hi Akhilesh Kiran,

Thanks for these links really very helpful.

Regards,

DJ

[sksaxena]

: As you asked regarding the other possible options to support SQL for complex scripting, I believe 'Python' is one of the best options.

Python scripts are extensively supportive while working with BODS. If you know it, then well and good, otherwise not a difficult task to learn. It helps in automation of functions/requirements as well.

Hope this gives you a direction. Thanks!

[Former Member]

Hi ,

You can learn unix script as well as windows command line scripts.

Like for moving file from one directory to another you will require scripts written in cmd

like

exec('cmd.exe','move location\file.txt location1\file.txt',8) etc.

Thanks,

Swapnil

[Former Member]

Thank you,  I got it Swapnil