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





破解說明:
關掉主程式,破解檔放置於crack夾內,請將破解檔複製於主程式的安裝目錄內既可破解



軟體簡介:



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








中文化說明:

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

英文說明:
AdvancedETLProcessorisdesignedtoautomate
extractingdatafromANYdatabase,transform,
validateitandloadintoANYdatabase.Typical
usageofitwouldbeextractdatafromExcel
File,ValidateDateFormats,Sortdata,
deduplicateitandloaditintothedatabase,run
storedprocedureorSqlscript,onceloadingis
completed.UnlikeOracleSQLloader,BCP,DTSor
SSISAdvancedETLProcessorcanalsoaddnewand
updateoldrecordsbasedonprimarykey.Some
examplesofwhatourcustomersusethisETLtool
forinclude:

Extractdatafrom:

*MultipleDelimitedorFixedwidthTextfiles
*MultipleExcelfiles+MultipleExcel
Spreadsheets
*MultipleMSAccessDatabases
*MultipleDBFFiles
*AnyODBCcompliantdatabase
*MSSqlServer
*MultipleTables

AndLoaditinto:

*MultipleDataTargets
*Sqlscriptsexecutionbeforeandafterloading
*DelimitedorFixedwidthTextfile
*MSAccessDatabase
*MicrosoftExcelFile
*DBFFile
*Oracle7-11gdatabase
*SQLserver7-2005
*AnyODBCcompliantdatabase

SavetimebyautomatingEverydaytasks:

*Movedatafromonesystemtoanother
*Importsalesintomarketingsystem
*Validateandcorrectkeydata
*Removeduplicatedata
*Avoidre-keyingdata
*AddRecords
*UpdateRecords
*DeleteRecords
*AddNewandUpdateexistingRecords
*DealWithDirtyData
*ValidatePostcodes,Phonenumbers,TAX
Codesusingregularexpressions
*ValidateDateFormats
*ValidateDateandTime
*ValidateNumbers
*ValidateStrings
*Split,mergeFields
*Splitdataandloaditintodiffrenttables
*Add,replace,deletestrings
*Runcustomtransformations
*DeduplicateData
*SortData
*GroupData
*SummarizeData
*PivotandUnPivotData
*Createsurrogatekeys
*Translatecodedvalues
*Deriveanewcalculatedvalue
*RunSqlscriptbeforeandafterloadingdata
*FilterSourceData
*UseSelectStatementasaDataSource
*Runtransformationscriptfromthecommand
line

IfsomethingwentwrongAdvancedETLProcessor
writesdetailedmessageintoerrorlogandwrites
arecordintorejectedrecordsfile.