Data Import in Oracle Cloud - ADFDI and FBDI
Data Import in Oracle Cloud - ADFDI and FBDI
Data Import in Oracle Cloud - ADFDI and FBDI
ADF Desktop Integration extends the Oracle Application Development Framework into the world
of desktop applications like Microsoft Excel. Application developers can rapidly develop
integrated spreadsheets to allow users to access and edit critical business data. This framework
integrates seamlessly with the web application's security and business logic infrastructure. It
allows end users to edit their data without a live connection to the network. Once reconnected,
ADF Desktop Integration can transparently upload and validate all user changes against the
application's backend.
In Oracle Cloud generally, data is uploaded through two ways i.e. FBDI and ADFDI. If the data
volume is not very big, ADFDI will be the best option as it directly connects to the application
and user can check and refer many values online like COA Values, Ledger, Data Access and
many more.
As ADFDI Excel sheet is connected with the application, it will not allow to upload the invalid
values. Just like any other excel we can copy and paste the values. The user can also search
the values just by double-clicking the cell. This online selection and validation tool make ADFDI
as a better tool than FBDI. ADFDI file can also be used for deleting the lines which are stuck in
the interface.
To be able to use ADFDI excel spreadsheet, users would be required to download and install
the tool on their local machine. The download process is generally divided into two parts i.e.
Download and install the ADFDI Plug-in for excel and Excel Setup to enable and allow the plug-
in to function in desired manner. It is fairly simple and there is no need for any technical
knowledge. The user can install it with basic computer knowledge also.
Installation Procedure:
1. Log in to Oracle Cloud Application
2. Go to Navigator → Tools → Select “Download Desktop Integration Installer”
3. Save and Install the downloaded file
Excel Setups
a. Open any Excel File and Navigate to the “File” option
b. Select the Excel “Options”
c. Go to “Trust Centre Settings”
d. Navigate to “ActiveX Setting” and confirm whether the right option is selected