User manual BUSINESS OBJECTS DATA INTEGRATOR 11.0.0 FOR WINDOWS AND UNIX CORE TUTORIAL

[. . . ] Data Integrator Core Tutorial Data Integrator Core Tutorial Data Integrator 11. 0. 0 for Windows and UNIX Copyright If you find any problems with this documentation, please report them to Business Objects S. A. in writing at documentation@businessobjects. com. All rights reserved. Trademarks Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Both jobs contain the following objects. · · · An initialization script that sets values for two global variables: $GV_STARTTIME and $GV_ENDTIME A data flow that loads only the rows with dates that fall between $GV_STARTTIME and $GV_ENDTIME A termination script that updates a database table that stores the last $GV_ENDTIME The source table in this exercise, Employee, contains a column called Last_update that a user would modify when creating or updating a row. The job checks this datetime, determines if it is later than the last time the job ran, and if so, passes only that row to the target template table. The target database contains a job status table called CDC_time that stores the last value of $GV_ENDTIME. When you execute the delta-load job, it updates that value to use for the next execution. Therefore, this chapter introduces three new concepts: · Changed-data capture 96 Data Integrator Core Tutorial Changed-Data Capture Adding and defining the initial-load job 9 · · Global variables Template tables Adding and defining the initial-load job First create the job that initially loads the target table. Job_CDC_Initial will contain an initialization script, a data flow, and a termination script. This section includes the following tasks: · · · Adding the job and defining global variables Adding and defining the work flow Defining the data flow Adding the job and defining global variables Variables are symbolic placeholders for values. You can increase the flexibility and reusability of work flows and data flows using variables when you design your jobs. In this exercise, you will create two global variables that serve as placeholders for time stamps (a start time and an end time). These time stamps will identify which rows in a source have been updated and therefore will be captured as being changed. Global variables are exclusive within the context of the job in which they are created. Add and define the job and job-level global variables as follows. To add the job and define the global variables To the Class_Exercises project, add a job named Job_CDC_Initial. Verify the job is open by clicking its name in the project area. From the Tools menu, click Variables to open the Variables and Parameters dialog. Notice that the job name displays in the Context box. Right-click Global Variables and click Insert. Data Integrator adds a variable with an automatically generated name. Right-click $NewJobGlobalVariable0 and click Properties. In the Variable Properties window, for the Name type $GV_STARTTIME and for Data type click datetime. 3. Data Integrator Core Tutorial 97 9 Changed-Data Capture Adding and defining the initial-load job 8. Repeat this procedure to create the global datetime variable $GV_ENDTIME. Adding and defining the work flow 1. To add and define the work flow With the Job_CDC_Initial definition open in the workspace, add a work flow named WF_CDC_Initial. [. . . ] Note: ClientTest. exe uses DLLs in your Data Integrator\bin directory. If you encounter problems, ensure that you have included Data Integrator\bin in the Windows environment variables path statement. Start Data Integrator Designer and log in to your repository. 2. 162Data Integrator Core Tutorial Running a Real-time Job in Test Mode Exercise 13 4. Import TestConnectivity. atl: In the object library with any tab selected, right-click in the blank space and click Repository > Import From File. Navigate in your Data Integrator installation directory to \ConnectivityTest and open Testconnectivity. atl. [. . . ]