.: Advanced ETL Processor 2.1.1

   Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data 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 source
* 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 source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
* Deriving a new calculated value (e.g., sale amount = qty * unit price)
* Joining together data from multiple fields
* Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
* Generating surrogate key values
* Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
* Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
* Customised Transformation

Loading:

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

Program system requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003
Screenshot:	Download Now File size 3.23 MB Buy Now
etl, powerful etl tool, oracle, ms sql server, bcp, sql loader, odbc, etl, data transformation, validatation, sorting, groupping, pivot, unpivot,
.: Top Database & SQL / Software Development programs  1)   MS Access Join Two Tables Software 7.0 Horizontally merge (combine, match, union) two Access tables by a common column.  2)   MS SQL Server Change Case to Proper, Upper & Lower Software 7.0 Change case for values in MS SQL Server 2000 or 2005 tables.  3)   Advanced Data Export 3.4 Advanced Data Export will save your data in the most popular data formats.  4)   MS Access Merge (Combine) Fields Into One Software 7.0 Join two or more fields (columns) into one in Microsoft Access.  5)   MySharpCode 1.1 Step by step commented C Sharp example program that uses SQLite.  6)   SQL Diagrams 2004 Don't spend hours trying to understand your database, see it with SQL Diagrams  7)   NextGeneration .NET Code Generator 1.1.0 Code Generator outputs ASP.NET pages, C# Database objects and stored procedures .: New Database & SQL / Software Development programs  1)   IP2Location IP-COUNTRY-REGION-CITY Database July.2008 IP2Location(tm) IP-COUNTRY-REGION-CITY translates IP address to country, region and city.  2)   IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED Database July.2008 IP address to country, net speed, ISP, domain, latitude, longitude and zip code.  3)   Advanced CSV Converter 1.60 Convert CSV into XLS, DBF, XML, HTML, RTF, SQL and more. Filter data with ease.  4)   Mexico Postal Code Database (Gold Edition) July.2008 Mexican Postal Codes Database Subscription in text, Excel and Access  5)   SQLyog MySQL GUI 6.56 SQLyog is a tool that allows you manage MySQL database.  6)   MONyog MySQL Monitor 2.06 MONyog helps MySQL DBAs manage more MySQL servers, tune their current servers.  7)   Recovery Toolbox for SQL Server 1.0.1 Recover data from corrupted MS SQL Server database files (repair .mdf files)

2007-2008 (c) Copyright Fast-Download.info - Privacy Policy - Report Page