We use a in-house ETL which is based on DICT independant "table/column" 
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 : 

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 

After what, you can define datamarts ; as a set of tables, and request 
immediate or, via crontab/taskmanager, sheduled refreshing processus of one/* 

For more details, send me a mail.


> -----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

Reply via email to