Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JayQueue
Creator
Creator

Buffer the changed data and commit in one time and re-use in another job

Hello,

I'm working on a sync between our HR software and LDAP/EXO/....

Looking for changes and updating them works but I want to keep those changes and then push them to LDAP.

Now I check for a telephonenumber, after that check I commit those changes to LDAP. And the same for mobile, for manager...

0695b00000QFBzEAAX.png

Is there a way I can just combine all the changes and commit them all at once? And so I can re-use that data to update Graph API.

I tried with tHashOutput but the schema's are not the same. Then I thought of creating a csv....

Is this a good way or are their better components/methods? 🙂

Thanks!

Jonathan

Labels (2)
1 Solution

Accepted Solutions
JayQueue
Creator
Creator
Author

I went for another way.

Storing the changes in hashOutput and using them as LookUps with a tMap.

 

0695b00000QFD37AAH.png 

But thank you 🙂

 

View solution in original post

3 Replies
Anonymous
Not applicable

Hi

You can try the way: storing the changed data in file or DB, create a type column stored different action like 'updating', 'inserting' and 'deleting' that can be used to filter different action for later. Create an entity column to store different object, like 'mobile', 'manager'.

When doing the synchronization, read all these changed data from file or DB, filter the data by entity value and update them into

corresponding target object.

 

Regards

Shong

JayQueue
Creator
Creator
Author

I went for another way.

Storing the changes in hashOutput and using them as LookUps with a tMap.

 

0695b00000QFD37AAH.png 

But thank you 🙂

 

Anonymous
Not applicable

Great, glad to see you achieve it!

 

Regards

Shong