Scheduling a FIM job using BODS scheduler

Introduction

SAP Business Objects Financial Information Management is a web-based ETL Tool. The financial information management tool provides a user friendly interface on the top of SAP Business Objects Data Services. It allows the user to maintain mappings between source and target. A FIM job is a series of steps that loads data from a source to a target.  When a financial information management job is created, it can be run immediately or via an external scheduling tool such as Windows task scheduler. This document deals with scheduling a FIM job using BODS scheduler.

Scheduling a FIM job

                When a financial information management job is created, it can be executed immediately or via an external scheduling tool such as Windows task scheduler. This document deals with scheduling a FIM job using a BODS script. A scheduling file has to be generated that contains a command line to launch Internet Explorer on a given URL. The scheduling file gives information on the selected job, the execution parameters, and the user credentials.

Step 1:

Save the FIM job as a scheduling file. A scheduling file contains a command line to launch Internet Explorer on a given URL. The scheduling file gives information on the selected job, the execution parameters, and the user credentials.

Step 2

Enter the login credentials. A message is displayed informing you that the scheduling file for the job has been generated.

Step 3

Download and save the scheduling file.

A VB script gets saved.

Step 4

Place the generated VB script file in the Data Services installation folder in the job server machine. This has to be placed in – \\SAP BusinessObjects\Data Services\bin\ – path.

Step 5

          Login to BODS designer to create a BODS job.

Create a project named schedule.

Create a job named Schedule using ‘New Batch job’ option.

Add a script object inside the batch job that has the script to execute the vb script.

Print(‘ VB script execution triggered –‘ || exec(‘cmd’,’Job1.vbs’,8));

Step 6

The job Schedule_Job can be scheduled through DSMC to run the FIM job. To create the schedule login to data services management console and add schedule on the Schedule job.

Step 7

Create schedule for the job and activate it

This schedule will run the Schedule_job at the specified time.