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

[. . . ] Data Integrator Core Tutorial Data Integrator Core Tutorial Tutorial Data Integrator Core Tutorial Data Integrator 11. 7. 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. [. . . ] 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. 1. 3. Data Integrator Core Tutorial 103 9 Changed-Data Capture Adding and defining the initial-load job 6. 9. In the Variable Properties window, for the Name type $GV_STARTTIME and for Data type select datetime. Repeat this procedure to create the global datetime variable $GV_ENDTIME. Close the Variables and Parameters dialog. 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. Open the work flow definition for WF_CDC_Initial by clicking its name in the project area. Click the script icon on the tool palette and place a script on the left side of the workspace. Add a data flow to the right of the script and name it DF_CDC_Initial. Add another script to the right of DF_CDC_Initial and name it UPDATE_CDC_TIME_TABLE. Connect the two scripts to DF_CDC_Initial. Defining the set and update time scripts When typing scripts, be sure to follow the date syntax required by your database. To define the workflow scripts In the object library, open the Customer source table by double-clicking it. To view the entire table, click the Open in new window icon. Notice the oldest timestamp in the Cust_timestamp column is 2001. 03. 27 00:00:00. In the project area, click WF_CDC_Inital to go back to its definition in the workspace. Click the SET_START_END_TIME script's name to open the script editor. [. . . ] 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. 180 Data Integrator Core Tutorial Running a Real-time Job in Test Mode Exercise 14 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. [. . . ]