SAP BusinessObjects Planning and Consolidation: Integrate Jobs into Your Existing Enterprise ETL

  • by Karunakar Gillella, Sr. SAP Administrator, ConAgra Foods
  • July 13, 2010
See how to set up controlled batch jobs for SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, with any corporate scheduling tool. This allows you to load end-to-end data from SAP NetWeaver BW to SAP BusinessObjects Planning and Consolidation and vice versa. Follow the steps for creating a batch file on the SAP BusinessObjects Planning and Consolidation application server to execute the scheduled SQL Server Integration Services package on the SAP BusinessObjects Planning and Consolidation data manager.
Key Concept
SAP BusinessObjects Planning and Consolidation, version for Microsoft, accepts data only in flat file format. SQL Server Integration Services (SSIS) packages are used to accept data from the file, transform the data into the desired format, and execute the SAP BusinessObjects Planning and Consolidation-specific tasks that load the data into SAP BusinessObjects Planning and Consolidation and perform tasks such as dimension processing and optimization.

For companies implementing SAP BusinessObjects Planning and Consolidation 5.1 or 7.0, version for the Microsoft platform, several challenges are involved with setting up job scheduling and integrating SAP BusinessObjects Planning and Consolidation with the rest of the enterprise reporting landscape. While the Microsoft version provides a time-based job scheduling interface for SQL Server Integration Services (SSIS) packages through data manager, most companies typically schedule extraction, transformation, and loading (ETL) jobs using third-party scheduling tools that do not provide an easy interface with SAP BusinessObjects Planning and Consolidation.

When loading data into SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, you need to execute SSIS packages within the data manager, using standard SAP BusinessObjects Planning and Consolidation functionality, such as validating input records, logging reject records, and capturing the data load history. However, to have controlled scheduling and to integrate the SAP BusinessObjects Planning and Consolidation jobs into the overall enterprise-wide ETL schedule, it is beneficial to be able to trigger SSIS packages using any other scheduling tool and still have them execute within the data manager.

I present an easy-to-implement process for executing SSIS packages with a third-party enterprise scheduling tool. This process enables you to create a batch script on the SAP BusinessObjects Planning and Consolidation application server that can trigger the scheduled SSIS packages. The script also gets the return codes based on the execution status of the jobs and passes them on to the enterprise scheduling tool. When you pass the necessary parameters to it, only a single batch script is needed for triggering all the SSIS packages in an entire SAP BusinessObjects Planning and Consolidation environment.

Karunakar Gillella

Karunakar Gillella has around 10 years of experience in IT, with more than six years in SAP NetWeaver BW. He has extensively worked in leading and implementing the business critical projects in both SAP and non-SAP data warehousing areas. He has extensive knowledge in implementing the planning applications in SAP BusinessObjects Planning and Consolidation, version for Microsoft, and integrating data loads between SAP BusinessObjects Planning and Consolidation and SAP. He also worked on implementing the enterprise reporting solutions with SAP BusinessObjects and other BOE tools.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.