Download Advanced ETL Processor 2.1.1

Tops and Ratings

Advanced ETL Processor Description:

Advanced ETL Processor is Shareware program for Windows developed by DB Software Laboratory

Advanced ETL is a occupation intelligence implement that provides solution seeking Extracting, Validating, Transforming and Loading information between unalike information sources and targets.

Extraction:

* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases
* Multiple DBF Files
* Any ODBC origin
* Multiple Tables

Validation:

* 190 Validation Functions
* String Validation
* Number Validation
* Date Validation
* Time Validation
* Validation Against list of values
* Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC

Transformation:

* 36 Transformation Functions
* String Transformation
* Number Transformation
* Date Transformation
* Sorting
* Grouping
* Deduplication
* Translating coded values (e.g., if the origin organization stores 1 seeking male and 2 seeking female, but the warehouse stores M seeking male and F seeking female)
* Deriving a original calculated value (e.g., vending amount = qty * component price)
* Joining together information from multiple fields
* Summarizing multiple rows of information (e.g., aggregate sales seeking each accumulate, and seeking each region)
* Generating surrogate indication values
* Transposing or pivoting (turning multiple columns into multiple rows or corruption versa)
* Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a thread in individual column as particular values in unalike columns)
* Customised Transformation

Loading:

* Multiple Data Targets
* Sql scripts implementation before and after loading
* Delimited or Fixed width Text file
* MS Access Database
* Microsoft Excel File
* DBF File
* ODBC origin (Using ODBC API)
* Oracle 7-10G database (using OCI API)
* SQL server 7- 2005 (using BCP API)
* ODBC origin (Using ODBC API)

Search similar software using these keywords:

Etl, Oracle, Odbc, Ms sql server, Sql loader, Bcp, Datawarehouse, Powerful etl tool, 

Other software by DB Software Laboratory

Database Browser Portable - This Easy to use tool allows user to affiliate to any database and browse or change data, race sql scripts, export and imprint data. And the most important article it is Freeware.

Visual Importer - Visual Importer loads figures into any database from Text, Excel, MS Access, DBF files or any ODBC compliant database. It is clear to utter and was designed specially for non-technical users.

Visual Importer Professional - Powerful ETL instrument. Imports data into Oracle, SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources. Very fast and reliable. Uses naitive API. Repository: MS Access, Oracle, MS Sql Server, Interbase, MySql, PostgreSQL

Active Business Intelligence Portal - Active BI Portal is business intelligence software that provides an integrated solution representing designing and deploying reports and snare forms through the internet and intranet. Active BI Portal works with all greater commercial and open origin databases.

Visual Importer Enterprise - Visual Importer Enterprise automates the process of loading data into any database. It enables the purchaser to visualize Import, Export and SQL scripts, combine them to the package and schedule it representing execution on everyday basis.

VImpX - Loads statistics into Oracle, SQL Server, ODBC, from flat files, intersect tables or ODBC.

Database Browser - This Easy to use tool allows user to link to any database and browse or adapt data, scurry sql scripts, export and imprint data. And the most important subject it is Freeware.

Data Exchange Wizard - Data Exchange Wizard can import information from a content file, Excel spreadsheets, or MS Access databases into any database, including Oracle, MS SQL Server or any ODBC compliant database. Alternatively, information can be exported from the database to smooth files.

DEWizardX - This ActiveX helps you to encumbrance and export figures from / into various datasources such as delimited and anchored width files or ODBC figures source into / from Oracle, MS SQL Server or any ODBC compliant database

Active Table Editor - Active Table Editor enables end users to rephrase ANY provender manually. All complexity is progressive behind the scene. The end users see and rephrase solitary that figures, which was allowed by the administrator. Command line allows bypassing login screen.