Advanced ETL Processor Free Download at datapicks.com - Extract, transform, validate and load data into ANY database

Download link
Size	8517KB
License	Shareware
Price	340
Category	0 / 0
Operating System	WinXP,Windows2000,Windows2003,Windows Vista Ultimate,Windows Vista Ultimate x64,Win98,WinME,WinNT 4.x,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Windows Vista Business x64,Windows Vista Enterprise x64
Developer	DB Software Laboratory

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.

Advanced ETL Processor works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.

Another benefit of using Advanced ETL Processor its unique ability to load data from multiple files or even tables using mask

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Top Database & SQL / Software Development programs

1) CASE Studio 2 v 2.23
Powerful database design tool which allows you to visually create Entity Relationship Diagrams (ERD) for various database systems - MS SQL, Oracle, DB2, MySQL, InterBase, Sybase etc. Features: ERD, SQL script generation, Reverse engineering...

2) Visual Open DB 1.75
Visual Open DB is a generic data analysing application that allows you to query any valid data source. It can be used by end users to perform data analysis and developers to interrogate database tables and views.

3) Aqua Data Studio 4.0
Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create edit and execute SQL scripts as well as browse database structures

4) DBF Viewer 2000 2.45
DBF Viewer 2000 is a powerful, compact and easy-to-use viewer and editor for DBF files. You can view, edit, sort, use query by example, delete duplicates, create, print database tables a export the data from them to a variety of formats.

5) DB Explorer 3.0.0
Compare two database schemas and/or table data rows and report differences. Synchronise the differences for one or other database. Sync Schema generates the SQL DDL statements. Sync Data either transfers the rows or generates SQL DML statements.

6) DBF to CSV 2.01
The DBF to CSV program allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats

7) TOAD for Oracle Freeware 8.5
TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration.

8) SQLite3 database manager LITE 3.1
SQLite3 database manager. Development tool for managing all database objects. SQL builder.

9) GIS ObjectLand 2.6.5
GIS ObjectLand is a universal Geographic Information System for Windows. Key features: vector-raster maps; multiuser data editing; import/export for MIF/MID, SHP, DXF, DBF, CSV; access permissions for users; using other DBMS (ODBC); COM interfaces.

10) Exportizer Pro 3.7
Exports database tables (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, TXT, CSV) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.

New Database & SQL / Software Development programs

1) MyDeveloper Studio 3.00 beta
Powerful database development and administration environment for MySQL. Presents a large set of database tools for simplifying interaction with MySQL and automating the database development process. Has a unique built-in stored routine debugger.

2) SQL Data Examiner 2.2.0.20
SQL Data Examiner 2008 is a multi-platform data comparison and synchronization tool that merges selected databases with just a few clicks. The tool simplifies the process of data migration and saves hours of boring manual work.

3) Mexico Postal Code Database (Gold Edition) July.2008
Mexico postal codes database subscription. The database includes postal code, city name, colony name, state code, state name, latitude and longitude, time zone and area code in Mexico.

4) MS Access Print Multiple Objects Software 7.0
Print many MS Access tables, queries, forms, pages, modules, macros and reports without having to open each one. MS Access 2000 or higher required.

5) Oracle Copy Tables to Another Oracle Database Software 7.0
Copy tables from one Oracle database to another. Provide the login information for both databases.

6) FoxPro Copy Tables to Another FoxPro Database Software 7.0
Copy tables from one FoxPro database to another. Provide the file locations for both databases to connect. Connect to FoxPro via DBC file or multiple DBF files in a folder.

7) Export Query to Text for SQL Server 1.04.22
Export Query for Microsoft SQL Server helps to save a query results to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of SQL Server are supported.

8) MySQL Copy Tables to Another MySQL Database Software 7.0
Copy tables from one MySQL server to another. Provide the login information for both databases.

9) MS Access Copy Tables to Another Access Database Software 7.0
Copy tables from one Access database to another.

10) SQL Script Builder 1.6.3.53
SQL Script Builder is powerful software that create a database file or sql script from any ODBC data source. The script or file will migrate the table(s) and the records. Scripts comes in 5 formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL.