Sitemap
Manikanta kumar K

Manikanta kumar K

17+ Years of experience in IT industry | Oracle Cloud Integration Specialist | OCI | Certified OCI Architect, Developer, Operations Professional

OIC Topics-Use cases

2 min readAug 28, 2024

Learn through Real Time Use Cases

Introduction

Adapters and Connections

Integration Patterns

Rest and SOAP Services:

  1. Sample REST service — Trigger and Invoke
  2. Sample SOAP service — Trigger and Invoke

File/SFTP ::

3. Read Files from SFTP server in chunks

4. Split CSV based on a column

5. Create Fixed length file in OIC

6. Internal or Embedded SFTP (File Server)

7. Process different types of files: >100MB, >1GB

FBDI ::

8. Load Suppliers data in Oracle Fusion ERP using FBDI.

9. Configure Callback

Events ::

10. Publish to OIC, Subscribe to OIC

11. Business Events from ERP. Filter the events from ERP.

ERP Adapter ::

12. Outbound and inbound

Database ::

13. Connect ATP DB with/without wallet

14. Call DB Procedure asynchronously from OIC

15. PL SQL procedure call in batches.

16. Read millions of records from DB

17. Bulk Insert into a table

18. Insert into multiple tables having relationship

BIP ::

19. BIP Report execution with/without parameters.

20. Retrieve BIP report and place File in OCI Object Storage.

21. Overcome BIP report timeout.

Get Manikanta kumar K’s stories in your inbox

Join Medium for free to get updates from this writer.

22. Bursting of BIP report

REST ::

23. Push records in batches to target service in Oracle Integration

24. Multiple VERBs in Gen3

25. Accept attachments in REST API — Inbound and Outbound

Error Handling and REST:

26. Build Retry logic using scope, Global Fault Handlers, recursive REST calls.

VBCS ::

27. Basics of VBCS

28. Invoke VB Business objects in OIC

OCI features in OIC ::

29. Invoke OCI Functions from OIC

30. Data Science: Extract data from images using OCI vision service in Oracle Integration

31. Encrypt/Decrypt data using OCI Vault

32. Publish/Subscribe OCI Streaming messages

33. Invoke ERP ESS job in OIC

Connectivity Agent ::

34. Connectivity Agent setup, High Availability

B2B ::

35. Schmas, Documents

36. Trading Partners, Host Profile

37. Stand-alone B2B Mode with one use case.

38. Trading Partner mode with one use case.

Security::

39. OAuth Two Legged Authentication

40. Private End Point

OIC Gen2 — Gen3 ::

41. OIC Gen2 Vs Gen3

42. Projects in Gen3.

Observability ::

43. Monitoring & Tracking Instances

44. Feature Flag in OIC

45. Recipes and Accelerators

46. Some OIC New Features

--

--

Manikanta kumar K
Manikanta kumar K

Written by Manikanta kumar K

17+ Years of experience in IT industry | Oracle Cloud Integration Specialist | OCI | Certified OCI Architect, Developer, Operations Professional