welcome to surface now integration Hub sap Ariba spoke demo today I'm going to show you how to create a new record and also look up a new record between servicenow and Ariba now all the information I'm going to upload under the fdih public group in the SharePoint under this directory so uh if your SC or marketing or any internal employee of servicenow you're able to go to this website or the SharePoint or to get a relevant information to demo your on this Rebus book to your prospect customers or Partners or whatnot and let me give you some introduction of Oliver so Ariba is one of the you know original procurement catalog items um that kind of software to begin with uh it was before the cloud days and they're mostly on-premise software to begin with but later on there's a cloud movement starting to get adoption that are Reba also move into Cloud but as you know as one of the original um really kind of influential software beforehand um they didn't really have like rest or sub or or anything like that before just like how the the old Cloud company used to have they mostly communicate using a file format to communicate or integrate between third-party systems and right now as Ariba is slowly gonna adopting and moving more from the file driven integration format into more soap and rest format afterwards but because of the Legacy and historical reason of the Ariba technology even today most of the integration is actually done through a file which is linked was CSV format comma delimited value format file transformation basically that's what it is between aliba and surface now in this case and to double click onto this point uh so here on some of the major protocols and this one will be what most of the Ariba sport is going to focus on coupled with some of the soap API call and a little bit of rest API call now the purpose of this spoke is to have a framework or the design pattern so that the customer can easily leverage on top of this design pattern and build their own kind of actions and Integrations based on the spoke itself and this book provides a good handful of um you know examples or design pattern among the file format the sub format a little bit of rest format so that the customer can easily mimic and extend the spoke on now scrolling down into um the different options of a Reba so as you can see Ariba has many different integration points uh 200 plus of those and if you are actually looking at these 230 Ariba apis majority of them are actually in the file format as I stated before a handful of them are still in soap API format this is a little bit of rest format and because of how arriba are going to expose the apis that way in a file format then from our integration Hub perspective we're gonna respect that and do the similar thing to wrap around these files CSV format to integrate between surface now and the Reba now from the spoke perspective we this is the technical specs of the Rebus book out of the box you can see uh um we are coming out of a quite a handful of the actions but it's not comprehensive I'm going to show you more than just this okay on a we have some um actions which retrieve invoices and itk meaning the file export and file import now what's the difference between export and input and what perspective is in so today uh for the V1 version export is meaning uh we are getting information from Ariba back to servicenow so export meaning is from the perspective of a reader are they pushing things from Ariba back to service now which means now from the servicenow perspective we are getting and look up things from Ariba into servicenow import meaning creating from servicenow back to Ariba again it is later from the perspective of aliba so importing means hey I want to get something into Ariba so that what that's why it's called importing I know the name convention is a little bit confusing uh we're gonna looking for an upgrade of the naming con naming convention consistency uh in the future uh but in the meantime for this version bear with it um export meaning lookup from servicenow uh looking up things from our leader in the import meaning service now pushing or creating something from servicenow to Ariba okay and then we have three samples of a soap API so which is the create suppliers uh sourcing project and also updating the sourcing project right there okay now in terms of um getting things let's talk about creating things from servicenow into Ariba so first of all we want to create a record in servicenow and then and then we want to wrap around and we fly the zip file and then we're gonna push it into um into Ariba and that one is using a utilities book so we're gonna find a record in service now and zip it up and push it into a Reba and that's for creating a new record from a servicenow into our Reba now getting a new record or a record from Ariba back to servicenow similar things uh first we're gonna be um extracting the the list of records from Ariba back to service now as a data source and then using a transform map we're going to push it into some custom table per your choice right per your customer requirements uh that can be some base table um that needs to be mapped into but essentially on the importing or getting things from Ariba will be following the traditional data source import set with a transform map and do some correlates and uh you know Auto mapping or identify the unique records so that you won't copy any duplication from the data source into the target tables which is the paste base table uh performed by the customer operator requirements right there so again create will be servicenow a custom record uh wrap around it with a zip file and then push it into Ariba and then if you are getting things from Ariba that will be getting the the information from Ariba into the data source and data source using the traditional method uh we'll do the transform app and then push it into the base table right there now the next thing you'll be wondering hey what kind of like a schema I should not expect or career my record with to push things or pull things from uh you know from the between back and forth of servicenow and Ariba so right now we have something called a data dictionary a data dictionary is the definition of the schema that is expected between servicenow and Ariba and what you can do is like basically you can download this easily from Ariba if your customer have a Ariba instance this is a Reba instance right here all they have to do is to go to manage Administration and then under the integration manager this is a Theta definition and then you download a data dictionary right here so the data dictionary will consist for the schema okay what columns it is expected for each CSV file for the different kind of data that is expected or for example uh like export suppliers users currency hey what kind of column it is uh they are and then what kind of like data types expected and then from that one then you can transcribe accordingly into the servicenow record and then you will uh and you enter the data right there and zip it up and then push it into um aliba afterwards and it's similarly importing uh your import back as like a spreadsheet spider a CSV file and then from a CSV file you're doing the usual transform app and then input back into servicenow that way I'm going to show you more uh as we dive into the demo okay so first of all let me show you how to create a record from servicenow to Ariba okay a rebar so um the scenario I'm gonna gonna provide you today is to create a new supplier from servicenow into Ariba for the example right here we create some easy to access uh you know application redirect right here uh but essentially under under the hood you're creating a new custom record uh and a custom record schema will be based on a data dictionary provided from Ariba and we're gonna we are going to create a new supplier organizations for the sourcing module of Ariba as you can see uh right here already created one sample before I'm gonna modify this existing record to save some time but uh you may ask hey so this is out of the box right what if the customer wants to you know create a another scenario or another record into um you know from servicenow into Ariba what you need to do is to actually go to the table and then go to the table definition in this case you're doing to supplier well now let's say in the future you want to do uh uh like on currency or po order you want to create Po from servicenow into a label then all you have to do is create a new table schema per the data dictionary that is provided from Ariba and then you create those columns and then data types accordingly uh into this table and then you will um you will populate these table values and then you can do the usual zipping and then push it into aliba afterwards okay but in terms of time let me show you the existing sourcing table that we have so we have the table columns uh this one's out of the box for you so you can learn from the design pattern an approach that we do but how to create a new or establishing or defining a new table uh per the data definition uh we can open up the data dictionary right here A supplier that will be the um export supplier organization CSV and then you can see in column e right here of the data on data dictionary you can see the bunch of columns that are needed by Reba and these one will be the columns that will be understandable by Ariba period of file definition and you can also see hey what will be the data types or data or the string length and all these things so essentially you just like need to follow the schema of this data dictionary and then you will create the same thing into these table columns right here now once they are in sync then you can further populate the information of this table and then you can um create the integration between servicenow and our reader now as you can see we already have some table definition right here and then further exposed in this Ariba application we're gonna create a new supplier from here so I'm just saying UK supplier 2. do the same thing to right here blah okay so mostly it and then nothing um you can do some unique number right here just in case okay so there you go now I've created Like A supplier number two right here update it now the next thing let me go and show you the execution flow so the one that we're gonna integrate between surface now and Ariba is this sample flow what it does is um basically we create a table record in servicenow and for this flow it's going to show you a design pattern hey how can I exhibit it wrap around and then push it into a Reba so first to begin a file or this part of the utility spoke when you install this Smoky will automatically comes with it as a dependency file or dependency spoke so you should have the utility spot out of the box when you install this already possible as well and what happened is you look up the supplier Source record which in this case that's the custom table that we do that we uh that I showed you beforehand and then of course you can create multiple entries of this um of this uh table if each item you just a plan that into the CSV file build the file and then uh you couple with some other um another sourcing file then you begin zip it up and then send it into Ariba afterwards okay by the way I believe um I believe I this one also needs an ID right there so let me also modify this one real quick um it's actually the unique identifier right here good look at the sample flow otherwise I may miss that as well um so what it is is like of to in order to create a new supplier first you have to supply um you have to define the supplier ID and then also the supply organizations uh which is like the the child elements right there um so then you can actually do the whole end to end um creation of the supplier in this case so let me do a test so now if um among the successful creation then you should see a completion of this creation and then you will see the the new supplier number two in Ariba uh instant itself so yeah let's give it a shot so what he does behind the scene where it's going to wrap up the supplier ID record right there zip it up and then I mean begin a file we have a file Creator CSV file created then you also further um wrap up the the supplier actual data and then also create a file of it and then the last thing is to zip it up and then send it into Ariba now let's see the execution record right here it's all completed awesome successful build a successful so it looks like everything is good so now let's see in Ariba if the supplier is actually coming over so now we are in Ariba environment and then let's click on supplier management foreign supplier nope not one I want two it takes a while to be flat yup there you go it takes about two minutes flag before he actually um show up let's see yup creation date March 2021 all the information maybe it takes still take a while to reflect all the information but it shows the integration is successful coming into it refresh it again do it one more time tax information postal address yep so these all coming over and this is the unique generated number right here cool so now this is the creation from my Surface now to Ariba now the next thing is to uh you know get back the list of things from Aruba back to servicenow and what happened is it is is to um going into the import route I'll be in the export route in this case from a Reba back to um service now and all you have to do is um do drag and drop two things and if they if a daily schedule as well since you're going through the traditional data source transform map and base table that kind of approach uh we're gonna do first uh execute Ariba export task and for this one you can choose the list of um CSV files that are going to be uh imported I mean exported now from Ariba to um servicenow which is getting things from Ariba and out of the box we have this we have several um definition already um predefined for you uh which makes Slide the whole integration much easier and if I go back into um this thing right here that would be the export definition right here and of course you can add new things per your customer requirements right here and uh it's also per the data dictionary or what kind of task value name would that be and then zip on zip and those will be all provided from like a data dictionary right here okay and that's the task name so you you may want to copy and paste exact name right here put it right here and then when you trigger the integration you look up the the right task name accordingly or in Arriva and then get the list of values from Ariba back to our servicenow okay so now the next thing is about copying the river file into a data source so in this case you have to predefine a CSV data source right here which is a file format data source and all you have to do is to go back to the servicenow platform the data source in data sources then you can create new data source and then you define hey this is actually the file attachment right here then a CSV diminitator will be a comma right here and then you will Define your name right here as well and let me show you a existing data source so this is the data source that we have okay another next thing is let's give a shot pulling back the data from Ariba into servicenow so now it's kicking off the process it would take a while yep got something right there you can pull it so with this you can go into the record itself and then you can see now two new files has come back now if you go into the file it's easier always our friend see look at this much easier scroll all the way down two down for me hold on we have a bunch of data right here and you can supplier too that's the one that we have two seven eight and all these things right here so uh now we have um the information that we need but then um this is just the beginning uh the data source uh of course you have to predefine a data map and then you will transform into the base table what you need for your customer requirements but like this is the beginning right here uh what you can do is further enter it create a transform app and then yeah push it into the the base table afterwards so that is the overall of this Ariba functionality uh between creating and getting things from Ariba and let me see any other things I want to show you today that's about it so yeah if you have any questions uh let me know my name is Edwin Kwan and I'm on top on the product manager in the integration Hub team so email me I'm glad to help you on any of the customer engagement thank you