Hello all, Happy Sunday!
Some time back i posted couple of videos on my YouTube channel talking about Taleo Connect Client (TCC) its export and import functionalities.
Today i thought of sharing some more info in regard to a key feature when it comes to TCC exports - Last Run Date (LRD).
You see, in most of the business scenarios, you will get a requirement to extract only a 'delta' and NOT the full data from Taleo system everytime. That's where this LRD comes handy as it can help to extract only incremental data extraction.
It helps you pull only records that changed since the previous successful run, which reduces file size, improves performance, and makes recurring integrations easier to manage.
LRD lets TCC compare the current run against the previous run timestamp and return only the delta, so you can move changed data instead of repeatedly moving everything.
As mentioned in the post title, LRD is used in the export configuration, so TCC knows where to start from on the next run. After a successful execution, the tool records the run time, and the next export uses that value as the baseline for incremental extraction.
The key point is that LRD depends on the previous successful execution. If a run fails before the timestamp is updated, the next run may re-extract the same data or behave differently depending on the job design and filter logic.
Now Let's try and understand its usage with these below snapshots -
As part of any TCC export design, please think of your required business objects, fields, filters and also most importantly which is going to be your lrd related filter. For e.g. here i've shown a very basic candidate data extraction based on last modified date as my LRD parameter. So, what this script will do is to extract ALL candidates which are modified after my last run date
TCC Export (sq.xml)
Projection fields in my TCC export (CandidateID, Fname, Lname, etc.)
LRD Filter
How to add a new LRD Filter
Sorting of my TCC data
Overall XML structure of the Export
Once your TCC export (sq.xml) file is prepared. you have do add some minor modification to your config file (cfg.xml) as well
Pre-processing in CFG file
the LRD file is stored in your TCC installation folder. Name of the LRD file is based on the configuration file that creates and updates it
The date and time of a successful export workflow is stored as a *.lrd file
Hope this would have given you some idea about the LRD filter. for more details you can always refer to the official Oracle documentation here
Thanks, and enjoy learning :)
No comments:
Post a Comment