|
|
Home : Business : Databases & Tools
Advanced ETL Processor
Advanced ETL Processor Details:
| Publisher:
|
DB Software Laboratory |
| Version:
|
2.1.1 |
| License:
|
Shareware |
| Trial Limitations:
|
30 Days |
| Price:
|
$300.00 |
| Operating Systems:
|
Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Win |
| System Requirements:
|
Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 |
| File Size:
|
3.23 MB |
| Total Views:
|
76 |
| Total Downloads:
|
0 |
| Rating:
|
 (4 out of 5 Stars) |
| Release Date:
|
12/21/2007 |
| Last Update:
|
12/28/2007 |
|
|
|
Screenshot:
|
Please click to display full view of
Advanced ETL Processor screenshot.
|
Advanced ETL Processor Short Description:
business intelligence tool that provides solution for Extracting and Validating
|
Advanced ETL Processor Long Description:
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)
|
Advanced ETL Processor Keywords:
ETL, Powerful ETL tool, Oracle, MS Sql server, BCP, sql loader, ODBC, ETL, Data Transformation, Validatation, Sorting, Groupping, Pivot, UnPivot
|
|
|
Advanced ETL Processor Reviews by Users
Total Reviews: 0
Total Points: 0
Submit your review
|
We deliver articles like below right to your inbox for free:
Using InstallAware 7 To Deploy Microsoft .NET Framework Applications
by Candice Jones
Overview This whitepaper describes how to use InstallAware for deploying applications running on the Microsoft .NET Framework. Although the .NET Framework makes deploying applications easier thanks to features like the Global Assembly Cache, which eliminates shared resource conflicts often encountered by Win32 applications, there are still unique challenges to the deployment of .NET applications. One significant challenge is the download and installation of the .NET Framework, whi...
A Desk on Top
by Alexander Cherepnev
How many application windows do you have open during your typical computer work? If it's just one, you may stop reading at this point. If, however, you do have a clutter of windows on your computer desktop - go no further, you've just found the solution! Windows offers a convenient way to access applications and documents you use often by placing shortcuts to your computer desktop. These shortcuts are fast to click, but what if you have a window or two on top of your desktop? Minimizing...
Discover How PC Satellite TV Software Works That Lets Users Watch Unlimited Free Internet TV!
by Philip Sumpter
The term PC Satellite TV has so many different variations such as Satellite for PC and Satellite TV on PC that you can become quite confused if they didn't reflect a specific name of a software. Nevertheless for this article, I decided to use the first term to represent all the software available over the Net since it has the most number of searches on Google with the phrase Satellite TV included. The other two terms came in a distant second and third respectively. However there comes an...
Things You MUST Know About Implementation of Ecommerce Solution!
by Anne Catherine
Watching new business launched in market must have made you assume that it's way too easy. Let me clear this misunderstanding. It's easy to get a name, but not easy at all to get fame and a good name. It"s never easy to get your business processes online successfully. You have to work out a lot for it. Recently, the famous research firm Gartner Group failed because of poor planning and unrealistic targets on a new technology. Generally, companies are at loss and disadvantages not only because of...
Photo Editing Software Feature Review - Top 3 Photo Editing Software Programs - Become a Pro
by Richard Seng
What are the Features and Advantages of using Photo Editing Software? Photo editing software brings the photo finishing lab to your computer desktop for a minuscule of the cost. Never again will you have to worry about capturing just the right angle with just the right amount of light. You will be able to upload from a digital camera, a removable storage device (CD, or zip flash drive), scanner or digital camcorder to easily edit your images. Photo editing software allows one to...
|
Recommended Products:
|
|
|
|
|