- About Us
- News and Events
- Contact Us
Enterprise IT environments are complex and rapidly changing. Are you seeking low complexity Integration solutions to allow your Enterprise applications to talk to each other in agile fashion in either the cloud or on-premise solutions? For example, Oracle Applications to Salesforce.com, Oracle E-Business Suite to B2B, or leveraging technology adaptors for SOAP, JSP, REST, etc., to SaaS solutions. Centroid, an Oracle Cloud Select and Platinum Partner, will show you in this workshop how easy it is to leverage a $300 free trial on Oracle Cloud with Integration Cloud Services to prove out use cases in your specific environment.
Hi. My name is Brian Boyd. I’m a Sales Director at Centroid Systems, an Oracle Cloud Select and Platinum partner. Today, we are going to be doing a workshop overview on Oracle Cloud Infrastructure, also known as OCI, and an overview and demo of Autonomous Integration Cloud Service, also known as AICS. AICS is part of Oracle Cloud PaaS offering.
During the presentation, guests should be on mute. They can mute their phones. Or, if they are in front of their desktop, they can click on the mute button on the side on their entry point. Any question you have, put it into the chat menu into the chat session and we will answer those at the end of the session. I will also be sending out a recording of the meeting to everyone who signed up or attended the meeting today.
With that, I am going to close window a real quick. There we go. Today, we are going to have a few different people speaking. We are going to have: Navdeep Saini, he is a Centroid Cloud Practice Director; Tom Kopec, an Oracle Alliances Consultant; Jude Victor, Centroid Cloud Applications Architect; and Ben Masters, a Centroid Cloud Architect as well.
Today, for our agenda, we are going to do a quick overview on Centroid, who we are, very high level. We are then going to have Navdeep Saini speak about Oracle Cloud Infrastructure introduction foundation, talking about aspects about PaaS and IaaS.
There is someone in the background talking. If you could go on mute, please? There we go. Thank you very much. No problem.
Then, after the SaaS and DaaS part, we are going to hand it to Tom Kopec and he is going to talk about Oracle Autonomous Integration Cloud Service as part of Oracle PaaS. Then, we are going to pass it to Jude and he is going to do an AICS demo on EBS to HCM cloud. Then, also as part of AICS, he is going to do process flow execution and development on there.
The last thing- or second to last thing, we are going to hand it to Ben Masters and he is going to do a Oracle OCI Cloud credit sign up. It takes about three minutes, if you want, to get free Oracle Cloud credits as part of a POC or a proof of value. You can do it very easily. That is up to 300 to 500 dollar value. There is a way to get 500. If you want to just contact me, I am happy to help you out and show you how that works.
Then last thing, about Centroid Consulting Services in the cloud, we will just talk through a few different areas in soft consulting that we can help people out with their cloud trials, doing TCO planning and budgeting around specific projects you have may interest; proof of value engagements that are very common that we run into all the time; and lastly, larger cloud strategy consulting type effort.
Centroid has been a leader in Oracle consulting and managed services since 1997. We use our years of experience and an ingrained mentality to help organizations realize the benefits of running an integrated suite of applications and technology. We are very much focused on people, technology, and business. Our relationships go back 20, 25 years with customers and they come from one customer to another and whatnot. We will talk a little bit about that.
We are very focused on the enterprise of the company. On the left side, here, you see applications, and, at the very bottom, the storage and everything in between. We are sort of unique in the Oracle ecosystem in that we have the ability and consulting teams to execute all these things from ERP and cloud applications, reporting, security, middleware, database, engineered systems, all the way down to the very bottom with servers and storage. We have expertise in all of these areas around managed services, cloud, and consulting.
Just a few quick facts about us. We have been in business since 1997, have over 200 full-time employees in our offices from Dallas, Detroit, San Francisco, and Los Angeles, and also Hyderabad, India. We are a national firm focused on all these different areas that I discussed earlier. We have over 100-plus certifications from Oracle and in multiple specialization areas, from ERP to OB, to technology, et cetera. The other part of our business is we are very focused on long term relationships. A lot of our customers, we start small projects with them and then they grow into much bigger projects over time, from a managed services perspective.
There is someone who is on that it is a little loud, I am going to mute a few more people. So, there we go.
The last thing is, we’re an Oracle Velocity and MSP partner. What does that mean to you? Well, what it effectively means is Velocity is an Oracle program that allows us to accelerate your journey in the cloud. If you have got a project, an initiative, and you are a little bit newer to it, Oracle effectively gives us funds to accelerate your journey and offset your consulting efforts so that we can make sure that it is successful for you. We are also an MSP program partner.
Just from an office’s standpoint real quick, our headquarter is in Detroit, Michigan. We have a second headquarters in Dallas, Texas. We have a large presence in San Francisco and Los Angeles, but we are a nationwide firm. We also have our office in Hyderabad, India for over the sunset support, for DBA support, development support, et cetera.
With that, I am now going to, we are going to talk about OCI as an introduction of Oracle Cloud Infrastructure, and I am going to pass this to Navdeep Saini and he is going to talk through this.
All right. Thanks, Brian, for the nice intro. My name is Nav. I head the cloud team at Centroid. Today, we are going to talk a little bit about OCI, specifically from the underlying infrastructure point of view and why it matters. Right? I know this call is mostly about the PaaS, but PaaS is built on OCI.
Any enterprise looking to move to cloud should be considering a couple of things when trying to buy any services on cloud. Right? Cloud-ready or cloud-able applications we all know started with the cloud move, specifically with the Amazon cloud. They kind of take up the cloud features. But enterprise applications that needs to be run on cloud have some special requirements.
We are going to talk a little bit about OCI, how they have designed it, and why it matters. Lets just get to the points of what are the requirements of enterprise applications if they want to run on cloud.
First of all, of course, it has to be consistent and reliable performance. Right? You can’t have a cloud provider where they have multiple tenants running and then you have issue of noisy neighbor. You want to run your application much like in a cloud environment but not necessarily getting impacted by other big customers coming in and taking up all the compute. That’s very important.
You want security, governance and control because most of the enterprise applications are kind of are guided by those controls if they are running on time. So, the same kind of control has to be there in cloud.
Of course, global availability and redundancy is a must. Any application, an enterprise application running serving multi-million dollar, multi-billion dollar businesses can’t afford downtime. So, global availability is a must, sometimes for compliance reasons. Right? You need to have your data in here for some reason or you need to have your data in a particular geographical region. Your cloud provider, whatever you choose, should have that capability.
It should be able to support all workloads. It shouldn’t be that only can support Linux or just Windows or just containers, if you fall in the journey of containers. It should be able to kind of fund everything that’s available on the cloud platform.
Then, of course, the journey starts with on-premise systems, trying to move to cloud solution. The tools should be there that make the journey easier. Not to forget: not everything moves in clouds on day one. You always will end up with some kind of hybrid architecture where you will still have some resources on-prem, especially if it’s not on-prem, you will need to integrate the third-party providers. So, there should be a capability, a backbone available to do that kind of integration.
Then, of course, this is very unique to OCI Oracle, for some reason if you can’t host your applications in cloud, maybe compliance reasons or kind of data that you’re handling, you should be able to deploy the same stack in your data center and private cloud. That is very important, specifically in enterprise world.
Next slide, please.
The Oracle Public Cloud strategy is basically four pillars. Data-as-a-service, of course, being a data company that’s important. They started with SaaS, software-as-a-service, with their fusion applications and cloud SCM was the first one to be rolled out. They have been rolling out Oracle W service cloud and ERP cloud. They have service-as-an-application offering also, platform-as-a-service, and infrastructure-as-a-service as being recent additions. Those are kind of lower down in the stack that they’ve been offering.
Platform-as-a-service has a lot of offering right now. One of that offering is what we’re going to talk about today in integration cloud service. Of course, all these are built on infrastructure, so infrastructure-as-a-service where you get your compute power, compute storage and networking is offered also.
Let’s talk a little bit about OCI architecture or how the public cloud architecture from Oracle is. Just like any other cloud provider, they have also regions. There are multiple regions available right now. Each region has minimum of three data centers. All the three data centers are independent each other, with their own power and cooling and networking. So, if one day the central falls off, you will still have the other two data centers up and running and that region is still available.
What they have done is these three regions, these three regions, they can be for data center in a region, all these data centers are connected by block fiber with the microsecond, millisecond latency between them. Essentially, you can run your HA architecture, of your applications in a region and leverage these three or four data centers that are available in region.
Once you have these data centers, of course, they have a physical network, now, of course, data center would have a physical office, but what’s so special about it in OCI, as I said, we need reliable performance. They have designed their network in such a way that they are not more than maximum of two hops between two VMs. Let’s say you spin up VMs, and you don’t have a control where the VM is going to spin up because it’s a public cloud, one VM spin up on one end of the data center, another VM spin up on the other end of the data center.
In a traditional data center, there can be multiple hops before your network effectively reaches the other VM. But the way they have designed it, there are not more than two hops between those two VMs, no matter where those VMs are placed on the underlying hardware. In one data center, the design is such that they are millions of network force available and then the virtualization of the network is done in such a way that there is no overhead.
Once you have these physical networks designed the way they want it, what they have done is they’ve also done a virtualization which is a little different from other cloud providers. Not all the cloud providers are also going towards this kind of architecture, specifically on the virtualization of the network such that the virtualization of the network is done by something called bump in a wire. Right? When you do virtualization, there are various ways that you can do it. That’s the reason why we let it handled by the hypervisor. So, there’s overhead on the hypervisor, which means an overhead on the compute, which means you have less compute available to run your VMs and less performance, consequently.
But if you do a virtualization out of the hypervisor and do it on the switches and the cards that are put in the hardware itself, you kind of take away that virtualization. Essentially what they have done is they have created this solid physical backbone of 25 gigs network. Then, out of those 25 gigs, five gig is set aside as a bandwidth for virtualization. So, all your VMs have access to the 20 gig bandwidth. That’s how you virtualize your network.
Now, once you have your network working in this way, what you can do is, of course, you can plug in your hardware and start utilizing it. There are various compute options available in OCI. They came up with bare metal way back three years ago when only one cloud provider had that offering. So, there are bare metals you can run, there are VMs you can run or you can ask for, and then bare metals will have NVMe you can ask for if you want it.
They also can hook up the engineered systems. So, you can have things Exadata on Oracle Cloud. You don’t have to buy the huge machine, you can just have a portion of Exadata and rent it for you, if you want it. Of course, platform-as-a-service and software-as-a-service are also kind of being used.
Next slide, please.
We talked a little bit about the region side. Each region has three data centers, right? So how many regions are we talking about? There are about 12 or 13 regions and all of them will be live by end of 2018. You can see there are things like the choice of deployment and scarcity. If you have a requirement data, data has to reside in a particular region. Especially, as the GDP are coming to the picture, then the Oracle’s regions are making a lot of sense here.
Next slide, please.
I talked a little bit about performance requirement of a public cloud, especially for running enterprise workloads. Before I talk about this slide, let me give you one fact, that Oracle is the only cloud provider that is giving actually on the performance of their network and performance of their storage. What this essentially means is, on the storage side, what they are guaranteeing, they are writing it down and they’re going to pay you back if it doesn’t happen. That one terabyte of a block volume will guarantee 90% of the time give you 25,000 IOPS. If it goes below that 90% of the time, then they’re going to pay you back. No other cloud provider is doing it. Similarly, on the networking side, they are guaranteeing network performance of 20 gigs pipe between the two VMs 90% of the time. The reason they are doing it is because they designed their data center from ground up for running the enterprise applications in cloud.
So, we kind of caught in and say, “Okay, this looks great. So, let’s do our own tests, right? Let’s run some workloads and see how it performs.” And of course, if it performs. Right? So, we ran an Oracle database on load, similar load we ran it in a leading cloud provider. I won’t name it, but everybody can guess who that is, right? We ran them and we saw that we could go up to 25,000 IOPS, as we said, in one terabyte and it will stay up there.
Most importantly, what we also found out was the price was almost seven-and- a-half times cheaper than compared to the other cloud providers. The reason being other cloud providers charge you for your files. Right? They have different shapes or different types of storage available.
One of the storage type available is that if you need more IOPS you pay for the IOPS. Right? You can go up to 20k IOPs on the block volume, then you pay for it, so your price kind of jumps up. Whereas in Oracle, they give you those IOPS because whatever you pay for your per gigabyte for your storage, storage we don’t pay anything extra to get those 25,000 IOPs. That’s what you see in those in the bottom row. It’s seven-and- a-half times cheaper to run an Oracle workload in OCI. It makes a lot of sense right here.
All right. Next slide, please.
As I said, it should not be tied to … When people talk about Oracle, they think, “Of, it’s database on cloud.” It’s not. Oracle Cloud cover various types of workloads in cloud. As I said, they offer bare metal machine so you can put whatever operating system on your bare metal, or you can bring it on hypervisor too. Then, there is of course VMs. Then, you have container services.
Primarily, they started with container service of their own, the container orchestration. I mean, that’s kind of settling down on kubernetes as a standard now. So, Oracle container service and OCI offering is 100% based on kubernetes. They were the first one to move and then the AWS kind of followed last year with that. So, it’s available.
Ravello is another service that’s available. Ravello is a service that you can run your VMware workloads as is in OCI. You don’t have to make any changes there. If you have any VMware workload, you want to move to cloud to OCI, it makes a lot of sense there.
Of course, dedicated compute is there. We’re going to talk about engineered systems available in OCI.
Next slide, please.
What are the choice of deployments? One important thing everybody would be thinking, “Hmm, so I have the Oracle licensing or licenses that I bought a long time ago, or maybe recently, and I am paying subscription fee, or I’m paying support fee on it. How do I move to cloud? Can I put my licenses to cloud?” Yeah, of course. Oracle has given you different choices. What you can do is you can bring your own license to IaaS. What you can do is you can spin up a VM in OCI and spin up the VM of the shape that you want.
For example, you own, let’s say, four processor licenses of software of ME software Oracle. That means you can go up to eight intel codes. You can spin up a VM with eight intel codes and load the software there manually if you want. Right? For example, an Oracle database, you can do it. Your license are fully portable to OCI, to Oracle. You can bring your own license.
Or, you can utilize the platform-as-a-service. Platform-as-a-services is basically Oracle’s automation built on top of IaaS. When I say automation, for example, database, if you use platform-as-a-service to spin up your database, what Oracle does is, it does all the underlying work that is required to be done. For example, spin up a VM, attach storage to it, load up software, create a database. All that is automatically done for you. And also automated page caching and back up is done for you.
All that automation on the platform-as-a-service layer is done for you. Now you don’t have to buy the license or you don’t have to subscribe to the license on the PaaS, you can bring your own license to the PaaS. So, you can do BYOL to the PaaS there also.
What’s the difference then, you’ll ask, between IaaS and BYOL or BYOL to PaaS? The cost of the PaaS is going to be slightly higher because you paid for the underlying IaaS compute storage and networking, like you paid in IaaS. But you’ll also pay a little bit more for the automation. But the cost of BYOL to PaaS is about 95% cheaper than pure PaaS. Pure PaaS is basically you also subscribe to the licenses from Oracle. Of course, everybody know the Oracle licenses are pretty heavy. So, there’s a subtle difference if you’re considering anything like that.
Now if you don’t own the license or if you’ve consumed all the licenses and you’re thinking of, let’s say, “Hey, let me spin up a VR also.” For example, you can have production in one region and VR in one region for VR purposes and you don’t own the VR licenses, then the pure PaaS, you subscribe to the licensing and let Oracle also take care of the automation and all that. It makes a lot of sense. So, those are some of the use cases with pure PaaS.
Next slide, please.
As I said, platform-as-a-service from Oracle has a lot of offerings. You can see the drop down list. What we’re going to talk about today is the integration cloud service, specifically the autonomous integration cloud service. That is one of the offering from platform-as-a-service.
Next slide, please.
With that, I’ll hand over to my colleague, Tom, and he will talk about both OCI and autonomous integration platform-as-a-service.
All right. Thank you, Navdeep. Nice job! Excellent overview. Hello, everyone. This is Tom Kopec with Oracle. I’m an Alliances Consultant. So, very simply, I work with Oracle partners in North America and, particularly, our partner, Centroid. Centroid team, thank you very much for putting this on. This is a very valuable session to your customer base.
With that, let me talk very quickly about this integration technology. As you’ll note on the slide here, integration is a key challenge that all of you are facing. You might have Oracle applications today, you might have third-party applications, you might have Salesforce in the cloud or Workday in the cloud, or whatever they might be, but you have a requirement to pull information from all those environments down to other locations or central application, for example.
One of the values and one of the things we want to bring to market is an integration technology, which is very specifically targeted to helping you as our customer, working with the Centroid team, integrate all these offerings.
Next slide, Brian.
When we talk about the technology … There we go. I think it’s slower, my network. We introduced and we have in the marketplace the integration cloud. We’ve added the autonomous capability on top of that not that long ago. Very simply, when we talk autonomous integration cloud, it’s very simply making it easier for you, the customer, to integrate your environments together.
A couple points around autonomous. This is a completely managed hybrid platform living inside Oracle Cloud. Because we’re utilizing autonomous technology so, obviously, this lives in a cloud-based environment. What we take advantage of is we take advantage of what’s artificial intelligence capabilities and machine learning capabilities, which allows you, the customer, to very quickly put together your integrations based on your requirements, automate that design process, and at the same time, we run real-time recommendations. So, at the end of the day, you can develop and integrate your technologies that much quicker.
Next slide, Brian.
So, we talked about it. And look at the left-hand side of this slide here. Where does the autonomous integration technology reside? It basically sits in between your application, so whether it be cloud-based applications, maybe their Oracle SaaS applications or third-party applications, such as Salesforce, or on-premise applications such as SAP or legacy homegrown applications. The integration tool sits in the middle to trade information back and forth.
Think about it from an integration point of view, historically, if you are running an application on-premise, it had all of its data and the data state of that application, but maybe your Salesforce application or your Oracle SaaS application needs some of that information, so you build a separate data source for each one of those application components. With the integration technology, we tie all that together, both from the application point of view and also the process point of view.
As you know here on the common use cases, bullet number two, there’s a lot of ways you can utilize this tool: file handling, invoice synchronization, et cetera. The key features with the autonomous integration cloud service is local, very simple for a line of business or an IT person to put together the integration environment, we make recommendations based on the machine learning as a whole, at the same time, this environment is totally integrated with a lightweight agent.
Now, obviously, the benefits around this is speed, faster integration on the automation of applications. At the end of the day, it makes it easier for you, our customers, Centroid’s customer to get your applications out there and ready to go, very simply responding to your coming to your competition. So, increased agility, obviously, a lower cost of ownership because our time is dramatically reduced.
Next slide, Brian.
Now a couple of key items around this environment. You’ll see on the left-hand side of the slide the how it looks and feels. We will get a very detailed demonstration from our partner Centroid here in a few moments. But the keys of this environment is the adapters. There are adapters all over the place. Adapters built by Oracle, adapters built by our partners, adapters built by our competitors, for example, to tie their technologies and our technologies together utilizing this integration tool. It is fully orchestrated on your behalf. Again, leveraging AI and machine learning capabilities. Very simply, it makes it very simple and very timely to put things together.
Next slide, Brian.
Again, one component, the file transfer. The file handling use cases between cloud and on-premise applications is automated for you.
We talked about these adapters. There are a number of them in the marketplace today. As I said before, these adapters may be built by Oracle or may be built by third parties or our competition, partners such as Centroid, but very simply, they allowed the connectability. Where these are located? On the lower right-hand side there, it’s on the Oracle marketplace. So, if you go to cloud.oracle.com, one of the options is this cloud marketplace.
If I have a requirement to pull the information from a Twitter environment, for example, and feed that into an Oracle SaaS application, I can utilize the Twitter adapter, sometimes they’re cost-based, sometimes they are free of charge, to feed and assist the integration tool to feed those tools. So, this buys you, as I said before, makes it easier to integrate. It also helps setup this automatic discovery of application information.
Next slide, Brian.
As I said before, a number of these adapters are built for Oracle technologies by Oracle. Let’s go through this real quick. Our SaaS-based environments, the Oracle ERP cloud, or NetSuite cloud, or HCM cloud environments, your Oracle CX environment, the on-premise based applications for Oracle technologies, and also technology adapters are all available to you. These are all available from the marketplace that I mentioned a few moments ago.
Next slide, Brian.
As I said before, these particular adapters are also for non-Oracle environment. As I said at the very beginning, you as our customers, you have multiple environments out there. You need to link these together by utilizing adapters from Oracle and adapters that are available for third parties. You can take advantage of that and link those together. You’ll note here on just an example, some of the third-party adapters in the marketplace, whether it be a workday application or an on-premise application. Maybe you’re running Microsoft SQL server database and you need to pull information from that database, fine, there’s an adapter there for that.
Also, we talked about the social media applications, we talked about Twitter, there’s Facebook capabilities accept a number of adapters that are available so you as our customer can pull the information out of those environments.
Next slide, Brian.
So, instead of listening to me talk, let’s see a demonstration of this environment. Brian, I’m going to pass this back to you and we can run through a quick demonstration of our integration environment.
Thanks, Tom. I appreciate it. Really quickly, before I hand this over to Jude and we go over to the live demo, I’m just going to highlight this sort of the agenda.
Number one, Jude is going to do the first three bullets here. He’s going to build a connection with AICS. He’s going to orchestrate some integration; in this case, we’re going to use the use case where we’re using Oracle HCM SaaS connectivity to an on-premise EBS environment. Then, the last thing is we’re going to do a process builder with AICS and do a build process and flow and execute. Then after that, we’re going to hand it to Ben.
With that, Jude, if you’d like to take control?
Sure, Brian. Thank you. Hello, everyone. this is Jude Victor from Centroid Integration Team. What we are seeing here is the AIC homepage. I will quickly go over the important components of the AICS. Here are the major components or integrations and the process builder. Then, we go into the integrations.
This is an integration designer page. We have a few important components here that helps us build the integrations. The first one is the adapters. As Tom mentioned, AIC provides several pre-built, ready-to-use adapters for integration, which are the types of applications on which we can base our connections, such as Sales Cloud, SAP, Salesforce, et cetera. We can also create our own custom adapters and register them here to be used in the integrations.
Creating an on-prem connection is fairly simple with AICS. We must create an agent group in order to make on-prem connectivity. When we create an on-prem connectivity, it’s fairly simple, it just have four different fields you need to specify your values. It takes this identifier value and we have to download connectivity agent from this page here. So, this will be installed on your on-prem host and it will be up and running, configured with the identifier we just created. So, that will be listening for the messages from AICS, then it can be configured with connections to the on-prem host, and it can be used in the integrations.
This is the connections page. I’m going to go through … These connections define information about the instances of each configuration we are integrating. When we create a connection, it’s going to ask us a list of pre-built adapters, which one we would like to use. Let’s say I’m going to choose Oracle database. So, this is a pre-built adapter. It has a configuration details like port SID service name we can configure.
When we create a connection, we have three different roles for each connection. It can be a trigger connection. In case of trigger connection, it sends requests to the AICS. In case of invoke connections, AIC sends the information to the connection to invoke. The trigger and invoke will do them both.
Let’s take a look at one of the cloud connections we have been using. This is HCM cloud connector. It asks us to give us the visitor URL, where you have all SOAP API related connectivity information. You will have access to all the SOAP APIs from here. The interface catalog URL is the one that we use for the REST API capabilities. This will give us the list of business events or all the REST resources API that can be used in the integration from the cloud provider. We have the authentication details here. We need to give the user name and the password credentials for the cloud.
So, that is about the connections. We are moving onto the integrations.
This is the integrations dashboard that list out all the integrations we have created so far. Let me open up … Before we go there, I would like to touch base on the types of integrations we can create. So, when we create an integration, AICS provides six different types. It can be app-driven orchestration. So, this can be a business event that’s being triggered from an application. Let’s say I’m updating an employee or supplier, it can trigger an event and this can be captured in AICS. It will initiate the integration flow.
The other one is the scheduled orchestration. It can be run in periodic intervals or it can be run on demand. The other one is a file transfer. It seamlessly and securely move the files around the network. Basic routing is a simple data mapping integration, basic app routing. We can just map with the list of available attributes from each side. The other two are the pub and sub. We can publish and subscribe messages from AICS.
This is the designer page of an integration. This is a scheduled integration I have created for our demo purpose. The use case is we are going to … Let’s say, an employee request for information to be changed. The enterprise keeps its employee master in HCM cloud setup and in on-prem EBS deployment as well. I have created an integration with a scheduled activity, so it can be scheduled periodically or it can be run on demand.
This scheduler activity … Before I go there … I’ll just show the important aspects. Okay.
The first activity is the scheduled activity. It will have all the variables, runtime parameters that can be used in your integration for scheduling. This will have all the time elements, data elements, everything. You can use them for tracking or for manipulation inside your integration.
On the right-hand side, we have three menus. The first one is the invokes. The invokes list out all the list of connections we have created with pre-built adapters to be used as a source or target. The next one is the actions. These list out the various elements needed to process the data and handle exceptions in the integration flow, such as: we can assign a variable, we can call external function, we can create mappings, we can work with the files, we can create a looping activity that will traverse through the record set and get the current information for manipulation. Then, we can also use them for the logging of the error messages, we can send notifications, we can create switch activity that will conditionally route the integration flow. Also, we can do exception handling by raising error activities here.
The next one is the integration artifacts. These are the business processes, which we create using the process builder. These are automated business processes you can incorporate in the integrations.
Coming back to the integration flow, the first activity is a function call activity. I have created an external Java script function that will call the current date to get the current date information. This is used in the subsequent mapping because we need to get the list of employee who got updated today and we are going to sync that information from HCM to e-business.
This is how a typical mapping looks like. This is the value which I derived from the function call. This will be mapped to a query here. This is the last update date, which I will show in a moment how we obtained this one. This is this is a simple query for all the employee which got updated today.
This is an activity which we built on top of HCM cloud connection which we have built. Let me quickly go through how it looks like. This is a REST adapter build connectivity. When we configure HCM adapter for a connection, it provides these three different options: you can query, create, update or delete information; or you can just do a bulk extract for reporting purposes; or you can use ATOM feed. ATOM feed provides a very great facility to track real-time updates from HCM system. It can be brought into the integration real-time. It is fairly fast and we can see the changes immediately reflecting into the AICS. Right now, I am using the first option. It can be a query, create, or update, delete information.
Here is the list of REST resources that are available through HCM cloud adapter. What we are seeing here is the REST resources type. It can be a business object, REST service, or REST resource. I have chosen REST resources and I am selecting HCM REST application.
Within that application, we have a list of available APIs under data elements here. We have pretty much everything from HCM, we have assignments, jobs, roles, grades, absence, time record. Everything is there. I have chosen Emps. The Emps is the one that will give us the record set attributes of an employee record. Here, for that particular API, I can either choose one of the below operations. I can create an employee, I can get just one employee based on a criteria, I can get everything as a whole, bulk input, or I can just update one particular employee with the criteria. Upstart means I can create and I can insert an update.
Once that is done, it will just give us the components of what we have selected. Like I said, we have configured our HCM adapter mapping, HCM adapter connectivity here.
Going back to our mapping activity here, so this is the last update date from that Emps resource API which we have received. So, the current date will be mapped with this last update date, from the Emps record set.
After that, I have a looping activity here. This will look through all the records set, which we have received from the HCM. It will go record by record. The key to this integration is I am using the social security number from HCM into e-business suite, so the employee will have a common social security name as the identifier to uniquely identify the employee.
I have an activity here, which is built on our e-business suite DB adapter. Here I am going to execute a simple query on the DB, database side, from e-business side. This is the national identifier. It’s actually a placeholder. This will have the value from the HCM cloud adapter, which we have received. It will pass the social security number. I am getting the corresponding record for that particular employee from the e-business side using the SQL query. So, this will give us all the details that we need to update the employee record in the e-business side, which are also mandatory parameters to the API on the e-business side. So, these are like person ID, object, version number, et cetera.
Once we have configured that SQL query on the DB adapter, we are going to go back to the mapping. So, here is the mapping page where I am getting, the current employee is the current employee in the record set that is going through the loop. So, we are getting the national identifier from the current record set and mapping it to the national identifiers in the SQL query, which is getting fired at the DB level, on the e-business side.
Our next activity is going to be, again going to be on the e-business side. This time it’s going to be a stored procedure. If you have a look at it, we are using the same DB connection for two different things here. This is going to take a while because when I click on the next button, it’s going to collect all the information from the e-business side.
Since I have chosen Invoke a Stored Procedure, all the APIs, all the procedures and functions that are available from all the schema are going to be driven from the e-business side and listed out here. I’m going to choose the HR person API. Under that, I’m going to choose the update person procedure, just like the way we normally insert or create employee records in e-business environment. Once that is done, we are going to map the mandatory values to that API. So, this is how it looks like.
I have selected app schema. I have selected HR person API. Under that, I have chosen the update person procedure. Under that, I have list of attributes, which I have mapped. So, these are all the arguments. This procedure intake. We are going to map them from whatever the information we have received from both from the HCM side and from the SQL query that were fired before.
I am going to the mapping activity here. This is going to contain information. On the left-hand side, we have all the list of data attributes for the employee we have received from HCM. On the right side, what we see is the update person procedures, arguments. So, a simple mapping would be like this. It’s fairly a drag and drop. You can just drag and drop to the related parameter on the DB side, it will map automatically. You can validate and close it. That’s it. We are done with our simple integration flow here.
Let me quickly, before we go in detail of how to execute this, I will just show how the HCM side looks like for an employee. This is a employee from the HCM side. This is a HCM demo environment. So, I have just chosen one employee for the day because it’s been updated worldwide, so I don’t want to create much payload on the integration side.
Let’s quickly take a look at the personal information here. The goal of this integration is to update the employee email. Let’s say, the employee has an email address like this: [email protected] Let me quickly go through the employee on the e-business side. As I mentioned earlier, the social security number is the key on both sides. It’s 454-32-1299. On the e-business side, it’s the same. I am going to the office details here to check on the employee email. It’s already have the same email address. I’m just updating it to another one here to see the integration working. I am saving the information here. I’m correcting it. It is saved.
Now we are going back to our integration. This is the scheduled activated integration from HCM to e-business. I am running it on demand.
So, it has submitted with the request ID here. It is still in the process mode. It finished successfully. I can go and look at the flow here, how would made it through. As you can see, the green highlighted path shows the integration flow. It went through each activity and it picked up one record, and then it went through the loop, it updated the employee, it successfully completed with the stop. For some reason, it could get stuck in one of the activities, this will be in red and it will show us the error right here.
I will show quickly on the e-business side how it got updated. You let me look at the office details here. As you can see, the integration updated the employee email derived from HCM cloud.
Let’s go back to integration cloud. So, I have enabled this integration with a trace and payload monitoring, so in case for some reason if you want to debug on what kind of information is getting passed through each of the activity, you can easily check them. So, we can go and see the activity stream here. Let me select everything.
Here, this is the payload for each activity that is going through the integration flow. As you can see, this is the employee payload, which we have caught from the HCM cloud. Likewise, for any reason, if some of the records are missing or in case we need to debug something, we can download this payload and debug them so that we can see which ones are getting missed and we can take necessary actions on them.
On the monitoring side of the AICS, we have a dashboard. This will give us the list of integrations that are currently running. It basically gives us the integration health, how many are they currently activated, how many connections are built, how many of them are scheduled, how many failed. So, it’s fairly simple to see and understand.
Once that is done, we are moving onto the process builder. A process builder helps us rapidly design, automate and manage the business processes in the cloud. It comes with two different attributes. One is spaces. These are work spaces in which applications are created. This facilitate access control of the applications between the users. I can create a workspace here. I can share it between my team. I can create applications within that space. Those employees within the space will have the access to that application.
Let me quickly click on application. I have a built-in simple application here which is basically a travel request approval application. Let’s quickly run and see how it look like. I’m testing this application right now and I test more so that I can run it. During the runtime, the application which we have created will look like this. We can customize this look and feel with different attributes, with different icons and stuff.
I’m invoking this particular application. This is simple UI, which I have created using the process builder. It’s fairly simple. It’s drag-and-drop tool. We can make use of it. Just entering the information required. I’m raising a travel request for this amount and asking the approval from my manager. I’m submitting it. Once I submit, this has initiated the approval process underneath that application. This will create a human task. So, in which case, in my space, currently I am the approver as well as a process owner so the in request has come to me.
As you can see, the travel request application form has been forwarded to me with all the details. As a process reviewer, I can reject it, approve it, or I can do escalate, withdraw, assign it to somebody else, or request more info, or suspend this request.
I’m going to approve this. Once it is approved, it is going to disappear from my task list, task queue. As a process reviewer, I can go and look at what’s going on with the process. This is the process flow, which I have created, and it is showing me where this current process now.
I have submitted the request using web form and then it has gone to the process reviewer for the approval. Then, the reviewer has approved it, so it has gone to activity that is supposed to send the email to the employee once it is approved.
Then, right now, it is pending on the fulfill activity. Right now, it is pending on the process reviewer. The reviewer can either fulfill this particular request or he can launch the form to do some more operations like reassign or request more info. Right now, I am submitting it for fulfillment. Once it is submitted for fulfillment, this will complete successfully.
Now, I am going to go through the application, how it is developed. I am going to open the application in the edit mode. These applications are very useful when you have sequence of integrations that are running, and you need sensitive data that is flowing through between the integrations, and you need human integration intervention to review the files or sensitive information you want to review and going through an approval process. This is the way to do it with AICS. It provides fairly simple toolkit that can be developed very rapidly.
As you can see, this is the process flow. I have built you see three horizontal cross sections. Each one is having a name: process owner, process reviewer, system. These are basically the user roles. With this button, you can add more roles. So, whatever the activities that are on this particular streamline, those activities will be performed with a person, with the process owner role. Similarly, process reviewer will have these roles; he can approve the request, he can fulfill the request. Then, the system is the automated process activity that will send the email notifications once it is approved.
When I click here … This is the form which we have seen during the demo. This is the place we build it. It can be built and used in multiple mobile devices or in regular browser. This is how it will look in a phone or medium devices or large devices. This is a very rapid development tool. You can simply drag and drop. You can simply give them names and style sheets can be used here.
Once we have designed the form, we have created a human activity here. You can easily refer the elements used in those forms and can be referred in the human activity. It provides a basic expression editor here in which you can drag and drop all the form attributes which we have created. You can drag and drop and you can use them for manipulation in the subsequent activities.
This is a approval of decision-making activity. Once it is approved, it will go to the send email activity that will that will send the email. You can configure the email addresses, you can configure the messages subjects fairly easily.
This is a fulfill activity. Once it is submitted, it will be forwarded to the end of the process.
The process builder uses a standard language, which is a business process model notation. This particular language is widely used in most of the standard language building applications, so it’s fairly standard and simple to use.
With that, I am concluding my demo and I am passing onto my colleague, Brian.
Thanks. Can everybody see my screen now?
Not yet? Okay, hold on. All right. Can everybody see it now?
Yes, you’re good.
All right. Great. Thanks. All right. The next part … There’s someone in background, if you can go on mute, please? It’s loud. Thank you. The next person I’m going to pass to is Ben Masters. Ben is going to walk through the OCI free cloud credit set up. I’m going to pass that to you, Ben. I’ll hand it to you to talk through this.
Okay. Thanks, Brian. As Brian mentioned, I’m Ben Masters. I’ve been with Centroid for about 12 years. The last three of which has been spent as an Enterprise Cloud Architect, primarily with Oracle Cloud Infrastructure, but also some significant amount of Amazon web services mixed into that. I think it’s important to take a second to review what we’ve gone over so far. I’ve been here just over an hour.
To kind of recap what we’ve gone through, we’ve had an introduction by Brian with respect to Centroid and who we are. That was followed by Navdeep, who presented an overview of Oracle Cloud Infrastructure, covered the database infrastructure, software, platform-as-a-service components, and everything provided by OCI. That was followed by Tom, who gave us a high-level overview of the Autonomous Integration Cloud Services, which then Jude picked up and gave us a pretty deep dive demo into how AICS works.
Given all that, it makes sense now to, I think, give a quick demo here on how we actually get you into the Oracle Cloud Infrastructure and how you can go ahead and give it a shot for yourself. Oracle provides a really good demo program, especially relative to some of the other data cloud providers with respect to what they offer as far as the array of services they offer and the amount that they offer for trial. It’s important to understand what they offer and how simple it is to get going with it.
Starting here with the first slide, you can get to demo process started by going to cloud.oracle.com/tryit. This is the page that you will land on. I think Brian indicated in his presentation at the beginning that it is a 30-day trial. You get at least $300 worth of free credits. There is possible to get that expanded. But that actually opens up everything in the Oracle Cloud Infrastructure portfolios of apps and services. So, the AICS that we looked at today, that’s available infrastructure-as-a-service available, database, platform, software. All of that is wide open and available to try at a pretty significant amount during this 30-day trial.
From this page, we would hit Create a Free Account. Next slide, please, Brian. That’s going to land us here where we actually have our account details and verification. This is pretty standard type information for setting up any type of cloud file account. You decide whether it’s company, personal use.
Then, we get down to cloud account name, which is one of the more important fields, especially when we’re working with OCI. This cloud account name ends up turning into your what’s called an identity domain within OCI, which is pretty important. You can see that the identity domain not only will be how you access your account but it’s going to be represented in URLs. For example, this Oracle Cloud Rocks, URL here, under cloud account name, you’ll see that in your browser.
It’s pretty important even for a demo account, I would say, because you have the option to eventually turn your demo account into a permanent account and you can’t change the cloud account name once it’s configured. So, it may make sense to spend a little bit of time making sure you name this appropriately. Even if you don’t have an intention of converting this to permit account downstream, just taking a few minutes to think about what you want this cloud account name to make sense.
You’ve got some additional information with respect to the company, regions, you got the email address, which is where it’s going to send the notification that your account has been successfully created, so make sure all of that’s correct.
Then, we get down into verification. Pretty standard. You give it a phone number, it will send a confirmation back to that phone number. Supply that.
Then, we get to the next page, please, Brian. I think we skipped a page. Go back up one. There we go.
Then, we get our payment information. Oracle does require that you provide a credit card. What’s important to note here is that they’re not going to charge this card. It’s essentially just BOT protection fraudulent account, things like that, that is Oracle’s trying to prevent.
What happens at the 30-day mark? You will get a notification from Oracle asking if you want to convert this to a real account from a trial account. At which point, they could begin charging the card. But again, it’s important to note that’s an opt-in only and unless you explicitly opt-in Oracle is not going to start billing against this card.
Next slide, please, Brian. Then, we get down to just the validation of the credit card, as well as confirming terms and conditions, and hit Complete. We go to the next slide. We’ll land on this page which just thanks us for signing up and lets us know that we’ve got a confirmation email coming to the address that we supplied in that first page. So, we can run over to our email accounts. It says 15 minutes, typically it’s been five or less. I’ve done this four, five times and I’ve never waited more than five minutes. But then you say up to 15 minutes before you get the email.
Next slide, Brian.
This is how the email looks like. This is the email snippet from the email you’re going to receive to that address, again indicating that you’ve got the $300 worth of credit, confirms your username as well as a temporary password, which you will need to copy in order to sign in.
Once we hit Get Started with Oracle Cloud, we go to the next page. We land here on the sign-in page for Oracle Cloud account. If we link from the email, these drop-downs as well as the identity domain should be pre-populated. If for some reason it’s not, you do want to make sure that you’re logging in under cloud account with identity cloud service. There’s another option for traditional cloud account, but that’s not how we’re accessing it, we are using identity cloud service. So, you do want to make sure that it’s populated with with that, as well as has the correct account name/identity domain, which is our Oracle Cloud Rocks here.
From this page, we would hit My Services and we get to the actual sign-in. Our sign-in account name again is the email address that we provided; the password, we copy-paste it from the email and it’s there. Let me click Sign In and we’re going to hit the “getting started” landing page. So, now we’re actually in our OCI account. You can see both our username and identity name up in the upper right of that page.
Down here in the Guided Journey section, we get a good overview of a lot of the services that are provided by OCI. If you’re interested in application development, that would be right there on the Develop and Deploy. In addition, if you’re spinning up IOPS, you got infrastructure networking storage that you want to spin up in Oracle data centers, there’s that create infrastructure. Then, on and on with migration, integration, management monitoring. All of the cloud services that you would expect to be available, we now have access to this demo account.
Next slide, please, Brian. That actually finishes up the trial demo. I’m going to go back to Brian for consulting services and then wrap up with Q&A.
Great. Thanks, Ben. I appreciate it. We’ve got just two sections here. I’ve got a short three or four slides and then we’re going to go to Q&A. I had asked it on Q&A, any questions you ask, if you go into the chat menu and just ask those. You can ask that as we’re as I’m finishing up here and then Navdeep Saini is going to respond to those things verbally on any questions you have.
Centroid Consulting Services, specifically around just what we went through with Ben there around the free cloud trials, our goal as a Oracle partner is to ensure your success on these trials. Sometimes people aren’t familiar with the UI or they’re coming from a different cloud, there’s these type of things, so our job is to really help you out. Again, we’re here, pretty much anytime you can send us an email, you can get on the phone call, but identify your areas of needs or question. You can ask your Oracle rep or SDR who introduced you to engage Centroid with us as well. Like you said, our goal is to really make you successful. So, if you’re kind of stuck in something in the trial or you can’t figure it out, we’re here to help you out. Just as a soft-consulting around that and ensure that your trial is successful.
Some other things that we’re doing, we’re having a lot of success in doing this about two week is we do planning and budgeting help for customers. A lot of times people come in with expectations with Oracle that, “Hey, these are big dollar type engagements.” That can still be Oracle in the enterprise space, but in a lot of cases that’s not the case.
What we do is we put together full planning and budgeting, we do a consultative discovery call to identify your objectives. You say, “Hey, I want to move the dev workload into OCI in the trial.” We basically identify that, ask some elements around the short survey, then we build a bill of materials and what kind of an effort it would take if we were to do it end-to-end for you. Then, we provide that to you from a presentation so you can take that to your management.
As an example on this, this is the last slide of kind of one of those things we do, you say, “Hey, this is how much compute storage memory and whatnot that you want to do. This is what the annual cost is. This is the monthly cost going from left to right.” The consultative effort to move those things, setup, backup,, do whatever is $21,800. Then as part of the Velocity program that I mentioned very early on in the presentation, in that case, Oracle is basically giving you back $15,000 toward that, assuming the BOM is big enough. That reduces your consulting effort by 21,800 minus 15,000, so your TCO is much smaller on that initial engagement.
That’s Oracle’s way of basically saying, “Hey, Centroid knows what they’re doing. We’re going to pay them to ensure that you’re successful on your first go of it.” We’re doing a lot of these. Literally, we put these together in days for people.
Another area that we do on the cloud consulting side of things, a lot of people ask us, “What would it cost to spin up DR or do a Lift and Shift? Again, we identify your limited use case, provide scope of effort. If the compute is small enough and we can use the free trial credits, we’d love to do that and prove it out, and then we just go through and ensure that it’s successful and execute on it for you as a customer. If it’s real soft and lightweight, we can do it at almost minimal cost. If it’s much bigger, oftentimes we can get funding to help you out too.
Last two slides, cloud strategy. Where do you want to be in 2019 or 2020? Is it a hybrid approach? Is it an all-in approach? Is it one way or the other? But we will do consulting engagements here to identify your journey, what’s good, what applications are good, what needs to be upgraded, et cetera? We look at the pros and cons of the different approaches. Then, we do a critical path considerations. Create that strategy roadmap. Typically, this can be a very large document depending on the number of workloads and different systems you’re looking at. We put a number with it, like what would it cost on the Oracle side? What would it cost from the Centroid side? Are you looking at other clouds? What are the pros and cons? Go through all that and help you out with that.
Last slide, before, and like I said, I love this, some people can ask some questions in the Q&A is Oracle OCI, IaaS, PaaS is really built for enterprises, built in governance and security, all the security things you expect from an internal high-end data center from all the certifications and things that you’re expecting. From my a high performance, Nav mentioned it in the OCI overview around the 25K IOPS guarantee, whereas other cloud providers it’s much more expensive to get there. You have flexibility with choice and models. You can bring your own licenses for infrastructure of the service. If you don’t have licenses, or you want to do DR and you don’t have licenses for that, you can do it on PaaS. All sorts of flexibility there.
The last thing is just the cloud infrastructure guaranteed SLA. Oracle offers things that the other cloud providers don’t do. They may have gotten in the game a tab later, but the last two, three years, there’s lots of progress in this space and they are offering things up that the other providers aren’t doing that.
With that, let’s see here, I’m going to check and see. I see a question here. Nav or Jude, can one of you answers the chat menu? I’m going to repeat, “Are there any pre-built flows for different systems like EBS and CPC cloud or do they have to build all the integrations from scratch?
Brian, I don’t think that we have pre-built integration flow per se, but there are adapters which we can leverage and we can build fairly fast integrations using them.
Okay, great. Any other questions out there? I know we’ve got a hard stop here in about eight minutes. Any other questions that someone wants to type in chat around this while we’re all here? All right. Well … Oops, there’s another question. “I’ve already tried DaaS on OCI. When I spin a 12c database I can see a VM has started. Is this not like Amazon RDS? Can you differentiate between RDS and Oracle DaaS?” Nav, I’m going to have you answer that one.
Yeah, I can answer that. Yeah, functionality-wise, it’s the same. Amazon RDS is information database service, so they do the same thing. They spin up a VM for you, does the automation of installing the binary, the setting of the database, and then after that you can start using the database, you can do caching through the code RDS console, you can do backups and or whatnot. Same functionality available in Oracle Cloud, the only differences is the way the licensing is handled. In Amazon, essentially, your licenses are double because of the Oracle’s policy. Also, Amazon doesn’t offer any subscription license beyond standard edition two or standard edition, so you can’t subscribe to enterprise edition licenses. That licensing is going to be a problem for you if go to Amazon RDS.
Another important thing, from the technology perspective, is Amazon RDS does not give you access to the database machine that spins up for you. It just gives you the console, gives you the TNS entry and whatnot to connect to the database. Whereas in OCI, in Oracle Cloud, they give you access to the database and then they spin it up for you. This is important in cases where you have applications that need some kind of work and needs to be done on the database. For example, mounting amount client or shared drive on a database or database to rely directly to it. Amazon RDS in that, you can’t do it in RDS, whereas in OCI, you can do it.
Now, the rest of the features are the same. RDS does caching and whatnot. OCI databases this can do caching, back up, and whatnot. Everything is automated for you.
Great answer. Thank you. I appreciate that question from John. We still got about five minutes left. Are there any other questions out there around anything that we did on integration cloud service or Autonomous Integration Cloud Service or any other features of general OCI?
All right. I’m going to take that as everybody’s pretty much used up all of our time. What I’d like to say is thank you very much. I appreciate your time and attending. I will be sending a follow-up email with a recording of the overall event. Like we said, if you have any questions on it, let us know. Again, we we look forward to. If you have questions or you want to engage us, we’re happy to help you out. Again, whether it’s a small, big deal, or a bigger project, we’re not scared to deal with any of those. Again, we always like to start small with customers and build on top of it.
With that, I’m going to end this up. I just want to say again thank you very much for your time. Everyone, have a fantastic week. Thanks. Bye.
Centroid is a cloud services and technology company that provides Oracle enterprise workload consulting and managed services across Oracle, Azure, Amazon, Google, and private cloud. From applications to technology to infrastructure, Centroid’s depth of Oracle expertise and breadth of cloud capabilities helps clients modernize, transform, and grow their business to the next level.