Advanced ETL Processor v2.2.4.0資料庫管理軟體 英文正式版


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱:Advanced ETL Processor v2.2.4.0資料庫管理軟體 英文正式版
語系版本:英文版
光碟片數:單片裝
破解說明:
系統支援:WIN 9x/WIN ME/WIN NT/WIN 2000/WIN XP/WIN 2003
軟體類型:程式設計
硬體需求:PC
更新日期:2008/7/27
官方網站:
中文網站:
軟體簡介:
銷售價格:80
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=




軟體簡介:

      

      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)    






             


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=