Skip to Content
Technical Articles
Author's profile photo Freek Menger

Generate SAP BO Data Services dataflows from csv



When implementing SAP BO Data Services (BODS) it can be a very time-consuming task to create all the jobs, workflows and dataflows. Usually, the design and naming convention is already clear and creating these objects can be a repetitive task that will use up unnecessary time. I’ve created a basic open source program that can do this job for you: bods-generator.


The python program will generate an SAP BODS XML file that can be imported into BODS and create the objects there. The program is still basic as it can only generate jobs, workflows, and dataflows. However, you can include dependencies: either that the dataflow is contained in a workflow, or the workflow is part of a job. The input for the program is an excel file that contains the name of the objects, the type and finally dependencies.

The output of the program is a .xml file that can be imported into BODS.


Download the files from the GitHub page:

Follow the instructions:

  • Create a CSV according to the sample.csv format. Provide type (job, workflow or dataflow), name and subobjects (optional) Make sure objects are given hierarchical with the lowest object first – if they are dependent. E.g. workflow that is involved in a job: the first line in the CSV is the workflow, the second line is the job
  • Run the program with parameters:
  1. the input CSV file (with directory if in another directory)
  2. output XML file (with directory if in another directory)
  • Load the output XML file into data services


The program is open-source, so you are free to take the source code and extend it. There are some limitations, see terms of the GNU General Public License v3.0 license.


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mukesh Kumar
      Mukesh Kumar

      Freek Menger, this looks so exciting to me. I haven't tested it since I don't have access to a SAP Data Services system as of now. You seem to be a Free Software enthusiast (released your code under GNU GPL). Interesting and thanks for sharing! All The Best...