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





軟體簡介:



AdvancedETLProcessorv2.2.4.0數據庫管理軟體英文正式版





內容說明:
一款數據庫管理軟體，能夠幫助你快速。有效的管理您的數據庫。

英文說明:
Thisapplicationwillallowyoutoreducethe
timeandenergyyouspendwhereyouaremanaging
yourdatabasedata.
AdvancedETLisabusinessintelligencetoolthat
providessolutionforExtracting,Validating,
TransformingandLoadingdatabetweendifferent
datasourcesandtargets.Therefore,itisan
all-in-onesoftwarethatwillbeveryusefulin
yourwork,nomatterwhatitisrelatedto.

Extraction:
MultipleDelimitedorFixedwidthTextfiles
MultipleExcelfiles+MultipleExcelSpreadsheets
MultipleMSAccessDatabases
MultipleDBFFiles
AnyODBCsource
MultipleTables

Validation:
190ValidationFunctions
StringValidation
NumberValidation
DateValidation
TimeValidation
ValidationAgainstlistofvalues
Regular
Expressions:Postcodes,PhoneNumbers,VAT
NumbersETC

Transformation:
36TransformationFunctions
StringTransformation
NumberTransformation
DateTransformation
Sorting
Grouping
Deduplication
Translatingcodedvalues(e.g.,ifthesource
systemstores1formaleand2forfemale,but
thewarehousestoresMformaleandFforfemale)
Derivinganewcalculatedvalue(e.g.,sale
amount=qty*unitprice)
Joiningtogetherdatafrommultiplefields
Summarizingmultiplerowsofdata(e.g.,total
salesforeachstore,andforeachregion)
Generatingsurrogatekeyvalues
Transposingorpivoting(turningmultiple
columnsintomultiplerowsorviceversa)
Splittingacolumnintomultiplecolumns(e.g.,
puttingacomma-separatedlistspecifiedasa
stringinonecolumnasindividualvaluesin
differentcolumns)
CustomisedTransformation

Loading:
MultipleDataTargets
Sqlscriptsexecutionbeforeandafterloading
DelimitedorFixedwidthTextfile
MSAccessDatabase
MicrosoftExcelFile
DBFFile
ODBCsource(UsingODBCAPI)
Oracle7-10Gdatabase(usingOCIAPI)
SQLserver7-2005(usingBCPAPI)
ODBCsource(UsingODBCAPI)