EMAIL PROTECTED] On Behalf Of Marvin R.
Fisher
Sent: Tuesday, May 13, 2008 4:46 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Using ETL to extract data from UD to SQL
Using Dynamic Change Update in MITS removes the need for the select and
merge method.
You just have to know which applications
: [U2] Using ETL to extract data from UD to SQL
Well, MITS does a SELECT against their copy, then against the source
copy and then merge the list. So - the larger it gets - well (Not
to mention I think MITS is a hunk of glorified crap)
I've had no issues using triggers. (My box is huge
nn
Sent: Friday, May 09, 2008 3:33 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using ETL to extract data from UD to SQL
Well, this all contradicts what I've been told by our software vendor.
Triggers just like ODBC supposedly totally kill the performance of UD
(we are still on 5.2)
Well, this all contradicts what I've been told by our software vendor.
Triggers just like ODBC supposedly totally kill the performance of UD
(we are still on 5.2).
I was advised to stay away from them or use them sparingly, if think I
really have to.
I was also told not to use VSG, and that, I h
There is going to be a lot of effort for any ETL (Extract, transform,
load) on an 'heritage' database. You will have to deal with weird
table/file structures (who did it and why is it that way?!!) and dirty
data to get to a set of data suitable for your DW/reporting
requirements.
If you have deter
D] On Behalf Of Marc Harbeson
Sent: Thursday, May 08, 2008 5:32 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Using ETL to extract data from UD to SQL
I demoed Epiror's variant of this product, and found that is does indeed
look quite nice, but it still is a batch update / scheduled u
I used Cognos Impromptu/Transformer/Powerplay about 8 years ago to
develop a data warehouse product for a Universe based ERP vendor and at
the time it accessed whatever database you pointed it at via ODBC. Is
this not still the case? If so, here are some points to ponder:
1. ODBC is a horrendou
I demoed Epiror's variant of this product, and found that is does indeed
look quite nice, but it still is a batch update / scheduled update tool.
Therefore myself and a few friends went forward with building something
that can perform transactional updates using triggers, BCI and ODBC
client drive