OIC Topics-Use cases

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.

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