Friday, July 16, 2021

Difference between FBDI, ADFDI and Web Services in Oracle Fusion

When it comes to Interfaces/Conversions and Integrations, Oracle ERP Cloud offers variety of options to be utilized based on business requirements. FBDI, ADFDI and Web Services are amongst the most commonly used ones.

Let's see how these are different from each other and what then can be used for.
 


File-Based Data Import (FBDI)

Application Development Framework Desktop Integration (ADFDI)

Web Services 

Recommended for bulk data conversions & feeds from external systems

Recommended for regular loads/updates based on manually compiled data

Standard way to integrate two web-based applications

Data file prepared offline - Not connected to cloud instance

Excel sheet connected to the instance - Similar to WebADI in EBS

Web based APIs that can be accessed by heterogeneous systems

Validation is done after full upload

Excel validation via list of values

Validation after making the web service call

Requires moderate technical expertise

Very user friendly

Highly technical

Extensive data preparation effort

Less effort in preparing excel data

Less effort in preparing data for desired tags in API calls

Very fast upload

Slower upload compared to FBDI

Considerably slower due to row-by-row operations

No plugins required

Works via desktop Excel plugin

Custom integration processes to invoke inbound/outbound SOAP/REST APIs

Bulk load via CSV files

Data upload directly from Excel

Custom integration processes to invoke inbound/outbound SOAP/REST APIs


Share:

3 comments:

  1. Nice to see a comparison. I'd love it if you could add More4apps to this. Take a look at the data preparation and upload process compared to More4apps in this youtube video below.

    https://youtu.be/hPQgD8H9UxY

    ReplyDelete
  2. Good way to show the differences in simple and easy way.

    ReplyDelete