Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Scheduling An Import Job Query

Akumar00
New Contributor
New Contributor

Hello Team,

There is a requirement that an authoritative source reconciliation job be scheduled to pick up updates from the last 7 days.

As per the current configuration, we have defined CP5 in the security system to pick up updates for 24 hours only.

We want your assistance in achieving the requirement with the fewest changes possible.

Please let us know if any further information is required on my end.

 

Regards,
Amit Kumar

16 REPLIES 16

naveenss
All-Star
All-Star

Hi @Akumar00 ,

Can you please share some more light on the requirement here? 

Which connector are you using? the configurations used and so on. 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Akumar00
New Contributor
New Contributor

Hello Naveen,

We are using a REST connector to connect to the authoritative source. We are importing the user accounts from the HR source that have undergone an update in the last 24 hours, and accordingly, we have configured the security system so that custom property is set to 1 (fetch updates from the last 24 hours).

We are using a custom package defined with PREPROCESSOR QUERIES to perform onboarding, termination, and modification when updates have taken place in the last 24 hours.

Regards,
Amit Kumar




 

 

Akumar00
New Contributor
New Contributor

Hello Naveen,

Kindly let me know if any further specific information is required?

Regards,
Amit Kumar

Akumar00
New Contributor
New Contributor

The only requirement is to schedule the existing Import job to fetch updates of last 7 days happened on authoritative source. 

It can be achieved by creating new endpoint, connector and link the new job with it, but I am looking for a solution to achieve the requirement by making minimal changes.

Regards,
Amit Kumar

Akumar00
New Contributor
New Contributor

Requirement: The import job should run on weekend fetching updates from HR source (updates of last 7 days)

Current Workflow: The import job runs thrice in a day and fetch updates from HR source on the basis of last updates in 24 hours

What is business use case to pull data of past 7 days ?


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Akumar00
New Contributor
New Contributor

Hello Rushikesh,

We have observed that on the HR source, users are onboarded with effective date (which determine their actual onboarding date) and sometimes this can be a future date. Once the date arrives, the user's profile attribute undergoes some changes like Manager Update, Role Update and those changes are not picked by the import job as it's picking updates of last 24 hours.

Hence, we decided to schedule an import job that should run every 7 days picking those updates along with the normal schedule defined (every 8 hours)

You should pull data based on last update date


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Akumar00
New Contributor
New Contributor

Hello Rushikesh,

Thank you for sharing your input. But this might require changes to be made at the package level; we will analyse it.

We were looking to achieve the requirement with the existing configuration of the import job and will appreciate your suggestions if there is any possibility for the same.

Regards,
Amit Kumar

What if any changes are missed with 7 days configuration also ? 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Akumar00
New Contributor
New Contributor

Hello Rushikesh,

The time interval for scheduling the import job for 7 days was decided mutually with the HR source team, considering their workflow on the user management cycle. Hence, the client has requested the same.

Also, the import runs every 8 hours, which should ensure updates are picked up as part of the current configuration.

Regards,
Amit Kumar

Akumar00
New Contributor
New Contributor

Hello Rushikesh/Team,

I am looking for your assistance on this request, your suggestions will be appreciated.

Regards,
Amit Kumar

Akumar00
New Contributor
New Contributor

Hello Rushikesh/Team,

Is there any possibility where the endpoint customproperty variable can be defined in the access query property of PAM_CONFIG (connector level) and populate the value accordingly to the endpoint's access query field.

Because we have defined cp5 in the endpoint as 1 (pick update of last 24 hours)

Regards,
Amit Kumar

Akumar00
New Contributor
New Contributor

@rushikeshvartak kindly assist with your suggestions on configuring logic to pull data based on last update date from HR source as the current custom jar already has an inbuild logic implanted to feed data of last 24 hours

what is source ?


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Akumar00
New Contributor
New Contributor

Hello @rushikeshvartak 

The authoritative source is Oracle HCM and we are using custom jar to bring data from the HR source.

Regards