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...
> 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 mailing list