🚀 Add to Chrome – It’s Free - YouTube Summarizer
Category: N/A
No summary available.
00:00
hello welcome thank you so much for joining this is day six of Oracle integration training in this session we will learn about Oracle Integrations basic navigations and the integration page canas all the elements available in
00:16
integration then we will learn that assign in OIC that with the help of assign we are going to create variables that we are going to learn and in last we will learn about switch action in YC with the help of switch we can add conditions in our integration so let's move to that first that basic
00:32
navigations and then we will move to that accents and all so you can see this is our first the integration page when we are creating Integrations we are getting this P so this is the place which we are considering as a designer page or the canvas where we have to draw
00:47
all this Elements which on which we have to work there you can see this side we have the acction and handling end points this is the error checking this is the notifications and all these are the navigations so let's move to the o instance and let's see one by one to all these end points so this is our Oracle
01:05
integration Generation 3 and now I'm going to design and design we have integration so let's let's open any of the integration and we'll see that how that integration is going to work so for example let me open or edit any of the integration so this is
01:21
the integration it's already in that configure so let me edit this one so when this integration will be edited we will be able to see the navigations and
01:39
all so you can see this is the page where we are designing or drawing our Integrations applications and all these are considered as an end point so this is a start that this is a trigger end point this is the stop end point this is the logger and there can be mappers and
01:56
all and you can see this is the place the ribbon where you can we change the the design of canvas from horizontal to Vertical vertical to horizontal and obvious we can go for the toline view where we will get the details about the each and every end point and here you
02:12
can see we have one more option to just maximize or minimize the end point which all we all having in our Integrations these two options are for cut copy paste which we will cover in our upcoming sessions and now you can see in the below we have option to make that canvas
02:28
page zoom in zoom out and yes we can if you want we can make it in foot G fit full all the screens and obvious we have another option to make a zoom out zoom in and all these things few options are there just to check where you have to navigate and all so instead of coming
02:45
here you can navigate by just click on that anywhere in the canvas and just scroll here and there in the left hand side right hand side you will be able to see the first one is the connection list so where you will be able to see all the connections created in the system go
03:01
below you will be see the acction so by here we have list of acction which acction one by one we will cover in our upcoming sessions you can say this is assign accent to create variables this is assign B2B accents to perform that the the invoking to b2p application by
03:16
converting the the data file format EDI to integration format and integration format to EDI and all this is data EST to update Global variables values this is Healthcare and point or Exel which we we will cover we are not going to cover
03:32
but yes in gen 3 they go one more things this is logger which we already used this is mapper St file notifications and many more right error handling Parts logic logic which means that Loop switch statement for adding conditions and all also we have call which which will help
03:49
us to invoke another integration from our one integration which is integration we have file SE work JavaScript functions we can directly call from here we have create publish two Integrations and all or all this this end point here we it's already there returns fault and
04:04
all many more this isim so in upcoming days we will use one by one right so here you can see this is the X icon where we can create Global variable this is the item we can search all the end points in our Integrations by name providing the name and all and now you
04:21
can see this is the message this is the icon by clicking here you will move to the global F Handler we will learn this Global file Handler to in our upcoming sessions this is the icon which help us to add the business identifier in integration and for that we have this
04:36
setting icon where we can change the information of integration just like name packages and the versions and all version we cannot change various name packages and description we can add now this is the basic overview of Integrations and now go back go back to
04:54
that slide and we'll we'll discuss that assign so assign is a X in OIC with the help of assign we can create variable in OIC with the help of a sign we can update the value of that variable created using a sign so you
05:10
know that the varable is something that which is going to hold values at run time so in integration we have to flow the data from one end point to another Endo sometimes we have to store the data in somewhere so that later we can use the data so for giving all this flexibility that assign Aon is going to
05:28
use so in simple term that assign ation is used to create variables and assign values to that variable created using assign ation it's allow you to manipulate data or that we can update the value available in that assigned variable by setting values performing
05:44
calculations and mapping data between variables and Target Fields during the indication so in the mapping we can use variables to provide the values at run time from the variabl that kind of things we can use
06:00
by default data type of assigned variable is a string and you can store up to 10,000 character in that a string variable that aing variable created using assign and also that Global variable also having the same character limit and when we are creating variable
06:17
when we are creating variable using that assign ation that variable cannot be accessible in global F so what is global fault we will cover an upcoming session it is something that error handling part assign variables canot store one value at a time and obvious if you want to
06:33
store multiple values you cannot do in assign but yes that's why we have Global variabl so with the help of global variable you can achieve the solution where we have to store multiple values to the single variable and when you will assign update the assign the same value to that
06:49
variable another value to the same variable it will replicate or it will remove the previous variable values available in the variable and it will assign new variables new value to that variable and you can see this is the design where we are creating the variable in our integration in simple term with the help
07:06
of a sign we can perform two actions that can be creating variables or providing default values another action can be that we have to update the variables value with the help of assign also we can achieve that small so this is about Aon that uh
07:22
assign Aon which we have to use in our integration and now another one is we have switch so in YC we are using switch to add the condition integration flow so in integration if we want to add the flow execution based on some conditions
07:38
we can use a stitch so when we are going to use a stitch so in a stitch there are two point that is the root and otherwise root is something that's defining that the conditions otherwise is something that if all condition will Falls
07:53
automatically control will move inside the otherwise block so it is just like if El block so in or OIC if you want to achieve if El kind of concept you have to go for switch action or switch activity and in in while when we are
08:08
adding switch in our OIC it's mandatory to have a default or that's we can say the otherwise block so otherwise we block will execute when all condition will Falls and whatever variables and values we we will create inside the scope that
08:26
can be the switch scope or that the otherwise scope that will be not not accessible outside the es scope so yeah that's that's the that's uh the concept of es scope so which we will learn day by day and yes when we will add switch
08:41
so in a single switch there can be multiple conditions that condition is known as root in in OIC switch and but there will be only one otherwise block so let's move to the integration instance and we'll see that how we can achieve this variable and the assign
08:56
action so this is our integration page let me create one new integration so what that integration will do it the integration will take two values and one one more values the third values as operations and based on that it will decide that they have to do the
09:12
perform operation as addition or subtraction so that kind of things we are going to do so in simple ter in we will create one app driven integration where we will create three variable that obvious in app driven integration when we have to create variable that variable
09:28
is that that be the query parameters or that can be the the review or template parameters so let's go to the integration creation so click on Create and here you have to select the application to create AB integration and you have to give the name so I will use
09:43
the name as XX sorry F underscore this is going to be up integration so before that I will give the name as I 001 and there called AP for ab D and this is for
09:58
assign so I will use assign and switch switch IND for 01 right so this is our integration name so I'm just going to click on create so I want to configure this
10:14
integration to have three parameters so that we can provide values so what three parameters value can be there so I want to provide the values like number one num two and the third parameters will be like operations what operation they want to perform so for that that I have to
10:29
create three variables so I will go click on Plus at first I have to add the rest trigger connection so that we can configure the parameters and all so I have created integration with the name f underscore you can see that's the rest
10:45
tree so I will select here and now here we have to give the end point name so this ENT point is going to start the integration so I will just start and this is rest end point so I will use rest now click on continue and now here we have to provide
11:00
the eSource URL or the Endo right so that it can use that Endo so what I will do I will give that end point AS Slash addition and here we have to add two parameters so I will use first parameter
11:16
as num underscore 1 SL second parameter num underscore 2 right and here the third parameter will be our uh oper that is plus operation or minus
11:31
operations that is addition operation subtraction or multiplication but this is the concept of rest API or the URL that in url we cannot use plus operation operator right so if we will pass plus operator it can create problem so instead of using plus
11:48
so we'll create one variable that's the query parameters and that query parameters we will pass value as a d for addition Su for subtraction mu for multiplication and so on so once you will click outside automatically this stick will be added because we added the two car two review
12:05
parameters you can see when we move control outside this one so automatically kcks added here so instead of this gate I will add a post so every time I follow post only so that later we can add the request and response payLo to so now it's done I don't want to do any changes here just go to continue so
12:22
here you can see this is parameter configuration page where these two parameters already added num one and num two and this num one and M2 value will be numeric so I will add as integer now I'm going to add third variable that will be our query
12:38
parameters so I will give the name as operation so pcore operation and here the data type it will be a string so why this will be a string because I will pass operation as
12:55
a d add for addition Su for subtraction and all so now the parameters is created here so I will just go and continue and done so our end point added the trigger end point and this trigger end point having the three parameters and now
13:11
based on that parameters I want to add some logic right so I want to Suppose there are first two variable the two variable and the operation is ADD so I want to add the I want to do addition of the first two number so obvious that addition we have to store somewhere
13:27
right so that's why we reir variable so I'm going to create a variable so just click on the acction here you can see this is the assign so drag this assign here this assign xtion is going to help us to create variables so I will create first variable and in the variable I
13:43
will assign any the values so for creating variable we have plus icon here just click on this plus here so I will give the name as vcore result so this is our variable name and what kind of value this variable is
13:58
going to store so right now I will provide the value default value as zero instead of null so for providing null value in the mapping or in the varable so you just have to remove everything just put single quotes as I told you the parameters right whatever we are going
14:14
to use that's can have the different different data type that can be number integer string and all but in the variable the variable created using a sign having fixed data type that is a string that's why here we provided the single code
14:30
so now the V result will have null values for the single Co empty values I will click here this will be set go outside so with the one the variable created now we have to update the value
14:45
of this variable based on condition if user will pass operation as a d we have to we have to store addition of the two number in this variable if the user provided value as minus the operation as minus then we have to store the subtraction of the two number in this variable that kind of thing so now
15:02
obvious we got to know that we have to add the conditions we have to add the logic right for adding the condition that's why we have switch action so click here on the action go to the switch so you can see this is switch so I will drag this switch here so once you will drag your
15:18
switch here you will be able to see this one right the the switch scope added and in the switch scope they asking for configure route this is first root right so root is something that condition so they are asking to add the conditions so
15:34
first I will change the give the name here so this root name will be root add so this will be work for additions so I given the name as root
15:49
add and this is the condition we have to add so the statement so I want to compare on the template parameters so if this template param value that is O pcore operation value is equals to add right so I'm going to
16:05
provide operation as a d so if the operation variable having value as a d then what you have to do just click outside you have to add the otherwise B so we came outside but we are not able to see anything by because by default
16:21
there is only one that's why it's not showing so just click here go to add and add otherwise I told you the otherwise is mandatory for for each and every H switch condition you have to as otherwise so that you will get to know that when that integration got error and doesn't have any
16:39
values so I will click on otherwise so once you will click on otherwise you can see the root one already added which we given the values at root add and the last one is otherwise so I will add provide the
16:55
value in otherwise later so this is the first rote and first root what we want to do we want to do the addition right that's why in root one we add the check the condition we added the condition to check the value as add a d add for addition
17:15
right so if the condition will be true it will go inside and do the addition but that addition we have to store somewhere else right so that's why we created variable here and we want to store the value of the addition in that variable so for assigning the value to the variable again we have to use the
17:31
assign ation so I will go here I will drag the assign again again and here we have to update the variable right we don't have to create the variable so that's why for writing the variable Valu just click here and you have to select the variable here only so that that you
17:48
can be identify which variable we have to assign value so what I will do I will just remove this one and here I will direct the variable so the variable is where results so I will direct the variable so so sorry here we have to select the
18:03
variable as V underscore result so V result variable selected and what value you have to assign to this V result so I want to assign the value of addition of this two number the number one and num two right so what will be like that it will be like bracket plus bracket and
18:19
this will be number one and this will be number two second will be number two right so what we can do we are inside this blacket so just drag your number inside the bracket only so this is the one so I removed just because it was not in mode so I will click here to make it
18:36
mode so I will put this inside the bracket so this is the number one then we have to do the operation as a add and now here we have to provide the another number in the bracket so I just go and drag here so now here you can see this
18:53
assign variable will hold value of addition of this two number that is num1 and num2 so M1 and M2 addition will be stored into that where result because it's coming from right to left so whatever value will be there in the right side of that equals to will be
19:09
shifted to left side of equals to and now here I will give the name of this assignment so assignment name is ADD so I will give the name of assignment s assignor
19:26
add so that in loger we we can identify this is the addition X assign X for addition now one condition we added right so if user will pass Su right so sub is not equals to that a which is added in the root one so control will
19:44
automatically move to otherwise right but we don't want to do this one right we again want to add condition so just click here sorry just click here go go to the ADD
19:59
and add another root so once you will click on add another route automatically added you can see the configure route so here you have to provide the name of that root so I will click here I will give the name of root is R root sub that was for addition it will before
20:15
subtraction and here what we have to do we have to add the condition based on which we have to check the condition so I have to check the condition based on query parameters so I will dag this parameters here and what value initially we want to
20:31
assign I don't want to assign any value so I will put it null value by providing the dou puts so now you can see no so we have to add the condition
20:46
as operation is equals to sub right sub for subtract so S Sub so now when operation variable value will be S be sub then this root two will be executed that is root sub so just click
21:02
outside so that it can save the configuration and now you can see root two added with the name root sub right subtract so again we have to do the same we have to assign the value to that variable as subtraction so again here we
21:18
have to add the variable that is the assign variable or assign ation so this is the assign I'm just going to use I will give the name
21:33
as assign uncore Sub sub that is subtract and here we have to select the variable for which variable we have to update the value so I will click here I will select our variable that is V result and what value we want to store
21:48
in the v result so we want to store the value in the v result is number one which is in template parameter number
22:03
one here we have to write the bracket and we we have to give the operation as subtraction this will be the second parameter which we will take as num two so now num one and num two added if you will click here you will be able to see
22:19
the values so Val result will store the subtraction of these two number right so that's was our our result now again we have to add one more condition to add the multiplication so again I will so adding the end point or root again we just have
22:36
to click on the switch just go to add and here again we have to add the root name so I will click here I will give the root name
22:52
as root andore mul mul for multiplication now this one added and now we have to check the multiply operation or multiply values right so again here we have to select the variable on which we have to
23:09
check the condition so I have to check the condition and query parameters I will direct the query parameter here that is p operation is equals to what we have to check we have to check the we have to check the value as multiplication so for multiplication I
23:25
will pass mul so so now you can see our value condition will be P operation is equals to M so if this will be true that is root M will be true then control will move inside this scope the inside the scope of this assign so here again we
23:42
have to select the variables I will click on this plus I will select the assign and now here we have to select the variable for which we have to update the value so I will click here I will select the variable as V result and here
23:57
we have to Prov provide the value so what value we want to provide we want to provide value for addition multiplication of that two number right so I will just let me see this one
24:14
right so I will go num one and it will not be subtract right it will be asterisk
24:30
I will take it I will paste it and num two so this two will be multip multiplied and it will be insign to the variable so you can see that V result isal to num one into num two whatever
24:46
will be the value let me change the name of this assign so I will give the name as assign and for multiplication not click outside so we add the three condition to check the addition to check the subtraction and to
25:01
check the multiplication so if suppose user pass any invalid value except this three so control will automatically move here in the otherwise block and in the otherwise block let's display the message using a sign so we will add that value to that variable so that
25:20
result where result and I want to provide the value to the V result is the operation Y is not
25:36
correct the operation the Operator Operator you provided is not correct right so now in case of otherwise block it means that when the
25:52
operation will not be add when operation will not be subtract when operation will not be M then control will automatically moove the otherwise block and store the value to the variable now if you will go outside this scope right so now when our integration
26:08
will be completed that integration will having one variable and it's taking three parameters from integration So based on condition this variable value will be updated by by addition of the first two number from b or that multiplication subtraction
26:25
anything or in case of otherwise it will display the message so how we have to display the message we have to display the message using logger so I will directag the logger here no I don't want to display anything
26:43
I will just give the name as logger and there for result click here and here we have to give the value what value we want to display so again I will use the sameed value
26:59
so instead of providing hardcoded values I will just use the variable to display right so here you can see we are not able to see the variable if you will go below you can see this is the r results I will direct the results so whatever will be the value will display there the log so click
27:18
outside click on save button to save so now go back to the integration we have to activate the integration you can
27:33
see the integration is in drop mode because there is having one error so I got to know that error is related to the tracking variable because it's me to have at least one tracking variable for each and every integration so [Music]
27:50
add so we'll get from query parameters that operation right so this got added now everything is fine status is configured just save the con save the integration and just go
28:06
back so here I will just activate the integration activate my integration is activated so let's run the integration so once we will run the
28:21
integration while running the integration you will be able to see all these parameters right so all these are called as UR parameters and there is two category of URI parameters the first category is the template parameters and another one is the query parameters now let me provide the value
28:38
so first value I will provide as 10 second value I will provide six and now operation I will provide a d That's the capital add we use right in our integration to add the condition so I will just click on run so you can see the value we passed
28:54
that value merged here that is 10 six and this is our parameter name with the value as ADD so if you will see integration complete exercise fly if you click on is the I icon you can see it is 16 so 10 + 6 is = to
29:11
16 right even here you can see we added the variable we add the assign one to create variable so once we will expand you will be to see that variable where result was assigned with dual so that is the null so we didn't provide any value to that V result now after that here you can see
29:28
we have the condition so we added the switch right so you can see the message message entered switch so control move inside the switch and inside the switch we added various condition and the condition which will be true it will display here so the condition P operation is equals to add got true and
29:44
once this got true it will go inside and inside we added the the assign any point which the name as assign add this will expand you will be able to see the V variable where result was assigned with 16 that is 10 + 6 so if I will pass anything here instead
30:01
of six I will pass 16 so it will be 10 + 16 = to 17 you can see and here in the loger also we are providing the same so you
30:16
can see this is 770 and inside this one if you will go to the variable you can see where result was assign by 17 so now this time let's use a Sub sub for subtract so click on run it will pass this value it will check the value based on this
30:32
sub value and it will subtract 10 - 60 it will be minus 50 so it will display that result here right so you can see which condition got through the condition P operator is equals to sub got through and the value value of that variable is minus 50 same you will find
30:49
in the loger right so now the third one we will try for multiplication M so if you will provide m so 6 60 into 10 is 600
31:04
right you will to see the value here x running so you can see the condition got through that is p operational to M and
31:20
if you will expand you can see the variable assign name is assign M that end point that assign end point and the variable where result what updated with 600 so that's the logic using if uh switch statement and assign we added if we will provide any incorrect values
31:36
right for example divide D so div is we have not added right so if you will click here so it will move to the otherwise block it will not move any condition because DB is not added in the condition so you can see message in
31:51
switch switch control go inside the move inside the switch and that it's executed Mage root through switch rout with condition otherwise why because we have not added the condition for D so it it's not going to pass condition for add not for subtraction not for multiplication
32:07
that's why control will moved by default to otherwise in the otherwise we add the condition message as where result the operator was provide the operator you provided is not correct same you will be able to see in the logger the operator you provided is not correct so this is
32:24
the quite simple integration which we created where we we got to know about the assign we got to know about the the switch action by which we can add the conditions and all so thank you so much
32:40
everyone for joining the session if you have any other queries and you want to ask anything stage is open for you you can unmute yourself and you can ask thank you so much again for joining let's let's continue with the question and answer session