DataLoad is an alternative to conventional database interfaces Loads are
built very quickly Data is
supported by system vendors as if it was entered by users Virtually every Oracle Applications system will have legacy or interface data loaded into it at some stage, either during a data migration when the system goes live or on a regular basis after go-live. Oracle only provides open interfaces or APIs for certain data areas, however even where these are provided a large amount of development time is usually required to build and test an interface. Where no open interface or API exists the development may be considerably more complex and the data loaded won't be supported by Oracle Corp.
DataLoad provides a realistic alternative. Data is loaded through the forms thus ensuring that all Applications' validation and processing code is applied to the data. Since the loaded data is indistinguishable from that loaded by users Oracle Support have even recommended DataLoad on Metalink - see Note ID 147380.1. For small or simple loads the Macro functionality is ideal, however the Forms Playback technology in DataLoad Professional enables any size or complexity of load to be quickly built and loaded.
Building a forms playback load is simple. Just enter a record into Oracle Applications and the code to load such data is recorded for you. Open the source code file in DataLoad Professional and the interface has now been built! You can now concentrate on the important tasks of preparing and cleansing the data to be loaded. Once the data is ready the load is run using the Oracle Forms software on the Application server, ensuring the fastest possible load. In tests, data loaded using DataLoad Professional has been found to load almost as fast as conventional SQL interfaces, however the time, and hence cost, required to build the interface is a fraction of that previously required. Once familiar with DataLoad Professional, a user can build and test any interface into Oracle Applications in less than a day, and the interface can be used to delete or update data as well as for data entry.
