OData adapter in Oracle Integration-3
With the release of Oracle Integration 23.04, the Oracle Integration adapter-3 portfolio has been increased and one of the featured adapters is OData which is introduced in this release. This article will help you understand all about this adapter and what capabilities it offers.
LEARN ORACLE INTEGRATION END TO END
AN END-END-END ORACLE INTEGRATION COURSE THAT WILL HELP YOU TO LEARN ORACLE INTEGRATION QUICKLY.
CLICK HERE TO BUY THIS COURSE.
What is OData adatper
OData adapter is one of the out of the box adapter that allows it to integrate with application that exposes data using OData services.
The OData Protocol is an application-level protocol for interacting with data via RESTful interfaces.
OData adapter capabilities
The Odata adapter supports the following operations on selected entities (Customers, Orders, Invoice, etc):
- Create
- Update
- Delete
- Get
- Query
- Replace
Along with this, the following Query operations are supported:
- $expand
- $select
- $filter
- $orderby
- $inlinecount
- $top
- $skip
OData adapter Security Policy
The OData adapter supports the following security policies:
- Basic Authentication
- OAuth Client Credentials
- OAuth Authorization Code Credentials
- No Security Policy
Pre-requisites to create OData connection
The followings are the pre-requisites to creating the OData connection:
- OData service root URL
- Security Policy credentials
Following is one of the public OData services which can use to play with the OData adapter:
https://services.odata.org/V2/Northwind/Northwind.svc
If you like this article, please like, comment, and share. Request you to subscribe to my YouTube channel for more such videos and don’t forget to subscribe to our channel to get regular updates.
Further readings:
Place the file in ATP from BIP using OIC
Place the file in Object Storage from BIP using OIC
How to write files using an OIC FTP adapter
Read files from Object Storage in Oracle Integration