商品詳情
資料庫管理軟體 英文正式版 Advanced ETL Processor v2.2.8.0
商品編號:
本站售價:NT$200
碟片片數:1片
瀏覽次數:12316
|
【轉載TXT文檔】
|
您可能感興趣:
您可能也喜歡:
商品描述
破解說明:
關掉主程式,破解檔放置於crack夾內,請將破解檔複製於主程式的安裝目錄內既可破解
軟體簡介:
數據庫管理軟體 英文正式版 Advanced ETL Processor v2.2.8.0
中文化說明:
內容說明:
是一款數據庫管理軟體,能夠幫助你快速。有效的管理您的數據庫。
英文說明:
Advanced ETL Processor is designed to automate
extracting data from ANY database , transform,
validate it and load into ANY database . Typical
usage of it would be extract data from Excel
File,Validate Date Formats, Sort data ,
deduplicate it and load it into the database, run
stored procedure or Sql script, once loading is
completed. Unlike Oracle SQL loader, BCP, DTS or
SSIS Advanced ETL Processor can also add new and
update old records based on primary key. Some
examples of what our customers use this ETL tool
for include:
Extract data from:
* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel
Spreadsheets
* Multiple MS Access Databases
* Multiple DBF Files
* Any ODBC compliant database
* MS Sql Server
* Multiple Tables
And Load it into:
* Multiple Data Targets
* Sql scripts execution before and after loading
* Delimited or Fixed width Text file
* MS Access Database
* Microsoft Excel File
* DBF File
* Oracle 7-11g database
* SQL server 7- 2005
* Any ODBC compliant database
Save time by automating Everyday tasks:
* Move data from one system to another
* Import sales into marketing system
* Validate and correct key data
* Remove duplicate data
* Avoid re-keying data
* Add Records
* Update Records
* Delete Records
* Add New and Update existing Records
* Deal With Dirty Data
* Validate Post codes, Phone numbers,TAX
Codes using regular expressions
* Validate Date Formats
* Validate Date and Time
* Validate Numbers
* Validate Strings
* Split, merge Fields
* Split data and load it into diffrent tables
* Add, replace, delete strings
* Run custom transformations
* Deduplicate Data
* Sort Data
* Group Data
* Summarize Data
* Pivot and UnPivot Data
* Create surrogate keys
* Translate coded values
* Derive a new calculated value
* Run Sql script before and after loading data
* Filter Source Data
* Use Select Statement as a Data Source
* Run transformation script from the command
line
If something went wrong Advanced ETL Processor
writes detailed message into error log and writes
a record into rejected records file.