| |
|
Business
/ Databases & Tools
|
|
|
|
|
|
Advanced ETL Processor - 2.2.3
|
Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the ‘Preview’ button and see what the results of an ETL flow would look like.
Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the ‘Preview’ button and see what the results of an ETL flow would look like.
Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.
The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.
It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.
If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.
|
| Software Requirements: |
|
Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003
|
| This software is designed to run on the following operating systems: |
|
Windows 2000, Windows, Windows 2003, Windows 98, Windows Me, Windows NT, Windows Vista, Windows XP
|
| Keywords: |
|
Powerful Etl Tool, Oracle, Ms Sql Server, Bcp, Sql Loader, Odbc, Etl, Data Transformation
|
| Download Links: |
|
|
|
|
|
|
|
| Feedback Summary: |
Show All Feedback (0)
|
|
|
|
 |
|
|
|
| Advanced ETL Processor related software |
| Title / Version / Description |
Size |
License |
Price |
| DEWizardX 3.4.0 | 3.6 MB | Shareware | $100 | This ActiveX helps you to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database
Uses naitive API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export .
Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering
... |
|
| Data Loader 2.5 | 2.7 MB | Shareware | $99 | Data Loader is a simple yet powerful tool to import and export Data between many common formats. Current Data Loader Ver. 2.0 supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBF's and Delimited or Flat Files. You can use Data Loader to transfer data from one database format to another database format. While transferring you can filter columns and specify WHERE conditions.
It supports Long , Picture Data types. In a jiffy you can... |
|
| Data Exchange Wizard 3.4.4 | 3.6 MB | Shareware | $100 | Data Exchange Wizard imports data from a text file, a Microsoft Excel spreadsheets, or a Microsoft Access databases into any database, including Oracle, MS SQL Server or any ODBC compliant database. Alternatively, data from Oracle, MS SQL Server or any ODBC source can be exported into flat files. The export and import operations are automatic and do not require advanced technical knowledge and skills.
Data Exchange Wizard may run... |
|
| VImpX 4.7.7 | 3.0 MB | Shareware | $100 | ActiveX which Loads data into Oracle ,SQL Server, ODBC Databases from flat files, cross tables or ODBC datasources.
Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statemts before and after import.
Integrated expression builder, comprehensive error log, rejected records file.
Data targets:
Oracle 7-10g database (using OCI API)
SQL... |
|
| Data Monkey G.D.H. 2.0.0 | 5.0 MB | Shareware | $269 | Data Monkey GDH is an ETL and Database Administration application that works with ODBC compliant data sources. With this one tool you can move and manipulate data between ANY odbc compliant data source. With Data Monkey GDH you are able to run adhoc SQL statements the way you would in applications like Toad, SQL plus or Query Analyzer making it a great tool for database administration, but with Data Monkey GDH, you use the same tool, with the... |
|
|
|
| Other popular software in this category |
| Title / Version / Description |
Size |
License |
Price |
| MSSQL to MySQL Database Converter 2.0.1.5 | 1.3 MB | Shareware | 1980INR | Database converter is a powerful tool which makes the conversion from MS SQL server to MySQL easy and reliable. You can even convert your large database which contains thousands of records in a matter of a few seconds even if your database merges multiple tables or rows. The database converter software is fully capable to convert entire database or selected table's records easily and efficiently. MSSql to MySql database migrator supports all... |
|
| Free Database Compare 1.0 | 435.0 KB | Freeware | | The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you have a regularly update database and want to check if the all the changes to the database were committed successfully. After comparing you will be allowed to... |
|
| Biometric Employee Time Clock 2.4 | 12.8 MB | Shareware | $99 | Fingerprint authentication, network support, more detailed reports, QuickBooks® integration, door access control, plus quick and easy setup; make Biometric Employee Time Clock 2.0 the most powerful time and attendance solution to stop time theft.
Biometry is the most accurate way to collect employee time and attendance information. Instead of badges or passwords that can be lost, forgotten or shared, the Biometric Employee Time Clock... |
|
|
|
|
|
|
| |