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!

Oracle Integration Cloud Autonomous Transaction Processing Adapter Configuration !!!

Oracle’s two major ground breaking innovation last year were Autonomous Data warehouse (ADW) and Autonomous Database Transaction processing (ATP) both are database offering suitable for different workload and are self-driving, self-securing, and self-repairing in nature. If you want to read more about these services then please go through above links.

ADW/ATP both can be quickly provisioned on Oracle Cloud Infrastructure, it’s take less than 5 minute to spin ADW/ATP instance and database is ready to connect.

User can use Oracle SQL Developer to connect to ADW/ATP database as long as they are supported version. These DBaaS services also offers out-of-box browser based SQL Developer tool which can be used to run any kind of SQL statements.

Here is sample snap of browser based SQL Developer capabilities –

8.png

 

Once user has Database ready, obviously there could be requirement to access data residing inside ADW/ATP instances.

Fortunately, Oracle Integration Cloud provide Adapter for connecting ADW/ATP instance, click here to know more about ATP Adapter capabilities –

In this blog I will be covering simple steps how you can connect to ADW/ATP instances using OIC Autonomous Transaction Processing Adapter (ATP) Adapter.

I made assumption that ADW/ATP instance already exists. if you not sure how to create ADW/ATP instance then refer this blog which was written by my colleague who already explained how to create ADW/ATP database instance and connect from SQL developer.

So, let move forward. Login to your Oracle Integration Cloud (OIC) home page >> Integration >> Connection >> Create >> search for “Oracle ATP” >> select the same

01

Continue reading “Oracle Integration Cloud Autonomous Transaction Processing Adapter Configuration !!!”

Simplified OAuth Config for Oracle Integration Cloud REST API using Postman !!!

This blog will be discussing very specific use case requirement which is more developer oriented and providing a quicker and efficient solution to invoke Oracle Integration REST API using OAuth access_token for testing purpose.

As an integration developer time to time you need to invoke Oracle Integration REST API to test API functionality. All the REST API in OIC needs a header parameter called “Authorization” which must needs to hold a valid access_token value in this format “Bearer access_token“.

In above format, “Bearer” is static world, However, access_token is the token value which we get after successfully OAuth Authentication from Oracle Identity Cloud Service.  Getting access_token from IDCS using code credentials flow is multi steps and cumbersome process.

However, developer can leverage Postman environment and variable features to simplify the process of getting access_token. That’s what, I will be covering in this blog.

Before I proceed further, I must redirect you to read my colleague blog which has greater in-depth explanation about what is IDCS, how IDCS govern security aspect of all Oracle PaaS products such as Oracle Integration Cloud, Analytics Cloud, Digital Assistant and so on and OAuth client and token generation process etc. I am recommending you to read his blog because I will be using few artefacts e.g. IDCS URL, Client ID, Client Secret etc which we need to get from IDCS OAuth Client Application as per the process given in his blog.

Continue reading “Simplified OAuth Config for Oracle Integration Cloud REST API using Postman !!!”

Retrieve Custom Fields from NetSuite using Oracle Integration Cloud NetSuite Adapter !!!

This blog is showcasing very specific use case related to NetSuite Custom Field retrieval and how we accomplish that using Oracle Integration Cloud NetSuite Adapter.

In this example we will be retrieving custom fields values e.g. birthDt from NetSuite by passing specific Customer Id. It may sound very easy but it was bit complex to deal with because the way how NetSuite was responding Custom Fields values using NetSuite Adapter.

Here is the use-case diagram –

1.png

In my previous blog I have already shown all the configuration which needs to be done to connect to NetSuite using Oracle Integration Cloud NetSuite Adapter and deal with NetSuite Custom fields. Hence, this blog will just focus on specific mapping challenges which I have faced initially during implementation.

Continue reading “Retrieve Custom Fields from NetSuite using Oracle Integration Cloud NetSuite Adapter !!!”