File or Folder Polling
In some situation you have to load the data whenever a CSV/Text file
appears in a folder. The files will be of same structure i.e. having
same number of fields, same delimiting char, but the filenames will be
These files could be generated by a third party program running in the same computer or on a different computer (might be running Unix o/s) or received through FTP.
The Data Loader will repeatedly check to see if the files which matches a particular pattern, mentioned by you, have appeared in the specified folder. And as soon as files appear Data Loader will load the data from these files into target table residing in any database (Oracle, MySQL, MS SQL Server, MS Access, Foxpro, Visual Foxpro, Text). After loading, the files are renamed to prevent loading the contents again.
How often Data Loader will watch a folder is determined by the interval you specify, a typical interval might be 1 Minute or every 1 hour or every 6 hours.
You can check the progress such as which files have been loaded and how many rows are loaded from which file and whether any errors have occurred in the log file.
This feature is available only in Professional and Enterprise Edition.
|I really like the
simplicity of Data Loader.... Kirsten
Data Loader is making my transfer job from Oracle to Text files very easy and fast. Previously I have to use lot of SQL commands to achieve this. Thanks to Data Loader....Ronald
|Try Forms Data Loader to Load Data through Front End Forms using Macros. Download Free Trial Version Now|