Oracle Integration Cloud(Paas/iPaas)

• iPaas- Integration Platform as service
• Set of automated tools to connect software applns deployed on different environments
• Often used by large B2B enterprises
• Why to integrate
• To transfer data

Integration considerations

• Data format
• Frequency of data
• Mapping(source to target)
• Destination location(ftp, file location, DB)

Scenarios

• Cloud - Cloud
• Cloud- On-Premise

Process of integration

Adapter

• One that has business logic to invoke a particular service
• eg: facebook - Provide configuration like service, username, password then it works

Integration Style/pattern

• App driven orchestration 
• Uses Event or Business Object as trigger which can be invoked by an application or API
• an API will be exposed that can be triggered by appln
  
• Basic routing
• Scheduled
• trigger based on time or data
  
• File Transfer
• to move files from one network to another
  
• Publish to oic
• Publish message to OIC managed topic
  
• Subscribe to oic
• Subscribe to oic managed topic and push to db
  

Connections

• Defines the application you want to integrate with
• SaaS adapter
• social adapter
• technology adapter
• on-premise adapter

Integration

• Connection -> Select Adapter
  
• Integrations -> select integration style
  

• Outbound Integration with Fusion using Oracle ERP cloud Adapter
• Business Event is the trigger
  
• Outbound Integration using REST api
  

Import AP Invoice Using Oracle Cloud Adapter

• To Import data using FBDI - ImportBulkData operation of ERPIntegration Service can be used to perform following steps
• Upload files to UCM
• Submit Load interface file for Import
• Submit import process
• invoke callback service URL
• docs.oracle.com -> integrate -> review soap services -> Business object services -> erp integration service
  https://server/fscmService/ErpIntegrationService?WSDL  -> importBulkData
  Provide job name, parameter list
  provide call back service
• REST
• docs.oracle.com -> integrate -> review rest services -> Business object services -> erp integration service
  https://server/fscmRestApi/resources/11.13.18.05/erpintegrations
  
  
• local FTP Location for FBDI Invoice Import : /APInvoiceInbound directory
  
• Connectors Required: FTP Connector, ERP Cloud Connector
• Integration:
• Read file from Inbound directory
• Map to local to erp data: file reference, file name & Directory
  
• invoke ERP cloud endpoint
• action: import bulk data
• Operation: import payables invoice
• ucm account: fin/payables/import
•