Scheduling An Import Job Query

[Akumar00]

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

[naveenss]

Hi @Akumar00 ,

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

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

[Akumar00]

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]

Hello Naveen,

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

Regards,
Amit Kumar

[Akumar00]

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]

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

[rushikeshvartak]

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

[Akumar00]

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)

[rushikeshvartak]

You should pull data based on last update date

[Akumar00]

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

[rushikeshvartak]

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

[Akumar00]

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]

Hello Rushikesh/Team,

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

Regards,
Amit Kumar

[Akumar00]

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]

@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

[rushikeshvartak]

what is source ?

[Akumar00]

Hello @rushikeshvartak 

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

Regards