Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Populate "Last Extract Date" parameter in OCI Data Integration pipeline

edited Sep 29, 2021 5:28PM in Data Integration 12 comments

Summary:

Unable to pass a value to the parameter type "Last Extract Date" in an OCI Data Integration pipeline.

Content:

Hi Experts,

I'm new with OCI Data Integration and been exploring the possibilities. The use I'm meaning to give it is to extract from Oracle Fusion Cloud using BICC functionality and load the data into an Oracle Data Warehouse... and so far so good.

The problem I'm facing is that I'm establishing an incremental extraction from BICC and you can set a "Last Extract Date" type parameter. My idea is to schedule extractions on an hourly basis, so I created a pipeline that had an integration task which in turn had a data flow defined within. The idea is to update the "Last Extract Date" on each schedule run, but so far I haven't been able to set the parameter unless I manually set a value, which of course is not what I'm trying to achieve.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!