Hi, E.T.L. which one ?
A in-house SB+/BASIC dev composed with 2 parts : - SB+ interfaces to define mapping & extract options (Extract, Transform E.T. ) -- tablename --- link to filename(s) (same file into multi-account or multi-file with the same structure) --- human name of the table (for metadata providing to request tool) --- long description of the table (for metadata providing to request tool) -- columnname --- linked to Itype or SB+ expression to extract data --- sql-datatype --- human name of the column (for metadata providing to request tool) --- long descrition of the column (for metadata providing to request tool) --- specify the column indexing properties into dw -- options --- process before extract (to prepare temp file if necessary) --- select clauses to filter data --- process after read record (to transform the datas by BASIC if necessary) --- dw refresh rhythm ---- incremental real time (based on trigger update trap) ---- incremental time stamp (based on a time stamp, if exist into record) ---- partial, based on select criteria ---- complete - BASIC subr to extract data from files via E.T. and build SQL stmt to update data warehouse (Load L.) We run under Universe, Unidata, D3. We run in front of data warehouse running under MS-Sql, Orable, DB2, mySQL, Unidata, Universe(sql-schema), or direct access - Datawarehouse can be on the same server or separate. We have routines to interfaces data from outside U2 (xls, mdb, other-sql db, ...) and merge it into DW. The really big advantage is : - we work directly into the native structure of U2 (mv'ed, sv'ed, record_on_fixed_key, "special storage organisation") - we use BASIC power to extract, transform data - the deployment consist to deploy one account with subr and one file with ETL defn per application - we build SQL stmt via template which can be "dedicated" by sql-db specificity Manu > -----Message d'origine----- > De : [email protected] [mailto:u2-users- > [email protected]] De la part de Debster > Envoyé : mercredi 29 juillet 2009 06:50 > À : [email protected] > Objet : [U2] What ETL? > > Just takin' a survey > > What ETL tool do you use - > > Why do you like it? > > Ease of use > > > > > "Anyone can hold the helm when the sea is calm". > -Syrus Publilius > > > > > > > > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
