🚀 Add to Chrome – It’s Free - YouTube Summarizer
Category: Tech Training
00:00
uh hello everyone thank you so much for joining session this is day three of Oracle integration training and in this session we will learn about schedule Integrations with parameters and we'll see the basic navigations of tracking and enabling the monitoring and all so
00:16
like while learning the integration how we can debug the log messages and all so that we are going to learn in this uh today's video so before going to start so as if you remember in previous session we are done with that schedule integration creation that where we created schedule integration just by
00:31
printing the log messages so now in this session first we will create a schedule integration and where we will add the parameters so obvious when we are using parameters in integration so we are using parameters in integration to pass uh data or values to the integration at
00:47
run time and just we have few limitation in schedule Integrations parameters that in one schedule integration there can be up to five parameters we can add in Integrations and that obvious more than five we don't have flexibilities to add parameters in
01:03
schedule integration and when we are adding parameters in schedule integration so they have the limitation that the values for that specific parameters that all five parameters cannot go beyond that 256 character so by default each and
01:19
every variables each and every parameters we are creating in OIC it is uh it is uh a string character only so a string values only so yes we can have uh up to 256 character uh character for each and every parameters so let's move
01:35
to the to instance where we will learn how we can create integration with the parameters so I'm just going to design part where I will go for integration to create Integrations and if you remember last time we created one integration and given the name as f o f o a s i will
01:54
search with the name so this is the integration we created uh St details not this one the logger one right the SC logger we created so in this integration it was quite simple integration where just we added the few log messages and whatever log message we fix or we given
02:10
in integration uh that was we just able to see in the activity stream and that logging dashboard so where we can see so now in this time let me run this integration again so that just you can have brief on that so here you can see this is simple integration we are going
02:25
to run this integration on adog basis we already discussed that what is adog basis so that schedule integation whenever we are running schedule integration on our requirement basis that or need basis that the term is known as adhoc request so we are running this schedule integration on adhoc basis
02:42
to that just we have to click on this run and you can see this is activity stream this activity stream is displaying the messages so these all are the log messages which uh we have added in Integrations and that log message con contains all the values and the all the
03:00
payloads of that integration end points we added so if you will see in our Integrations we added two end point that is two action to display the log message which is logger so we added two logger to display two log messages and obviously it was one end point was a
03:16
stop and uh first end point was that schedule which is responsible for starting the integration or we can say that to trigger the integration so if I will refresh here so one time when you will run so it's not like that you will create and you will
03:31
be able to see the log messages sometimes you have to just refresh again to load all the messages so once you will loog so whatever message will be there you will be able to see so here you can see this is the fixed message right my name is zafur and here that hey this is our first integration this is
03:47
the fixed message whatever number of time you will execute this integration it will display the same message only but now this time we want to pass some values while running the integration and whatever value we want to pass we want to display that value here not the fixed value right so that's why we have to
04:04
create integration with parameters so let me go back and I will create integration so for creating integration again I will click on this create button here we have to select the integration pattern or simply we can say integration type so as I'm going to create schedule
04:20
integration which will automatically run or we can run on ad hoc basis app driven integration that is application integration we will cover we will also create but uh right now I'm I'm going for schedule only so once I will click here it will ask the file name again integration name again identifier will
04:35
comes automatically but yes you can also change so I will give the name as same which we given earlier so this was the name and this was 002 this time I will give uh 003 and here you can see once we change
04:51
three here it automatically change here but it's not fix right you can change if you want you can change that identifier here also right so I don't want to do any changes here so here just I will click on create this version and all packages and all we will cover later so
05:07
if you remember last time when we created our first integration we given assign one package so let me check that package is there or not so the package was something fo yeah this one F O.C so again I will add this one also click on
05:22
create so once we will create click on create you can see by default whenever we are creating any schedule integration by default we are getting two end point the first one is schedule another one is stop so for each and every integration it's mandatory to have a minimum one
05:39
trigger end point so in case of schedule integration automatically added the trigger end point that endpoint name is sedu so this is trigger end point right so here we added the log message and whatever operation we want to perform we will do between this trigger and the and
05:55
and point right so I will just change the design here to horizontal and here we have to add the log messages but in the log messages we want to display the message which is coming at runtime while running the integration so that's term call as parameters to the schedule integration to add the
06:12
parameters in schedule integration you just have to click on this three Dot and once you will click here you will be able to find that edit option so you just have to click on this edit option this is the first way another way is just Goa just double click here so in generation three that's new Fe features
06:28
they added once you click double click on that so primary action whatever is there it will open so the primary acction is edit so once I will click double click here it will open the edit configuration page so now here you can see you currently have no schedule parameter that's true now we have to add
06:44
the parameters right so I will add first parameters so just click on the plus icon and here this is the parameters name parameters name means parameters variable name so what variable name you want to keep so generally in our development we follow the naming convention so as we are going to create
07:01
variable and that variable is parameters type variable that's why for denoting purpose we are using pcore and this is the variable and in the variable we want to display first message so I will give the name as pcore
07:17
first message I'm using this way this approach you can follow another approach to the another approach can be pcore FY rst first message so this is a camel notation right first character is
07:32
a small and uh remaining is a small and another word of first character is caral and remaining is a small so you can also follow this approach so I just prefer that pcore first message and it's mandatory
07:47
to provide default value for this uh for this parameters for each and every parameters so here you can see by default there is dual codes right two dual Codes start and end it means that it is empty value right not having any values so you can also put any hardcoded
08:02
values if you want to provide so uh let me provide hardcoded values as a high this is our first integration with parameters fullest
08:21
stop and for creating another parameters you just have to click on this plus icons so once you will click on the plus icon again it will ask you to provide the name so by default it's taking Name by adding sequence and all so you can remove this sequence value or this name values and you can provide your message
08:37
your variable name so I will give the name as pcore second message and here also you can provide any hardcoded values that you want to make it by default by default means while running the integration if you will not pass any value this value will
08:54
come by default to the integration so for this second parameters I don't want to add any message is right so that's done so once you done with the parameters created creation you just click outside anywhere in this canvas so that it will remove this configuration page and it will save the changes so I
09:11
just I will click here so now you can see that's hidden and integration got saved so now we have to display that a specific message to print the message in OIC that we have the logger facility so we will use
09:26
logger so where is the L ler this is the logger so I will use logger here in the logger here you have to select the message so what you want to display so I just want to display whatever value we are getting I just
09:42
want to display that one so so here you can see there is two option the first option is just click here select the variable you want to print so first variable I will print here so now first variable is this is the first variable is linked here right so once you will
09:57
click outside it it will be save so now in the logger one it will display the first message right even if you want to change this one right so you just have to you can see this is configuration or developer mode so once you will click here it will display the value so that
10:12
you can replace so if I want to replace with this so I can delete that one and I can select any other on so right now we are not able to see anything right so that's why in the left hand side you will see it is a source values right Source data this is the the logger and
10:30
this is logger our Target data that where we want to display so I want to display the message in logger so this is our Target and left side and side this is the source so which value we want to display we want to display the first message so I will just click here and I will drag the first message here so it will automatically came so this is the
10:47
first logger we added just click outside anywhere it will save so now first logger is added I didn't change the logger name that is logger one and all so I will let it be the same go select another logger so just make it place here when
11:03
you will get plus icon and here I will add another logger and another logger I want to display the values that P second message I will just drag here and let it be the same just click outside so now you can see in our
11:20
integration two where loger added right and this two loger added with the runtime value we will pass through the parameters so it is fine but now you can see in integration canvas we are not able to see any error message but here you can see we have one error right it's
11:36
counting one so if you will click here so whatever error you will have in your integration canvas it will display here so just click here and you can see the one error message is primary business identifier and it's related to that missing primary business identifier and if you remember I told you that in
11:53
previous session for each and every integration it's mandatory to have a minimum one business identifier your integration cannot be completed without business identifier and that business identifier we are using for tracking purpose we are using for
12:08
checking the log messages tracking our integration instance and all so here I will just click here and once you will click here you will be able to see the tracking variable to add so if you remember last time when we had uh added the tracking variable so we added the
12:24
schedule start date right when our integration got executed or when our inte got executed but except that we have this two variable that two variable is that the request variable we added that's the schedule variable of that integration so if you want you can make
12:41
this two variable as a tracking variable here so that whatever value you will pass run time to this integration this value will reflect in the tracking variable and you can see the tracking variable I will show you that to so let me drag the first value here only so this is our first business identifier I
12:57
will add second buiness identifier third I don't want to add anything so let it be so you can see once you will click here it will be minimized so there are total three tracking variable first variable is set with the first message second is set with second message and third is I don't
13:13
I have not provided anything so it is empty right so about that buiness identifier there should be maximum three identifier ination and minimum one business identifier as mandatory and the first business identif if you that will
13:30
be considered as a primary business identifier you can see right so I will show you that one where it will be used so just click on Save and so now you can see once we saved error got removed we don't have error message here and integration
13:47
status is in configure you can see so once your integration status will be in configure then only you can run the integration by activating that integration right so suppose if I will go to that buiness tacking variable again so by clicking here if I will
14:02
remove the if if I will remove the tracking variable from here go outside so you can see when we remove the tracking variable we got the error right it's the same error saying that at
14:19
least one tracking variable is mandatory so and when we we had that error in our integration so a status of the error is you can see status of the integration is draft unsaved right even you can save here so it will show the draft status so when your integration is in draft status
14:37
you cannot activate your integration so if I will go back if I will go back and you can see this is our integration we created that 03 and if you will see here Theus is dra and we are not able to see the see the
14:52
power button to activate this integration why because the integration is in draft mode so we can activate integration only when that integration status will be in configured so again I will go to edit the integration there can be any issues so I will just click here to get to know about the error so I
15:09
got to know that with this identifier error is there so I will just click here I will add the business identifier here this is first this is the second business identifier and I will came
15:25
out now you can see error got removed now once you will click on this save integation will be in configur status go back and you will be able to activate your integration so you can see integration status is in configure this is the status here you will see and you
15:42
can activate so how you can activate just go to the integration and you will be able to see the power button so just click here and when we are activating our integration we are seeing that three level of tracing so what this means of three level of tracing so let's let's
15:59
discuss about this in brief so that we can go and we can activate our integation so when we are saying that uh
16:14
like we discuss about the business business identifier right so as as we discuss for each and every integration it's mandatory to have an integration minimum one business identifier and in our integration we can have up to three
16:30
business identifier and when we are saying that business identifier that business identifier help us to track our integration that whatever message we are passing whatever value we are passing to the business identifier using that value we will be able to identify the
16:46
integration we will be able to identify the log message of that integration so this we already uh discussed so let's move to the next part that is tracing and its label so for each and every integration there is three level of tracing which we are able
17:02
to see the first one is production second one is audit and third one is debug so the audit and debug are bit similar but the most one is production so the production when our integration
17:18
is in production status that integration will not display any log messages payloads and all so when we are saying payloads that when we are running integation so integration is Flowing the data from one source to different source and Target right so that data we are
17:34
able to see in the activity stream when we are running the integration so once you will select the production you will not be able to see that message so it's always preferred that when we are running our integration on production instance because we don't want to display our production data right we
17:51
don't want to display our uh data to be available publicly so that any developer or anyone can see the log messages data the log messages that's why most of the time when we are moving integration to prodad so the tracing level we are setting to production so there are
18:07
slight differences between all these three tracing level so just here you can see having the brief so brief on the production uh on the tracing lbel is so uh the most common is the production one the when we when we are moving our
18:23
integration to prodad and that integration we don't want to display the data and all right and here one point you can see the data retain in activity stream for 30 days so in the production when uh production uh when we are
18:38
running integration with the production level of tracing so it will display very few information it will just display the endpoint names and information of that endpoint but it will not display the data of that endpoint because of that
18:54
also our integration is going to work much faster than when we are selecting the tracing level as audit and D so why we are saying it much faster so when we are selecting that uh tracing level as audit or so in both case it displaying
19:11
the log messages so when it's displaying the log messages in in activity stream it's taking some time to display the log message to generate the log message to display in the activity stream due to that integration is going bit slow so
19:27
that's why it's preferred that when we are moving our integration to Brad instance so first select as a production in tracing level so there is two two major reason behind it the first reason we don't want to display our production
19:42
data in public way so that they can go and check the log messages and see our data second way to make integration faster and the I told you that the slight differences between audit and debug is related to the time of that the
19:58
activity a stream and the message payload displaying over there so when we are selecting that payload as tracing label as audit so it's displaying data in the log message up to 8 days and when we are selecting as a debug so it
20:13
displaying data up to 24 hours only so that's the slide basic differences between that audit type of tracing label and the dwor and like we saw that much secure is the production where it's not displaying any data from the tracing level and all and obvious it's it's
20:30
limited that for example when we are running our integration we are adding the loop in the integration and for example that Loop is going to iterate 1500 of time so in log message you will not be able to see the all iteration of that while loop or for each Loop so it's
20:46
Max to up to 1,000 iteration only you are able to see so that's the tracing label we have so let me activate the integration and we'll we'll run yeah
21:06
no no no to add the loger or to add the any point in integration we have two way the the most common way is that we are just moving to that we are moving to that uh action and we are selecting the ation or action or element whatever we
21:22
want to draw in the canvas the first way which I used right now another way is that whenever you want to add that point I will show you like in when I will go to create another indat so you will have the plus icon automatically available when you will move your cursor over there so by clicking on the plus icon
21:38
you will get option to select your endpoint your select your action select your connection so by the way you can also add your endp point over there uh no no anything you can you can
21:55
add yeah [Music] so no no no no okay so are you talking about a log message right let me let me run so here we we we activated this
22:13
integration this integration is in activ status now we have to run this integration so just click on this three dot once you will click on this three dot you will be able to see that run Icon right run button so once you will click here integration will open that run page and and here you can see
22:29
earlier we don't have this parameter option right so not this time we have the parameter option so in the parameters whatever value you will pass that value will be send to integration and based on the operations or based on
22:44
the action we added in the integration it will process further so what we have done in our integration we added these two parameters these two parameters in two different different loggers to display the message so here you can see the parameters P second message this
23:02
parameters doesn't have any default values so it means that if we will pass whatever value we will pass from here it will send that value to integration and the first parameters you can see p andore first message having the default values which we all set while creating
23:18
this variable so if you will not pass anything here it will pass this default value if you will pass anything it will not pass the default value so let me show you that so where we are passing that message as I am oci
23:34
developer and have here I will pass I to okay so I'm just going to run the integration so in the integration it will take message as I AMC developer and the second message or first message that with the variable will be that high so
23:50
I'm just going to click on this run so here you can see when we run done this integration it's taken one second right to display the log message so if your integration will have more activity inside that integration it will take
24:07
much more time it can be 3 second 4 second 5 Second and all so as we our integration having only two and point it's not big integration so it's displaying message to far so you can see this is our first logger and this is the second logger right so when we pass this
24:23
two value to the integration so this value I'm see upload it so here you can see once you will click on this I icon you will be able to see the message whatever you pass in the logger one we map this first parameters and in the first parameter we
24:40
pass the value as high te that's why displaying here High te and the second one the P second message we pass at I am developer so once you will click here you will be able to see that I am y developer right so as this is default in this default we don't have any value so
24:56
let me remove this one and here also so we have already value we set a default value so I didn't I'm not going to pass anything right so once I will click now so for this column that P first message it will default pass this value to the
25:14
integation so let me refresh the page and here you can see once I will click on this logger one so it's taking why it's taking High to you let me refres again it's
25:31
it should display this value only let me run again uh maybe let me let me ration
25:48
again I don't want to deactivate
26:12
again ex stickly same R let me this SLE integration parameters having one more features the features is to restore the previous value so in
26:27
previous run whatever value we will pass it can store that values so let me check why it's taking that value so right now we don't we have not added that logic again it's taking the
26:44
same value
27:04
H current but we didn't provided any value right so the current value is null I'm no I'm not sure about that why
27:19
it's taking that value let me check
27:46
it will store the previous value only when we will update the variable in YC but this time we have not updated the variable uh again having the same value I'm not sure about
28:14
it no it's saying the same values if I repat
28:31
it's coming here 1 two three oh I don't know why it's
28:50
sticking say okay I will check this point and we'll come back to this point later so we are done with this yeah mhm yeah
29:08
correct huh H that's that's the benefit of schedule
29:24
integration parameters so in schedule integration so what we are going to do so for example here in the parameters we pass the date right and we run the integration so what we are going to do we are going to update the schedule parameters before ending the integration for example this is our integration and
29:41
here like for that I I have to explain the assign so I I didn't tell you the assign right now so I will come later right so what I will do this is our parameters right so the first message and second message so when I will update the variable of value of this first
29:58
parameters or second parameters here in the integration so next time when this integration will be executed it will get the same value whatever value we exe we updated here so that's the second benefit of schedule parameters that when you will run the integration again next time or when that integration will
30:14
automatically Run next time so whatever last value available for that parameters it will be there in that one so for example we run the integration today morning and last time when we run the integration yesterday so it was dat as 13 so when we run the integration
30:30
yesterday 13 and when this integration is going to run today right so the variable will store values as 13 again today integration will be executed with 13 values as a parameters we call the BP report it will perform all the operations and before ending the
30:46
integration what I will we will do we will update the variable value to 13 to today date that is 14 so again when this integration will run tomorrow it will get the values as 14 so that that kind of things are there with the parameters schedule
31:04
parameters okay so now we are uh yeah H that can be but it should not be like in in last time when I ran in generation through and that the last testing and all so it was not there so
31:20
just for testing purpose when we are running it's showing the same value just by taking from the C and whatever we had so when we run this when we will schedule the integration it will pick the same values because same value we we provided over there right so it should like every time when we are removing the
31:36
value it should pick the default value whatever is there in that one so this time what we observe when we are running this integration so if we are not providing any value here sorry okay let me run this
31:52
integration show that one H exactly yeah they they pick the previous value which should not be the
32:07
case right so they should not pick the previous value they should pick the previous value only when we updated from the integration and obvious like when we are running integration on adog basis so it's displaying just because that we provided the value here right so here you can see it's taking the same value
32:22
so what's happening when we are removing this value so instead of taking the value from default right so when we don't have value right that's the reason of we having the default concept it means that when we are not providing any value so whatever value default we set to the variable it should pass so here
32:38
we don't have any default value it should pass blank here we pass the default value so as the current values is null so it should pass the this message but this is not happening here so that I will I will check and I will come back so
33:00
uh but it's also not like yeah it's not doing like that also right so right now you I deactivated the integration and I activated the integration again so when I activated the integration so it should be phase value for this right so but again I'm able to see the same
33:17
value so yeah we'll see that the reason behind that yeah uh correct correct it seems that it's taking the last run value whatever we are passing to that
33:33
variable yeah we'll come to that too so now here we we done with creating the schedule integration where we added the variables so even it's not that shedule parameters we are using to display the log messages and all so with the schedule parameters one real example
33:49
that which we discussed right for invoking the VIP report for master data or for the time like records for getting data from every day and all so we can use that schedule parameters but after that like we can do perform operations and all like even we can pass that
34:05
integration code to that schedule integration and based on that code we can get the data from lookups and all in upcoming session we will cover that too right so if if we will go and learn that about the assign and all so we can do one thing let's create one more variable
34:21
one more integration so here you can see for creating the integration let me click here also again yeah uh can you come
34:40
again uh in SLE it's mandatory only that we have to pass the value but we don't have such concept that we can make it fixed to provide the value you can see right we we have not provided any value we remove the value so that's why they given the concept of uh that default
34:56
right so it's mandatory to provide the value while creating the variable the parameters variable that it should be any default values or whatever values you you want to provide but uh while running the integration it's not like that but yes we can add the conditions in integration that if that schedule
35:13
parameters having null values we we are not going to proceed further just by adding the switch condition and all yeah so here yeah uh
35:28
uh yes we can perform uh while running the integration like obious when we provided the default value so if we will not provide the value it will take from default value only but some some different things we
35:44
are able to see here right now right so we'll check on that we'll come back once I will do this r& what kind of things out there so we created new integration with the code AS 004 so here you can see again we we don't have any end point except that
36:00
schedule and add start so what I will do I will just add two parameters here again and this time what I will do I will use parameters as number one and number two so P num one and I will use another values as
36:16
pcore num two so these two parameters variable we created and we didn't provided any value so by default it's it's something like that single quod which means empty value right this is dual quotes or you guys single quotes Yeah Yeah by default data type is a
36:32
string you cannot have you don't have option to change the data type here so while creating the variable we have option but in the schedule integration by default data type is a string only and the maximum character is 256 character so this two variable we
36:47
created and we want that user will provide the value to this two variable and whatever value user will provide we want to add a sum of some some of that values right and we want to store that some of that value somewhere in our variable right you know about the variable variable is something that
37:03
runtime entity where we can store our values so in OIC to create variable we have assign ation so you can see this is the assign ation right this assign xtion will help us to store a value the it can be that the calculation values or it can
37:19
be any fixed values and all so for adding the assign to this our canvas the first option is we will select the action and and we will direct the action here and until that we will get that plus icon so that we can place that assign here so we added the assign
37:36
here so now when we added the assign here obvious it's first asking that the endpoint name so I will just the endpoint name as assign one to the assign underscore sum assign is our endpoint name and sum is the action
37:53
which the which uh this end point is going to perform to store the sum values and all right so now here we have to so for creating the variable in OIC here you just have to click on this plus icon so while creating variable using assign
38:10
we have two option that we can create variable as a string and another one is fault so this fault is something like the error message so when we are generating runtime error in OIC that error we can store in a variable that variable will be known as fault variable
38:26
so generally we are creating that a string type variable only and that a string type variable in OIC can store a string value and also it can store numeric values right so here I have to give the variable name so just like while creating the parameters schedule
38:42
parameters variable we are providing the variable name here we have to provide the variable name so using assign you can perform two action using assign you can create variable and using assign you can update the variables value of that
38:57
variables so right now we don't have any variable created right created by assign so you just can create new variables even you can see when we selected here right we are able to see the value that P num one p num2 these two are the variable and
39:13
these two tracking by two tracking by two three these two are the the tracking variable so tracking variable which we are able to see while the adding the business identifier so if you want to update the value of this variable p number 1 and pm2 you can use a sign but
39:29
right now this time we want to create variable so I will create one variable and I will give the variable name as where underscore this variable is going to store the addition of number sum of numberers so I will use sum so this is our variable V sum and
39:46
that variable what we are going to do so this variable is going to hold the value what kind of value they are going to hold so we want to add the sum of these two number right so I will drag this number here and I will use plus so here you can see when we drag the variable
40:01
that variable added here but we are not able to type anything I'm not able to type anything why because this is fixed we we provided the mapping and that got selected so now we have to open this box in edit mode open the box in edit mode
40:16
here we have the developer option that is the setting option so once you will click here this will be in edit mode and you can see earlier when we will click here you can see this is the fix variable pcore number one we don't have sign dollar sign here so once you will click here you will be able to see the
40:33
dollar sign and when you are able to see the dollar sign with the variable dollar C you simply can understand this is variable and this variable is in edit mode so now here you can see P1 plus P2 that is you can drag here so and once you will click here
40:50
this will be fixed you can see p num 1 plus P num 2 so click here so even you can see the operation here where where sum is equals to P num plus P2 it means that this assigned sum and point will create one variable name as Vore sum and
41:07
that variable will store the value of addition of these two number P num 1 plus P num 2 just click outside now with the help of a sign we created one variable that variable is going to store the value of this these
41:22
two sum of these two parameters now we want to display the value of this variable so again just to display the value of this variable what we can do we can use the logger here so we drag loger
41:41
here and once we will drag the loger I will direct the variable here to display so variable is fair sum so I will direct the variable here V sum so it will display the value available
41:56
inside this where some variable so just click outside so in log if you will see we simply just whatever value that variable is store a variable holds we display the value right but in OIC OIC given you predefine functions using with that
42:14
functions you can manipulate data or you can perform some other action too so OIC provided one one uh functions that functions known as concat that concate function is going going to help you to conate two values
42:30
so the two values is we want to display something like that sum of two number is and we want to display the this variables Su so for example sum of these two number is 15 so we want to display message like that sum of two number is 15 so here you can see there is two kind
42:47
of two types of value the first type of value this is hardcoded values or that is fixed values which value is not going to change and the second value is the value able values or dynamic values that 15 will change at run time when we will provide this value two different values
43:03
to these two variable the value will be changed to display or to merge two different types of value in OIC we have functions known as conet so here you can see this is our source side so once you will click here in the functions you
43:19
will be able to see various functions available here you don't need to worry about that all these functions day by day we will create integration we will learn that functions day by day right so that you just have to search here con c n
43:34
ca2 concate is like concatination right so this concate function you have just have to drag this concate function here so we are not able to drag functions here just because this is not in edit mode to open this one in edit mode you just have to click here so now this is
43:51
in edit mode so what I will do I will just take a cut here I will directag this functions here you can see that FN FN is the node and this is the function conate and this functions take multiple parameters and whatever parameters value
44:08
we will pass it will concate or it will merge all the value it will display together so first value what we have the first value we had that this is the fixed value so in OIC a string value will be available in single quotes or dual quotes whatever
44:25
you want to use so I just want to use single quotes only that's why I given single quotes before s and the single quotes after 15 so this 15 value will be at run time right so I will remove this one so the our fixed value will be sum of two number is hyon I want to give and
44:40
then we want to display the value available in the variable you can click on this input source and the variable value is store inside this V some variable so here we have to provide the comma so comma will say that this is the first value after the comma whatever
44:57
will be there that will be the second value so I will drag this ver sum here so what it will be sum of two number is at a run time it will fetch the value available inside this variable and it will display so how I added this some variable here so what you can do you can
45:13
just move your control wherever you want to add so you can see how my control is before this bracket end of the bracket and I will drag this function here so once I will drag this variable here so you can see that value added so the value added what it's added after the bracket so I will just go delete the
45:30
bracket here and I will add the bracket here so now our function is done so once you will click here you can see the FN and nodes is removed because it's in View mode only and you can see the concrete sum of two number is hyphone
45:45
veram so whatever value will be for this ver at one time it will display that one so just I will click outside so here you can see this is second loger 2 so instead of loger two I want to just
46:01
change the name to this end point and I will give the name of this end point is logger withd will not store the space logger and store withd variable value so this is our
46:19
logger name or that the and point name logger with variable values just click outside so now it's done so so we know that like each and every integration need at least one business identifier so I will just click on this here I will add the business identifier so I will
46:35
add the primary business identifier as a p variable one and the secondary business identifier as variable two so now we added just I will click outside so integration change to configure and and save the status I will click on Save integration will be in configure status
46:51
I will go back and I will activate this integration
47:10
so once we activated the integration so integration is in activity status right now so we have to run this integration right so just click on three dot click on run and here you can see we have these two variable so the P num and P2 so P2
47:27
let me pass 20 and P1 I'm just p number one I will pass 10 so once I will click on this run so this two value will be passed to that integration and integration will perform the operation based on that value we
47:44
provided here you can see the message received by assignment assign underscore sum so this is the the endpoint name we given to the assign activity or assign action and the arrow said that once you will click you will be able to see few
48:00
values here so once we open here you can see we are able to the see the value that variable variable name that Vore sum was assigned with 30 so why this variable assigned with 30 because we added the addition operation that is P1 that is 10 + 20 is 30 so it store
48:17
created variable with the name as vcore sum and that variable will assign with the value as 2 so now in the first bler we display the same value so it will display 30 here 30 and in the second logger we given the name as logger underscore with variable value so this
48:34
is the logger name or the uh the endpoint name we given and once you will click on this I icon you will be able to see the value sum of two number is hph 30 so instead of 30 if we will pass 100 here so it will be 100 + 20 it will be
48:49
120 so I will click on here so here you can
49:04
see we are able to see the value sum of two number is 120 so now here you can see we passed two values right at run time we passed the two values if you want to add one more values two more values we can add
49:20
right seded integration allow us to pass up to five parameters value right that will be fine but some sometimes we want to pass more than five values and all it's not possible in even schedule integration to pass more than one value then what we can do in that case we will
49:36
have option of ab driven integration so instead of adding the parameters in AB driven integration we can add the request Bel and we can pass all these values in Json format to as a request to that abent integration so we we will learn that too
49:52
in upcoming session so here you can see yeah so uh so yes so this is inv valid value so if you are passing so it's considered as a invalid values n a and something it's
50:08
it's displaying right so while in our integration we can handle that situation too so whenever we are doing any calculation any operations so we can check that values having numeric values and all so in OIC we don't have such functions which can verify that value is
50:25
alpha numeric or numeric value right so that's why to solve that kind of situation you can create one JavaScript function that you can align JavaScript function to that library and then you can use the JavaScript function in OIC that in JavaScript function you will
50:42
pass this value and this the function will return you true or false and based on that you can identify that value is alpha numeric or numeric so that's can be the simple test cases for using the uh the the libraries and Javas SCP Cod
50:58
so yeah huh yeah correct so it's it's O default functionality is that when it is considering as a numeric value it's number values it's automatically
51:14
considered as a number and doing operations so if we want to make this as a a string so what we can do we have to just use single codes so here we can use single codes or in OIC inside that OIC mapper only we can make it as a single quotes or we can just pass that using
51:30
the string functions and all so that this number value can be considered as a stream yeah huh correct
51:49
correct no it will not stop no for while entering here it will not stop because here we are not going to add any value ations right so what we can do in OIC it will pass the value it will pass this two value in OIC and before doing the calculation here where we are doing
52:05
operation our we are doing operation at this point right this point no this point right in this point we are doing our operations or calculation and all so before executing this line right this line we can add our condition here and we will pass this value to JavaScript
52:20
function and once that function will return true then only we can perform these operations if it will not return true then we will es skip this operation and we can display message like invalid values and all so that kind of things yes we can we can do so that's why we have switch in OIC that switch is
52:38
something that provide you flexibility to add the if conditions in OIC So based on that yeah corre then only you can perform the
52:53
Excel so that kind of things we have and we can do yeah and uh yeah yeah yeah correct so now this Integra huh
53:08
correct huh correct correct let so while creating this integration we added the identifier business identifier and in that identifier obviously the variable we are using that variable is known as tracking variable so there are three max
53:25
to Max tracking variable we can one is primary and two is non- primary or something like we can escape that one but one is mandatory that's why the first the one or the first winess identifier or the tracking variable we added that's known as primary identifier to check that one so once you will back
53:42
go back to the design you have one option for observ vality and that is known as the monitoring in that integation flow in the monitoring you can see here we have instance so in the monitoring we have one instance here and another we have integration so once you
53:58
will click on this integration so all the integration available instance that available in this OIC and which is executed you will be able to see that integration and you will be able to see the status of that integration so you can see the this 04 we executed four
54:15
times and all four times is got succeeded we are able to see here so we have not created any integration yet which got an error right so in upcoming days we will create that got an error and we will hand that error by using a scope and all so for checking the
54:31
activity or or status of all this integration you just click here in the success this is the hyperlink right so once you will click here so all the integration which it run it will display here right and remember we added two business identifier one business
54:48
identifier consider as a primary and another it's a simple business identifier so you can see if you remember pcore num One V as added as a primary business identifier so here you can see that's why it's displaying here right you can see p and is 10 100 100 we
55:05
passed right next time we pass 20 20 and the invalid values so all these are displaying here but what is the use of this one right so the wor purpose of using this one so that here you can see if I will remove the filter right you will see lots of integration running
55:21
here you can see right many integration executed and all the integration log method you will see here and if you want to search your integration by the value the value you provided in the identify you can search here so I will search here by passing 100 in single quotes So
55:38
when you will execute so whatever value you passed here you will be able to see you can see your integration by default filtered based on the value you passed here that's the primary business identifier so we are using that business
55:53
identifier to find the message so the one purpose just to filter your integration for debugging purpose to checking the log messages another benefit of that one is to display or to check the message before looking for the
56:08
integration that what kind of value you pass for that primary business identify so here you can see we pass 100 for that this integration run when we run integration last time we passed 100 so that kind of things we can perform using that business identifier
56:30
yeah so here you see right so where once it's showing here it's primary even you can see in the name also right the primary one and this is the secondary buiness identifier so if we will add yeah now the by default so let me go add
56:46
one more parameters here so when we are adding the identifier or when we are adding the the business identif it's at the time only so it fixed that whenever we will add the parameters by default it will
57:01
consider first variable as a paramet only you can see the tick message right so let me add the third parameters and third parameters they didn't allow to use the same variable so let me add the time as a third parameters so this is the third variable
57:18
so I will give the name as third ID and this is the second so instead of P to so for example while running this sedule integration you pass the current date right so you can use or you can give the name here as current
57:34
date current date something so that when you your integration will be executed you can search your integration values based on this current dat variable or the value passed to the current dat So based on that you can even change the name so right now our integration having three parameters or three business
57:50
identify sorry so let me save this integration then we go back run this integration
58:07
again so I'm just going to WR this introducing passing the values as 23 + 56 I will go back
58:24
observation inst sounds so once you will see here it's showing all the messages right so you can see in our recent integration we had total three identifier so this is the first identifier this is the second identifier
58:40
which name as current underscore dat it was date and this is the third identifier we added so all these we are able to see here and the in the third variable we map with the start date start date of the integration when it executed so you can see this is the start date
58:59
so that all values we are able to see here even in the monitoring on we have various things we have error part we have that the integration where you will be able to that like we saw that right how many Integrations are there Inc completed success error on a specific if
59:16
you want to see the instance all the instance of any specific Integrations right that Integrations executed five times right so you will click here all the five instance log you will be able to find in a single hit only in a single times and just because here you can see
59:32
when we click on this hyperlinks it's automatically added the filter added the filter as integration name and their sort code the integration identifier and their version So based on that they already added the filter here so if you will remove filter even you can search
59:47
with the values you added so you can see this is the current time having 23 values if you will pass 23 here it will display the value you can see it will display the integration which having the dis identifier value is
00:08
23 so that you can track your integration so like I think it's uh we are already done so the next part we have to create absor integration so before creating the absor integration we
00:23
have to just go through about the adapters and then using that adapters we are going to create connection and that connection we are going to use in AB driven integration so all this uh we will cover in that next upcoming sessions so so I'm going to make it
00:39
remain for the next one so thank you so much everyone for joining the session and yes if you have any queries and you want to ask anything feel free to unmute yourself and ask your question