What is our primary use case?
Oracle ERP Fusion Cloud is used for enterprise resource planning. We have different ERP modules at HCM, such as human capital management, supply chain management, and asset work management.
We use Oracle Integration Cloud to automate a large number of integrations. For example, if you want to load the employee file from, say, a boundary system or Workday, you are providing me with a file containing the employees' salaries, and designations. I need to import it into the Oracle ERP Fusion Cloud or the ERP cloud's human capital management module, but there is no simple or direct way to import that file into the ERP cloud or that CM.
In Oracle Integration Cloud, we take the file, read it, and transform it to meet the MAT requirements of the ERP cloud or SIM cloud. For example, we create the HDL for a MAT file that contains HCM data, we also automate it. Basically, you provide the file, and we transform it. We will submit the job to ERP, where we will be able to encrypt, decrypt, and increase security. The Boundary system only needs to provide the file, and we will convert it to the required format and load it into the ERP cloud, sending notifications, logging, and monitoring.
How has it helped my organization?
There was initially we had two products on-premises, with were BPEL and Oracle Service Bus. When stateless integrations were required, we used Oracle Service Bus, and when a large flow was required, as well as a long-running process, we used BPEL (Business Process Execution Language). Oracle has removed these two distinctions and has merged them into one. Oracle Integration Cloud Service can create two services: one that is simple request and response, and one that can run for an extended period of time which is a good thing. That is extremely valuable. As an organization, you do not have to buy a separate product or two separate products for it.
Furthermore, everything is now under Oracle's control, from an infrastructure standpoint. Initially, when we had an on-premise structure or the on-premise SOA Suite, we had to maintain the logs and server as an organization.
It was entirely the organization's fault if the server crashed. They needed to hire web logic administrators. There was another layer. There was an administrative layer and a development layer. There were a lot of node managers and admin managers. We no longer have to be concerned about infrastructure at all. If the server fails, Oracle will take care of it. We do not need to engage in web logic administration consultations to investigate this. The Oracle is in charge of everything. And if there is any maintenance, Oracle will take care of it as well.
They will provide you with a timeline stating that on this day, we will be performing upgrades or releasing some manuals or updates. Oracle has completely automated this process. You no longer need to be concerned about it. There is no web logic, nothing.
What is most valuable?
The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive. For example, if I trigger the integration and can also schedule it within OIC, there is no need for a third-party scheduler to schedule the integration in the OIC integration cloud.
We do have a good scheduler in place. We also have encryption and decryption systems in place. Which is good.
With the dashboard for monitoring, you do not need a third-party dashboard or logging framework when you initiate the integration.
We can certainly create some logging framework, but for some of the lightweight integrations or logging where we do not want to retain the data for an extended period of time, the logging framework within the OIC is sufficient. The dashboard is excellent. You get a clear picture of how it works, where the flow is, logs, log management, and everything.
It is simple to incorporate into some of the best products. I can, for example, directly integrate with Workday and Oracle. There are many adapters directly available, as well as numerous inbuilt integrations shared by Oracle. We can use it as is with a little tweaking.
There are a lot of adapters, which is what I like the most. This greatly simplifies the integration. There is no web service. You should not be concerned about it. You simply configure that after, and there will be direct connectivity, which you can use as it is. There are many options.
What needs improvement?
This is entirely web-based development. We lack an IDE for developing integrations. Back in the days of OSB and BEPL, we had to go into the code and not just drag and drop. We used to go into XML and modify it. We could, for example, edit some XSLT or XQuery documentation, but this is mostly a drag-and-drop. A person cannot directly enter the code or examine and modify so many variables. As a result, one had to rely solely on the drag and drop feature.
Oracle has implemented a few modifications. For example, you can now manually edit the XSLT by going into the code, but there are many things you cannot change. You cannot move from one location to another. UI-based controls still have room to improve, but migration can be made simple. If we are migrating integrations from one environment to another, such as development to testing, if it is a one-click migration, which is possible in some cases, that would have been good.
As of now, we simply export the IIR and import it into the new environment. Migration and the User Interface could be improved.
Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release.
For how long have I used the solution?
I have been using Oracle Integration Cloud Service since 2016, nearly five or six years.
I am working with the most recent version, which is deployed on the Oracle infrastructure.
What do I think about the stability of the solution?
I find the performance to be really good, mostly, but it depends on the implementation, how the developer implements it, or what the design and patterns are, but I find the performance to be really, really good. Furthermore, Oracle is constantly improving the OCI infrastructure.
We now have many features and options, such as buckets for Object Cloud Storage. You don't have to rely on the FTP server as much; if it's a file-based integration, you can use file buckets directly to access the files.
In terms of performance, I think it's good. And the stability, it is stable. I haven't faced many issues. We do encounter slowness on occasion. For example, if there are other integrations, sometimes there is slowness, and we immediately raise an SR with Oracle, and they work on it.
What do I think about the scalability of the solution?
It is easily scalable. For example, if you want to add servers to an existing set of servers to increase elasticity, it is easy. As demand changes, the elasticity can be reduced or increased.
It is also dynamic. It is dynamic in some of its features. It automatically enhances the server if it is needed more and reduces the servers if they are idle for an extended period of time.
We work for a variety of clients. I am sure there are a lot of clients who are currently using this Oracle Integration Cloud solution.
We do have an Oracle practice we call Oracle COE which stands for Center Of Excellence. For just OIC, I would estimate that we have a global team of over 500 developers.
Just for OIC, we have Fusion products separately, Oracle integration, ERP Cloud, and SIM cloud, that is the SaaS layer, but they can be more than 500 developers for the PaaS layer.
This solution is extensively being used by our organization.
I believe it will be used even more or remain stable, but I do not believe its demand will decrease. But, the usage will be more.
How are customer service and support?
I would rate the technical support a four out of five. There is always room to improve.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
I was previously working on the on-premise middleware solution, the Oracle SOA (Service Oriented Architecture) Suite, which included BPEL and Oracle Service Bus, but everything was later moved to the cloud.
Oracle Integration Cloud is now available. It was first introduced around 2014 or 2015.
I began working with the on-premises solution. Then there's the cloud. There was an Oracle server switch stack on-premise. I've been using the Oracle suite since the beginning of my career. Initially on-premise, but now in the cloud.
I started out working with Informatica as well. That was a batch integration, such as for heavy-duty integrations or large files containing GBs of data. So I started with Informatica as well, but after that, I've only used Oracle products for online integrations and other integrations.
How was the initial setup?
The initial setup is straightforward. It is not complex.
I would rate the implementation process a three and a half out of five because it is easy.
What about the implementation team?
We are using Jenkins, and we have written some scripts to take integrations from one environment to another. We are logging everything, checking it into git, and then automating the processes in Jenkins. It starts with the IIR and then moves on to another environment. That doesn't take long. For example, if there are hundreds of integrations, Jenkins can deploy them in one or two hours. But, if you don't have Jenkins and you don't have automated scripts, it will be a lot of manual work.
There are currently no one-click solutions. If we had a one-click migration feature, it would have been good. We're still using Jenkins script, it's not too difficult. It takes about one or two hours to deploy hundreds of integrations.
The deployment was done in-house. We are consultants and I am one of the consultants on my team.
We develop on our own. We raise an SR if there is a requirement. And if we have any questions about the product or suggestions for improvements, we do so as an Oracle SR.
What's my experience with pricing, setup cost, and licensing?
I am not aware of the pricing.
What other advice do I have?
Even if you have no prior experience with Oracle product integrations, it is easy to learn and use because it is mostly, drag and drop. If you are not familiar with coding or development or Java or JavaScript, you can easily learn Oracle Integration Cloud. This is mostly a configuration-based development, and you only need to use your mind and logic to implement it better in a performance-tuned way, but it's very simple. I would recommend that you use it.
It makes integration so quick and simple.
I would rate Oracle Integration Cloud Service an eight out of ten. There is always room for improvement, but eight is definitely a good rating.
We are partners with Oracle.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner