This is a piece of software that lets an application integrate data import/export facilities easily.
Most current applications need the capability to import and/or export data from many databases. One would need to manipulate the low level APIs for the well known databases such as Oracle, MS SQL Server, MySQL, Interbase, Firebird, PostgreSQL, ODBC Ole DB, plus full support for flat files, MS Excel, MS Access and DB files This Data Exchange Wizard ActiveX is able to work with these databases. Besides data extraction, the application is able to convert one database files to another format easily. Once integrated, the ETL ActiveX will let you offer a fully functional universal Import/Export routine. You are able not only to cut down the development time but the consequent development cost too. A large number of records can be handled and you would be able to execute SQL statements before and after import/export of the data.
The component has an integrated expression builder that will help find and get records easily. A comprehensive error log will help you troubleshoot the transfer process, when something does go wrong. Data preview is a meaningful tool for ensuring you are getting or sending the right data. Rejected records file adds to the features that help, making sure the transfer is going to be alright. You could do cross tables loading and a mapping editor helps with such cross tables loading. You should be able to write up SQL scripts to help with data import/export. The interface presented when you have the component integrated, is wizard driven and quite easy to use. The interface provides all the set up necessary to start a transfer. If you are in the business of developing a business application that needs data transfer, here is a component that could be integrated quite easily!