Hi, We use a in-house ETL which is based on DICT independant "table/column" definition. The user interface to define table/column is a SB+ app ; easy to use.
At first, you define you tables and columns to be created/loaded into your dw ; each table are linked to one datafile and in case of mv/sv'ed; linked to a "controling" field (mv/sv) Next, you define each column by setting their sql properties, the source of the value (attribute number or sb+.expression) ; the human label of the column ; with it you can create "transformed" data. (by default you can retrieve the dictionnaries) here a screen sample : http://wiki.infodata.lu/lib/exe/fetch.php?media=public/etl/etl_dw_defn1.png With these table/columns definition, the system build sql-stmt to create the table into the dw and load the data into the table via insert / loadinto ,... After what, the ETL send the sql-stmt to the dw. The sql-stmts are build from sql dialect-templates then , we can adress all SQL dbms After what, you can define datamarts ; as a set of tables, and request immediate or, via crontab/taskmanager, sheduled refreshing processus of one/* datamart For more details, send me a mail. manu > -----Message d'origine----- > De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] De la part de Tom Whitmore > Envoyé : vendredi 26 avril 2013 19:50 > À : U2 Users List > Objet : [U2] What tools do you use for data warehouse... > > Hi, > I was wondering what tools you use to export data to an SQL data warehouse > from UniVerse. This export could occur on multiple flavors of Unix. > > What we would need to do is extract the UV data and perform some data > "translations" before importing the data into the SQL table. > > I know at one point DataStage was a powerful but expensive tool that would > accomplish this task. > > All suggestions are greatly appreciated! > Tom Whitmore > RATEX Business Solutions > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
