WINDOWS CATEGORIES:



NEWS ARCHIVE >>
SOFTPEDIA REVIEWS >>

WEEKLY HIGHLIGHTS

DVD Cloner45
Spyware Doctor40
1Click DVD Copy40
Apollo DVD Copy40
ABC Amber BlackBer...45
Protected Music Co...40

7-DAY TOP DOWNLOAD

#
Program
Avira AntiVir
Personal - Free
Antivirus 8.1.0.331

141,511
Windows Live
Messenger 2009
14.0.5027.908

80,303
Windows Live
Messenger
8.5.1302.1018

64,424
Internet Download
Manager 5.14 Build 5

46,141
DVD Shrink 3.2.0.15
43,378
Y! Multi Messenger
8.x and 9.x

40,206
Vista Transformation
Pack 8.0.1

38,747
Microsoft Office
2007

37,600
Uxtheme
Multi-patcher 6.0

36,257
Nero 7 Premium
7.11.10.0

33,518

WEEK'S BEST

  • DAEMON Tools Pro B...
  • Advanced X Video C...
  • WinRAR 3.80 Stable
  • Nero 9 9.0.9.4
  • Net Transport 2.64...
  • Advanced SystemCar...
  • Windows Live Messe...
  • Acronis True Image...
  • ImTOO DVD Ripper S...
  • Combined Community...
  • Fastream IQ Web/FT...
  • VirtualDub 1.8.6 B...
  • Super DVD Creator ...
  • Deluge 1.0.0.32
  • Adobe Flash Player...
  • WinPatrol 15.9.200...
  • Trend Micro Intern...
  • COMODO Internet Se...
  • WinZip 12.0 Build ...
  • Real Alternative 1...
  • Camfrog Video Chat...
  • iTunes 8.0.1.11
  • QuickTime 7.55.90.70
  • SiSoftware Sandra ...
  • Opera 9.60 Build 1...
  • EVEREST Ultimate E...
  • Google Chrome 0.3....
  • BS.Player 2.31 Bui...
  • WinRAR 3.80 Stable
  • McAfee AVERT Sting...
  • Home / Windows / Internet / Servers / Database Utils
     Report spyware

    Advanced ETL Processor 2.2.1.4



    Downloads: 1,077  Add to download basket  Tell us about an update
    User Rating:
    Rated by:
    Very Good (4.0/5)
    24 user(s)
    Developer:

    License / Price:

    Size / OS:

    Last Updated:

    Category:
    DB Software Laboratory | More programs
    Trial / USD 130.00 | BUY the full version
    6.3 MB / Windows All
    August 27th, 2008, 02:44 GMT [view history]
    C: \ Internet \ Servers \ Database Utils

     Read user reviews (0)  Add a review  Refer to a friend  Subscribe

     

    Advanced ETL Processor description

     

    This application will allow you to reduce the time and energy you spend where you are managing your database data.

    Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets. Therefore, it is an all-in-one software that will be very useful in your work, no matter what it is related to.

    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)

    Limitations:

    · 30 days trial period
    · Nag screen

    What's New in This Release: [ read full changelog ]

    · Various bug fixes and performance improvements

     Softpedia guarantees that Advanced ETL Processor 2.2.1.4 is 100% CLEAN, which means it does not contain any form of malware, including spyware, viruses, trojans and backdoors. [read more >]


    TAGS:

    etl processor | extract data | data validation | validate | extract | transform

    Related downloads IT News Popular downloads New additions   Latest reviews  
    Extract Data & Text From Multiple Text Files Software 7.0
    Extract lines that contain specified text from one or many files.
    MS Word Extract Data and Text from Multiple Word Documents 9.0
    This software enables you to easily extract data form several MS Word documents.
    Extract Data and Text from Multiple Text and HTML Files Software 9.0
    If you want to know how to extract data from text or HTML files, then this software is for you!
    Text List 1.2
    A program that will help you create all the lists you need
    ReportX 2.02
    Allows you to perform complex queries and analysis (such as data mining) on the information without slowing down the PC.


    HTML code for linking to this page:


    Go to top



    SUBMIT PROGRAM   |   ADVERTISE   |   GET HELP   |   SEND US FEEDBACK   |   RSS FEEDS   |   ENTER NEWS SITE   |   ENGLISH BOARD   |   ROMANIAN FORUM