difference between SQL* Loader and ADI.

[jyothisatheesh]

Hi

Can anyone please explain the difference between SQL* Loader and ADI.

Thanks,
Jyothi.

[oteixeira]

Hello Jyothi.

Web ADI works togheter with MS Excel. Oracle has developed some spreadsheet templates (that you can modify) to load data into database. Through ADI you can upload journals, assets, etc...
ADI is easy to use because you don't need to know much about the technical part, you just have to fill in the data into the spreadsheet and upload it to the database. If there are errors will you be notified into the spredsheet itself.

Sqlloader it is also used to upload data into the database but you need to know a lot more. You must know exactly which columns you are going to populate. Data is generaly structured into a flat file (comma separated, for example) and you need to create a sqlloader script file to load the data. The data upload is executed from the OS command line.
Sqlloader is much faster then ADI.

Octavio

[jyothisatheesh]

Thanks for the reply.

[HSmook]

Hello,

To sum up the main details;
- Oracle SQL*Loader is a tool used by Technicians to bulkload data into an Oracle database's table's.
- Oracle ADI / GLDI is a tool used by the more functionally oriented user to push and pull data from Oracle e-Business suite / Oracle Applications databases straight into MS-Excel's spreadsheets and vice-versa.

Oracle's SQL*Loader (sqlload) is a tool which allows the more technically adept user to bulk-load sets of data quickly into an Oracle database.
It can be used on any Oracle database, and by any user with access to the database(-server), the data accessed through the specific database schema's (users and the objects the user is allowed to see / manipulate) through the back-end. You can manually run the program with several parameters from the commandline or you can use a so called parameterfile which holds all the relevant parameters such as schemanames, passwords, loadsize and a parameter which specifies what data should be loaded, like the name and location of a comma separated value-file (.csv file)

There is an Oracle Applications / Oracle e-Business Suite specific equivalent tool called FND*Loader (fndload) which is used mostly by DBA's to import and extract Foundation specific data, this tool is one of the most valuable tools an Oracle Apps DBA has in his / her toolkit, since it can rip out and shove in entire menu structures, forms data, flexfield data, Oracle Applications usernames and profiles etc, etc, etc, from one Oracle Apps instance to another, making it one of the DBA's most valuable tools to use in, say, the cloning process of an instance amongst others.

Oracle ADI (Applications Desktop Integrator) is more like a higher-level functional reporting tool for (usually) Oracle Financials functional users.
With this application which used to run on the user's pc, but moved to a more webbased tool, allows for Oracle Financials functional users to push and pull data from an Oracle Applications / Oracle e-Business Suite instance, straight into an MS-Excel spreadsheet and vice versa.
It uses a number of pre-defined Excel templates to be able to do this.

Hope this helps.

Regards,

Harm Smook