Skip to content

Latest commit

 

History

History
120 lines (71 loc) · 8.42 KB

Intro.md

File metadata and controls

120 lines (71 loc) · 8.42 KB
Raw

Oracle Integration (OIC) Generation 2 + File Server information

..this page is a continuation of my overarching OIC knowledge repo here.

This page details:

  • Why you should upgrade to OIC generation 2 and how to use it
  • Using the OIC File Server (gen2 only)
    • Configuration
    • Use cases
      • OIC log collection, BICC, Oracle SaaS import/export, other APIs
    • Best practices
    • Videos
    • FTP tools

Oracle Integration, Generation 2

Main Documentation for OIC Gen 2

Oracle Integration Generation 2 is the next generation of our Oracle Integration platform. This upgrade delivers improved performance and reliability as well as significant improvements in provisioning and other lifecycle management activities by more deeply leveraging the power of Oracle Cloud Infrastructure.

Lists all benefits of Gen 2 over Gen 1 - more than just the File Server!

  • OIC generation 2 enables OIC to be managed by the OCI API, you can see an example of interacting with OIC via the OCI API here.

How to upgrade from Gen 1 to Gen 2 - it's easy as 1, 2, 3 and doesn't cost extra $

  • You can also manually export your integrations, processes, and VBCS apps. Spin up a gen 2 instance, and then import those to your new environment. However, your instance URL will change and you will need to reconfigure your connections & users & potentially more. IF this manual process is verified 100% to work for you - then you can delete your gen 1 instance. This is not the default recommended approach, but it may be satisfactory for some.

IAM roles for OIC Gen 2

  • With generation 2, you still use IDCS to manage permissions of what users can on the OIC Service Console, but for managing OIC on the OCI console, that is managed by IAM. Click here to learn more about identity federation on OCI. This and other tasks are explained on the main documentation for gen 2.

"How do I know if I have gen 2 or gen 1?" - Here's how to access each in the OCI console:

  • Oracle Integration Generation 2: Application Integration -> Integration
  • Oracle Integration Generation 1: Platform Services -> Integration

File Server

Main file server documentation

PDF form of documentation

The file server does not cost any extra money. If you use it in integrations, it will count towards your billable messages.

Configuration

Follow these steps to configure your file server

To configure the file server with the FTP adapter in OIC

  • You can use a ssh key you upload for your user or their password. On the adapter page, you need to set the SFTP connection selectBox to yes. You can get your IP address and port from the Settings -> File Server page in your OIC instance. Make sure your user is enabled and has write access. Inside your integration, you need to use the folder for which your user has write access.

User permissions and enabling users

Use Cases

1. OIC log collection & analysis

  • You can call this OIC endpoint, and have your OIC logs stored on your embedded FTP server and/or sent to object storage for analysis by your security platform of choice, such as Oracle Management Cloud.

2. BICC Extract from object storage to File Server

You can extract information from Fusion SaaS using BICC.

To extract data from a Fusion Applications Cloud data source, you use the BI Cloud Connector Console to schedule a once-only or regular data load, known as a Cloud Extract. For example, you might extract data from Oracle Fusion HCM Cloud. You can load the extracted data into an Oracle Cloud Object Storage bucket or into an Oracle Universal Content Management (UCM) server.

Configuring BICC with Object Storage

3. Pulling to/from external system

Best practices for handling files in OIC

File Handling Primer

File integration best practices

  • How to handle the file depends upon its size, where it’s from, and what you want to do with it. For using the FTP adapter in integration, you will typically use scheduled integrations - maybe app-driven if you’re having an API append rows to an existing csv file.

Scheduling scheduled integrations

  • This shows how to use iCal expressions to set up more complex schedules with OIC.

Videos

The latest videos describe some key components used creating an integration to import and process bulk files using the FTP Adapter with Oracle Integration:

FTP tools

cyberduck

filezilla

  • the above are both clients you can use with your laptop to access FTP servers

Python with sFTP

  • the OIC file server uses sFTP protocol

Closing comic

Thanks for reading, hope it was helpful. Find me on LinkedIn.

comic