Wednesday 6 September 2023

Load Data using ADFdi – ADF Desktop Integration

 

 

Click on ‘Navigator’ and click on ‘Tools’ and then click on ‘Download Desktop Integration Installer’

You will ‘adfdi-excel-addin-installer’ .exe file downloaded in your local machine, run ‘adfdi-excel-addin-installer.exe’

Go to Excel Spreadsheet  and click on File > Options >’Add-ins’

Click on Manage and select ‘COM Add-ins’ from list of values or drop down.

Click on ‘Go’ button

Click on the checkbox ‘Oracle ADF 11g Desktop Integration Add-In for Excel’, ignore if it is already checked.
Click on the ‘OK’ button

Go back to File > Options >’Add-ins’

‘Oracle ADF 11g Desktop Integration Add-In for Excel’ will be available under ‘Active Application Add-ins’

Now you are all set using ADFdi Desktop Integration

Prerequisites

1) Download Desktop Integration Installer
2) Run ‘adfdi-excel-addin-installer’
3) Go to Excel Spreadsheet
4) Click on File > Options >’Add-ins’
5) Click on Manage and select ‘COM Add-ins’ from list of values or drop down
6) Click on ‘Go’button
7) Click on the checkbox ‘Oracle ADF 11g Desktop Integration Add-In for Excel’ , ignore if it is already checked
8) Click on OK button
9) ‘Oracle ADF 11g Desktop Integration Add-In for Excel’ will be avaiable under ‘Active Application Add-ins’

Now you are all set for using ADFdi Desktop Integration.

Scenario:

Lets quickly see how to provide data access to users using ADFdi Desktop Integration.

 

No comments: