[Music] hi all and welcome back to another video in today's video or we call it this tutorial we'll be exploring a new option that is integration hub for importing data access okay so most of the people uh most of the people over here must be familiar about whenever it comes to imported data okay we think of import sets data load then import set then transform map once the transform map runs then we have to do the mapping on the transfer map and so on okay but using integration of this experience is pretty easy okay and uh let's let's try to explore it out so the use case for today is like he will be importing a data from an accent okay to a csu's a table so let's first try to see the count of this user so if i go here and to the csuser.list so we have currently how many users we have 620 users okay and on the 620 users if i start with that okay so i don't have any users with uh whose initials are getting started with that okay so i've exported a data i've created an excel okay if i go here and it success user excel if i want to showcase and we'll be importing the data using this exercise okay so we have to use these two users okay and we'll be importing this data using integration hub so for people who think integration hub is difficult this is a tutorial for you so i go over here and now if i go to the home page okay let's try let's try the integration up so i will type integration integration hub import so you can see this option so if i click on this option it will open a next experience okay and this is really beautiful hi system administrator if you are logged in as amit gujarati then it will show hi i'm welcome to integration of let's create a data import integration okay there is nothing right now okay because we are exploring this option for the first time so let's create a new integration so we will give the integration name so we'll give import users let's give a short description okay import users from cell to says here's a table or something or you can define all your own factors okay then application is asking us to select the application let's keep it in the global application only and just go save and continue once it goes on save and continue okay here you can see the guided setup okay so the first thing is source configuration the second one is map target and the third is the scheduling port so let's go with the source configuration so in the source type if we go we can see file and in file there is excel so in the future service now we'll be adding few more options to this okay but currently we have only excel options okay so let's continue to export this option using excel only so i will just zoom out a little bit so it will now it ask you to upload file so let's upload the file so i will go i will go to the desktop i will go to says user excel boom so now the excel got imported okay now you can see the configuration with sheet number so if you have multiple sheets okay so you can define sheet numbers if you have headers defined at row number two three four so so you can define that configurations also but for me it has a default configurations okay so i don't want to do anything now here you can see source data structure there is nothing over here right so what you have to do you have you can see this button load source data structure click on this so what this will do it will read through the entire excel and it will detect all the fields as a part of the excel okay so here you can see we have all the pages okay string string strings mixing and it has red through all the fields okay which have the which are present on the excel sheet pretty amazing right so you don't have to create import sets and other things unless you have there is in this also imports are getting created if you have this question in your mind then how exactly it will happen so import set will definitely get created but it's not exposed to you it's encapsulated you can say so you don't have to worry about that so if you go over here now we can see the source configuration step is completed now there is no next button this is pretty sad for me okay so you have to click manually on this map to target say map to target you have to add a mapping okay so where exactly we have to map this data out so you can click on add mapping and you can type the target table over here so for us it will be says underscore user table because we want to add the data to this table not sir table let's see user sorry my bad hmm says user table where it says users this is this is this is here this this user typing and now you can see the two check boxes okay there is a significance of this checkbox the first checkbox talks about run tables business rule by importing so what this does whenever we are importing the data what all will be the on before or on update also on before insert and after insert business rule whatever we have defined on this issue table will get executed so there is a possibility that you have defined certain validation before importing the record so you can check this checkbox if you want to have some refined data do if you are doing some refining or in the business rule or you are performing certain action like for example if i want to talk about on after business rule that uh if a user record is created you want to notify certain group out using notification then you can have this checked okay i'll uncheck it out let's move to the next one which is run the inputs synchronously so this is really dangerous option i don't prefer this so what how exactly it works whenever we import the data the data will not be so let us okay so currently we are holding on two records but whenever we are importing data it will be in lags or it will lags in 10 lakhs right so we don't want to import this create the records synchronously okay because it will impact the performance of the system okay so every time whenever we are doing the batch activity it should be a synchronous one but in some cases we want the data to be a synchronous and not a synchronous one okay synchronous space immediately okay then we can check the checkbox and then everything will happen synchronously okay so i will uncheck both the checkbox because i don't think it's often used to me and i will save okay as soon as i save it out now what it started doing is like it started pulling the data from the source table which is the imports that table created at the back end the target table and now it's is it's if we click on this now we can see the mapping so here this is the part which i don't like about this okay so basically how exactly it's used to work in the transform map we had to try mapping assistant and once we click on the mapping assistant uh it will use the auto mapping map that fades out or there will be there there used to be a sludge bucket and we have to just map map the things okay using the sludge buckets only right but here one advantage is like you can see the data type of the field or the target instance okay and how the mapping needs to done so first of all if i want to uh map name okay so how i used to do you have to drag and drop over here like this and it should work like this name okay in the similar way you can uh map other phase okay without so i will map name i will map what what all else i want to map where is active active active active and over here is active not avatar active so i will map active then what else when is updated so if i go here update it updated updated update i'll not map all the feeds okay i'm just trying to map few face so i don't see the system different user id this is interesting so guys user id oh this is really mess i don't i really don't like this so the first time i think i selected something wrong it should be this first name then whatever searching user id exactly come on user id i got it user id over here everywhere exactly the user id over here user id travel map user id and here some people will ask okay key how the transfer script takes place over here and how exactly it works so basically you can see it's it's moving on to no code okay low code or nokia kind of things so if you click on the function icon so it gives you a lot of options over here so for example it's a string field so they have two two transformations over string fill and time data type and i really like this thing so in string i always face the issue that whenever i get a string in the excel sheet so it will have some white white space with it right so you can simply trim it out okay in order to remove the white spaces from there so i have added the trim so what it will do it will remove the white spaces with attached with the string okay in the similar way you can show the date time field also so for example if i want to showcase uh let's let's take some date time field which daytime field i want to take oh my god this really hectic service now should give some sorting orders for this so that it will be pretty easy for us to map the fades out but like this though so for example if you have certain date field okay so for example if this is this is already there so for example if if you have a certain date field then you have the date field so for example this is the most convenient way that uh and i've faced this couple of times that in excel sheet we are getting the data from under the source so that particular another source will be following some different data form date format and we have to convert it internally to set it to our servicenow standards or servicenow format so you can do this y using this particular property but for now i will not explore this out so i will have only this face for now in the similar way you can map other fields if you want okay and i will save so once this mapping is saved okay the next step is this is like you can consider relate this with the transform map mapping okay so this is saved and now you can see the check box so map to target is also done now the third option is schedule import so here you can run the import if you click on the run import it will execute the entire transaction okay and it will go via the transform map or mapping things which we have created in the previous step and it will go through it okay and import the data to the system or you can schedule out also how to schedule it out so you can see the schedule and import option so if i click on this i can define the schedule name okay and data source when exactly i want to run periodically and all the things of the schedule import okay pretty pretty convincing for me i will not explain this option but if you want to schedule data import from excel so you can do it via this okay so for now we'll be running an import so before that we'll check the user count so we have how many users who we have 620 user so we'll be importing two users out if i do run import so now it's importing okay so you can see the run import is submitted successfully and the execution is going on i think so so execution is going on and here you can see the refresh list button so now if i refresh the list out i can see my execution over here so if i click on the execution summary okay if i open this out so what i can see two rows imported pretty amazing right this looks really good you can see how much time load time it required what is the status import time updated okay how many got skipped how many got pending two rows got imported okay how many got process if there is any error that thing each and every minor detail you will get over you okay if there are some import logs input errors you can find everything at one place okay but for us i think everything is successful okay for now let's try to verify the same oh yeah so it's 620 if i refresh it out so now it's 622 and if i just to verify that if i type that so you can see the two users which you have imported got imported in the system isn't it amazing i hope servicenow will give this provision just like a data source okay to import the data nor from the excel but from other things also like excel csv then data sources then from from https sources okay all these things in the future okay because i really like this thing okay so this is all for today's tutorial hope you really like this out the integration data input using integration hub okay and you will stop using the conventional method which we are using using the transform map or not so this is all for today's tutorial hope you like this thing okay hope you like the integration hub hope you will upgrade you to use us to start using the integration hub okay after seeing this video and thank you for watching this out please like follow subscribe to my channel to get the latest update on my upcoming videos until then stay safe stay happy and have a nice day thank you