Advanced ETL Processor v2.2.4.0資料庫管理軟體 英文正式版
碟片編號：CB10326
碟片數量：1片
銷售價格：200
瀏覽次數：11468
軟體簡介:
Advanced ETL Processor v2.2.4.0數據庫管理軟體 英文正式版
內容說明:
一款數據庫管理軟體，能夠幫助你快速。有效的管理您的數據庫。
英文說明:
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)
