Global Variables and Data Stitch in Oracle Integration Cloud

The video describes two new features called Global Variables and Data Stitch in Oracle Integration Cloud. Along with the explanation, an end to end demo is created to showcase how these two features can be used in Oracle Integration Cloud.

[@ramonlopes144]

Thanks from Brazil!

[@TechSupper]

Welcome!

[@nagarajkatare2810]

Hi Ankur, Thank you sharing this information. If we are using Data stich for assigning the value to variable then we have Assign action which is also doing the same. Then what is difference between both.

[@TechSupper]

Hi Nagaraj, Data stitch allows you to assign the complex assigments also as shown in the video. Regards, Ankur

[@zqadhar]

Thanks Ankur, Very good informative vedio. I have a doubt. Could you give a summary about this integration , Because I have a confusion. GetData REST service get some data and return the JSON payload(firstName and lastName). But in the next readFile (FTP Adapter)you are reading a file called abc.csv. Then what is the GetData Rest service giving to the readFile ? what is the use of mapping file-name template variable to readFile, because you are reading abc.csv

[@mitjasan3000]

What is the best practice to create global variable not only in one scope of integration but also for all integrations, connections, etc....? thanks

[@TechSupper]

You can't create the global variables for all the integrations. What you can do, you can create a Lookup, and use that lookup in the multiple integrations. Please subscribe to my KZbin channel kzbin.info if you have not subscribe yet.

[@abhinavpandey4198]

Hi Ankur, I have stiched payload and send it to target inside a loop.After sending the stitched payload, my loop start again and wanted to create fresh stitch with new set of values and invoke target with new set of values only. But when stitching starts again, old set of values also getting stitched along with the new stitched value. How we can null previous values as well as element so we can invoke target again with new stitched value only ?

[@TechSupper]

Use Assign instead of Append.

[@anilkumar-zp8og]

Hello Ankur, why did you remove your course from Udemy? And I have taken your course like an Oracle Integration Cloud (OIC) from Udemy.

[@TechSupper]

Due to some issues Udemy has unlisted all my courses. I have uploaded my courses on other platform. You can view the details on below link: www.techsupper.com/oracle-cloud-online-courses

[@tedmaulassociate4063]

This is a simple example, but how to use stitch for complex collections? For example.. Incoming REST payload: { "data" : [ { "username" : "USER1" }, { "username" : "USER2" }, { "username" : "USER3" } ] } .. for each user in the payload, do some check in an external system for whether account is disabled or not. Return collection back like this: { "data" : { "userDetail" : [ { "username" : "user1", "isDisabled" : "false" }, { "username" : "user2", "isDisabled" : "true" } ] } } Any idea?

[@TechSupper]

I haven't tried this, you can use append option to append the data.

[@adityatrivedi2080]

kzbin.info/www/bejne/Z5mwn5muetdgiJo&ab_channel=OracleDevelopers

[@romanticvideos9134]

Hi Ankur, how to create the oracle integration cloud account? plz tell me i need account

[@TechSupper]

Look at this video: kzbin.info/www/bejne/r6WmkKN3ZaaoqqM You can buy my OIC Gen-3 course to expedite learning on OIC using following link: www.udemy.com/course/deep-dive-into-oracle-integration/?referralCode=26194341D09D3B93921F

[@ashb.5772]

Ankur, How do we check if a given feature flag is enabled for our OIC instance?

[@TechSupper]

Hi Ash, Click on name initial from top right corner from the OIC home page, click About and see all the feature flag under Feature flag section.

[@rvind8285]

Hi Ankur, why aren't Global variables seen in assign operations

[@TechSupper]

Use Data Stitch option to assign global variables. Assign activity is limited for local variables.

[@rvind8285]

@@TechSupper Thank you. Did the same.

[@RaghavendraM]

Hi , do you have any videos on using Oracle HCM cloud connection and using HDL service?

[@TechSupper]

Not now.

[@RaghavendraM]

@@TechSupper please let me know if you have any plan to do a video on that .

[@aseemyadav307]

Sir why did you remove your course from udemy?

[@TechSupper]

Unfortunately, Udemy has unlisted all my courses without any specific reason which is beyond my control. I have uploaded one course A way to learn Oracle Integration Cloud on Eduonix that will help you to learn Oracle Integration. This is the same course that was on the Udemy. Click on the below link to buy the course. Use TECHSUPPER coupon code to avail the discount. www.eduonix.com/learn-oracle-integration-cloud