Projects and jobs – organizing ETL

Projects are a simple and great mechanism to group your ETL jobs together. They are also mandatory components of ETL code organization for various Data Services features, such as Auto Documentation and batch job configuration available in the Data Services Management Console.

Getting ready

There are no preparation steps. You have everything you need in your local repository that has already been created. In this recipe, we will use Job_DWH_DimGeography developed in Chapter 5, Workflow – Controlling Execution Order, to populate the DWH dimension tables DimSalesTerritory and DimGeography.

How to do it…

To create a project object in Data Services, follow these steps:

  1. Open the Local Object Library window and choose the ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.