Oracle Integration & AI: Accelerating OIC Development Phases

In the evolving digital era, Oracle is embedding AI deeply into its Integration platform to streamline, automate, and enhance the development process. Rather than seeing AI as an add-on, Oracle’s strategy ties together infrastructure, development tools, and application integration so that teams can build faster and smarter.

Oracle’s AI-Innovation in Integration can be declined in 2 ways.

  1. How the AI can be a value add for OIC developers
  2. What OIC can offer in the Agentic AI area to simplify and accelerate AI adotpion in enteprise projects

In this article, I’m focused on the first point and I will try to explain how developers can take advantage of such AI features.

What coming from Oracle AI World event , recently occurred in Las Vegas, gave us the opportunity to be aware of:

  • Embedded AI capabilities: Oracle Integration includes embedded AI that helps with creating integrations (supported by using natural language), defining schedules, writing documentation about integration components, generating queries (e.g., FHIR, ATP), and resolving errors in B2B .
  • Connection with OCI AI Services and OpenAI: The platform allows use of Oracle Cloud Infrastructure (OCI) AI Services or OpenAI large language models in integrations. That means processes can use text/image processing, content generation, analysis, etc., directly as part of integration workflows.
  • “Use AI to Create an Integration”: A concrete feature allows a user via a natural-language prompt (in a chat interface) to ask Oracle AI to build the skeleton of an integration. The system determines which “nodes” (trigger/invoke), adapters, and connections are needed, builds a draft and lets the developer accept or modify it.

Here are key ways AI supports or accelerates development in Oracle Integration:

Phase of Development  Traditional ChallengesHow Oracle’s AI Helps
Requirement Spec / Planningdefining what systems need to interact; understanding triggers; mapping workflowsUse natural language to describe needed integration; AI proposes flow, nodes, connections. Reduces time in planning and help you to build the skeleton of your rintegration flows
Design / Prototypingdeciding adapters, interfaces; drafting initial workflowsAI suggests adapters, trigger/invoke components; creates skeleton flows that devs can edit. Speeds prototyping
Implementation (Coding / Configuration)manual building of integration flows; error handling; repetitive tasksAI can assist in resolving errors; suggest corrections; provide diagnostics
Deployment / Maintenancemaintaining integrations as systems change; resilience; monitoringAI helps with scheduling, modifying flows; possibly assisting in content or error handling maintenance. ”

Having said that, what’s the benefit coming from AI adoption in development?

I share with you some steps where the conjunction between AI and OIC is for sure a very good help

  • Faster development cycles — less time spent on repetitive or boilerplate tasks.
  • Lower barrier to entry — using natural language turns non-expert users or less technical team members into potential contributors.
  • More consistency — AI can enforce patterns, use standard connections, reduce errors.
  • Scaling & productivity — teams can do more, focus on higher-value logic rather than plumbing.

In my opinion, at the same time, it’s helpful is to get the most out of Oracle’s Integration + AI strategy, Organizations should:

  1. Define clear prompts and use cases — specify systems, conditions, failure handling when using natural language with AI to build integrations.
  2. Review and validate AI’s generated flows thoroughly, especially for critical business logic.
  3. Invest in governance — keep track of which integration pieces were AI-generated, maintain documentation, versioning.
  4. Train teams on AI usage: how to write prompts, how to troubleshoot AI suggestions.
  5. Monitor performance and cost — AI services (especially LLMs) bring compute and data costs; ensure ROI.

I hope this content helps the community something like a sort of brainstorming and at the same time it helped me to point out some aspects

Conclusion

Oracle’s strategy of embedding AI into its Integration platform represents a significant shift in how enterprise software can be developed. By providing tools that allow parts of the development workflow — planning, design, implementation — to be partly automated or assisted, Oracle is helping developers move faster, reduce errors, and focus on more strategic problems.

The future path will require careful balancing of innovation with oversight, but for companies willing to adopt and adapt, the promise is strong: more agile, intelligent, and automated integration development.

Stay tuned … the future is now and several other news are already in plans!

Integration, Process and Visual Builder

OIC makes integration easy with ODI

We know OIC (Oracle Integration Cloud) is capable of file based integration for ERP over API.
And we do know that ODI (Oracle Database Integrator from Data Integration Platform Cloud) is capable of ingesting large file and processing it for ERP through the database layer aka ETL / ELT.

Continue reading “Integration, Process and Visual Builder”

Visual Builder Cloud Service – Dynamic Elements

 

I’ve been using VBCS for awhile now and it has really evolved over the past nine months.  I guess that’s one of the wonderful things about these PaaS offerings from Oracle; we don’t have to wait so long for new features and capabilities.

One thing I wanted to do, but it isn’t directly supported in VBCS yet, is to have dynamic displays.  I’ve done quite a bit of programming in native JavaScript and Oracle JET where I’ve used web sockets to make my graphs and gauges change automatically without the need for a refresh button.

Well, I figured out a way to do this in VBCS.  Now I will admit right away, this is pretty ugly, so if you are a software development purist, please turn off your TV now!

turnofftv.jpg

Continue reading “Visual Builder Cloud Service – Dynamic Elements”

Oracle MFT – OIC Integration

Even in a day and age where event-based and real-time data exchange is prevalent and growing, the truth is there are still massive amounts of data exchanged using file transfer mechanisms.  Oracle has always played in this realm, but with limited success.  The Oracle Managed File Transfer (MFT) application is pretty good, but nothing to write home about… or write a blog about! 😀

One reason is because moving files around and using FTP servers is not very glamorous.  Another reason is because the Oracle MFT management dashboard is pretty limited.  It is able to monitor various aspects of a file transfer, report success or failure and allow you to resend files.  But it has no business context or the ability to understand how a file might be part of a larger business process.

Selection_341

Continue reading “Oracle MFT – OIC Integration”

Teaching How to Invoke REST APIs from Oracle Visual Builder Web/Mobile Apps

In this blog, I am going to show you how to build a nice and simple UI with data coming from invoking REST APIs. All without code, but in just a few clicks.

I consider myself a good backend developer, good at making things functional, but I really struggle every time I need to produce nice UIs. However, using Oracle Visual Builder, I feel like I don’t have to be a UI developer or designer, I can very easily produce nice and friendly mobile UIs that consume my backend REST APIs. If you are like me, a backend programmer who loves API-first design approach, I’m sure that you will find this blog not only informative, but also refreshing.

This is a quick view of what we are going to achieve in this article:

  1. First, we are going to auto-create Service controls in Oracle Visual Builder by pointing to existing REST APIs.
  2. Then, we are going to use the out-of-the box widgets and components to build a simple, yet powerful UI that consumes such APIs.
  3. Finally, we are going to publish the UI and test it across different media, e.g. Web on a laptop, mobile, tablets, etc.

Continue reading “Teaching How to Invoke REST APIs from Oracle Visual Builder Web/Mobile Apps”