shape2
shape2
shape_round
shape_round
shape_round

Oracle Integration Cloud for PeopleSoft File-Based Integration

Table of Contents

    Overview

    Oracle Integration Cloud Service is a comprehensive, secure, lightweight integration solution that enables you to easily connect your applications to Oracle Cloud. It simplifies the connectivity between applications and connects both cloud and on-premise applications. Oracle Integration Cloud Service provides secure, enterprise-grade connectivity regardless of the applications that are being connected or where they reside.

    Concepts on Integration Cloud Service

    Each topic below describes the components required to create an end-to-end integration. The integration includes connections and mappings. You can also include lookups which are reusable mapping for the different codes and terms used in your applications to describe the same item, as well as, grouping integrations into packages.

    Integrations Between On-Premise Applications such as PeopleSoft and Oracle Integration Cloud

    Oracle Integration Cloud

    Integrations are the main functionality of the Oracle Integration Cloud Service. An integration includes a trigger source, a connection for requests sent to Oracle Integration Cloud Service which invokes (target) connection (for requests sent from Oracle Integration Cloud Service to the target), and the field mapping between those two connections. When you create your integrations, you build on the connections you already created by defining how to process the data for the trigger (source) and invoke (target) connections. This can include defining the type of operations to perform on the data, the business objects, and fields against which to perform those operations, required schemes, and so on. To make this easier, the most complex configuration tasks are handled by Oracle Integration Cloud Service. Once the trigger (source) and invoke (target) connections are configured, the maps between the two are enabled so you can define how the information is transferred between the trigger (source) and invoke (target) data structures for both the request and response messages.

    Mappings

    One of the key tasks to any integration is defining how the data is transferred or mapped between two applications. In most cases, the messages you want to transfer between the applications in an integration has different data structure that are mapped between two applications. In most cases, the messages you want to transfer between the applications in an integration has a different data structure. A visual mapper enables you to map fields between applications by dragging source fields onto target fields. When you open the mapper for a request or response message in an integration, the data structure is automatically populated with the information pulled from the source and target connections. You can expand the load data structure levels on demand to display additional levels. There's no limit to the levels of display.

    processOrganization

    Cloud Lookups

    Cloud Lookups are used to create reusable tables that map the different terms used to describe the same item across your applications. A lookup associates values used by one application for a specific item to the values used by other applications for the same item. For example, one application uses a specific set of codes to describe countries, while another application uses a different set of codes to describe the same countries. Lookups can be used for items such as mapping gender codes, nationality codes, currency codes — any type of information that your applications must share with each other but that they represent differently. You may have several lookups for one integration, depending on the number of fields that require mapping. Lookups are also reusable and can be used by multiple integrations. Lookups are based on a static definition, meaning you create and populate them during design time, and are not changed by runtime activities. These tables are used for looking up values only.

    Cloud Service Packages

    You can also group one or more integrations into a single structure called a package. Packages enable you to easily import and export a group of integrations to and from Integration Cloud Service. You can import the packages from the Oracle Marketplace. These packages consist of a series of pre-built integrations provided by Oracle. You can even import and export packages that consist of integrations that you or other users create. Packages are optional, meaning that integrations do not need to be part of packages. However, for a package to exist, it must include at least one integration. Packages cannot be locked to exclude other users of your Integration Cloud Service instance. Packages are displayed on the Packages page in Integration Cloud Service. From this page, you can view, delete, import, and export packages. You create packages when you create an integration in the Create Integration dialog. You can also update an integration's package in the Update Integration dialog.

    Packages

    Agents Between On-Premise Applications and Oracle Integration Cloud

    Oracle Integration Cloud Service provides an agent framework that enables you to create integrations and exchange messages between on-premises applications and Oracle Integration Cloud Service. Message payloads of up to 5 MB are supported through the use of compression, which may bring the payload down to 512 KB in size. The on-premises agent provides multi-threading support, which allows for multiple executors to perform downstream message processing.

    Monitoring

    The Integration Cloud Service Dashboard displays information on the current state of all your running integrations. The dashboard gives you a quick view into the performance metrics of all your active integrations. The graph includes the total number of messages processed, the average processing time, the number of messages with errors, and the success rate. The integrations tab lists metrics for each running integration, and you can view a graph of the metrics for each integration in the list. The dashboard also provides a view of recent activity for running integrations and the ability to download all activities.

    Error Management

    You can manage integration errors from the Errors Page in the Integration Cloud Services. The Errors Page displays information about individual integration instances and groups the errors by integrations and connections over a specified period of time.

    Errors by integration

    Creating an Integration for Simple File Transfer

    • Log in to Oracle Integration Cloud. Using the menu on the left hand column, navigate to the Designer. Go to Connections and create the source and destination connection.


    oracle integration
    • Enter the Source connection details.

    ftp source
    • Enter the Destination connection details.

    oracle integration
    • Create an Integration using the FTP adapter and the connections created in the above section.

    oracle integration
    • Create the Integration workflow.

    oracle integration
    • Place the file in source destination.

    oracle integration
    • Activate the integration.

    oracle integration oracle integration
    • Execute an ad hoc run.

    oracle integration
    • Monitor the run.

    oracle integration
    • Track the run results.

    oracle integration
    • Below is the workflow post of a successful integration execution. The green color for each task shows successful completion.

    oracle integration
    • View the activity stream.

    oracle integration
    • Successful File transfer.

    oracle integration

    Conclusion

    Oracle Integration Cloud allows you to seamlessly integrate applications and data by leveraging an extensive library of pre-built adapters to connect with virtually any application, service, or database. Oracle has adapters covering Oracle Sales Cloud, Oracle Service Cloud, Oracle Marketing Cloud, Oracle E-Business Suite, Siebel and JD Edwards, as well as many non-Oracle applications including Salesforce, ServiceNow, and SAP.With Oracle's comprehensive integration platform, you can:

    • Accelerate integration using a point-and-click visual designer, pre-built adapters, and process flows.

    • Integrate all types of applications, databases, and business processes.

    • Maximize the value of your investments by connecting data and processes across all applications.

    Ready to get started with Oracle Integration Cloud? Shedule a meeting with an Astute team member.

    Schedule Meeting
    Jyoti Shah

    Jyoti Shah is a senior OCI Architect and PeopleSoft Architect/DBA at Astute Business Solutions. She has experience managing large PeopleSoft environments and performing Peoplesoft upgrades.

    See The Team In Action

    Upcoming Events

    In-person
    Oracle-Cloud-World
    September 18, 2023
    09:00 AM ET
    • Everyone
    • Oracle cloud

    Oracle Cloud World

    In-person
    HEUG-Central
    October 2, 2023
    09:00 AM ET
    • Everyone
    • Peoplesoft

    HEUG Central - Illinois

    Virtual event
    Kibana-for-CS-Deep-Dive
    October 4, 2023
    04:00 PM ET
    • Non-technical
    • Peoplesoft reporting

    Kibana for CS - Deep Dive

    In-person
    HEUG East - North Carolina
    October 9, 2023
    09:00 AM ET
    • Everyone
    • Peoplesoft

    HEUG East - North Carolina

    Virtual event
    PTF-Webinar-Series--featured-image_v2-1-1
    October 11, 2023
    04:00 PM ET
    • Technical
    • Peoplesoft testing

    Webinar: Mastering PTF - Tips and Tricks for CS

    Virtual event
    event1-1-1
    October 23, 2023
    04:00 PM ET
    • Everyone
    • Peoplesoft

    Virtual Conference: RECONNECT Dive Deep

    Reach Out

    Ready to Connect?

    Please fill the following form, we will get back to you within a business day.

    Contact Form

    Contact Us

    Schedule an
    Appointment Now

    Meet with an Astute expert today, we would love to help you think about your enterprise applications, and how the cloud can deliver greater value to your customers.