[U2] Problems with the IBM DB2 U2 Dotnet provider and vista

2008-05-09 Thread David Jordan
Has anyone had a problem installing the new IBM.Net Data provider Ver 9.5 service pack onto Vista. When you double click on the setup.exe and click the Vista allow access, it comes back the program has stopped working. The Ver9.5 installed OK on Vista (it just does not connect to U2 databases),

RE: DQM (was [U2] Using ETL to extract data from UD to SQL)

2008-05-09 Thread Manu Fernandes
Hello, My 2 pences. We use SQL dbms as datawarehouse repository where we put all our U2 datas (Uv,Ud) but also XLS sheet, MDB files, other sql db, ... We use standard client tool like BusinessObject, Cognos, HummingbirdBI to request datawarehouse. To prepare U2 datas, we have a in-house tool

Re: [U2] Using ETL to extract data from UD to SQL

2008-05-09 Thread Mecki Foerthmann
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

RE: [U2] RE: U2 - SQL Server ODBC Connection via Universe[AD]

2008-05-09 Thread Tony G
Since this is an Ad sub-thread and recent topics ask related questions, I'll add two points: 1) Nebula Research and Development has partnered with a large global company that specializes in providing end-to-end Business Intelligence solutions. We're days away from posting information on our

RE: DQM (was [U2] Using ETL to extract data from UD to SQL) [not-secure]

2008-05-09 Thread Hennessey, Mark F.
Mike Rajkowski has a great post at U2 Developer works on using XML schema for this: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0710rajkow ski/?S_TACT=105AGX11S_CMP=LP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent:

Re: DQM (was [U2] Using ETL to extract data from UD to SQL)

2008-05-09 Thread Results
Clif, For me it starts with clean dictionaries. The transformations in the DICT are wildly useful in recasting the data. 'D'ate, 'MT'ime, 'MD'ecimal - they identify a lot of the data in a way that is quick and automation-friendly. - Chuck 'Meta Late Than Never' Barouch Clifton Oliver

RE: [U2] Using ETL to extract data from UD to SQL

2008-05-09 Thread Marc Harbeson
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 thou) Agreed: VSG sucks. Epicor ETL's CDC is

RE: DQM (was [U2] Using ETL to extract data from UD to SQL)

2008-05-09 Thread Marc Harbeson
:-) We wrote our engine to quarantine records that error out - which dirty SQL data would cause. What you do with the quarantined records is up to you. LOL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Friday, May 09, 2008

[U2] Hylafax Server?

2008-05-09 Thread karlp
I'm considering a change from VSI-FAX to Hylafax. Any experiences are welcome either with the migration, and with just using Hylafax without prior VSI-FAX use. TIA, -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29

RE: [U2] U2 - SQL Server ODBC Connection via Universe

2008-05-09 Thread John Hester
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, May 08, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 - SQL Server ODBC Connection via Universe Has anyone had success in setting up a ODBC

RE: [U2] Blink Error - Dictionary Related

2008-05-09 Thread Mark Eastwood
I would try re-writing the A type as a D...I'm not sure I-types always play well with A/S types. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bessel, Karen Sent: Friday, May 09, 2008 12:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] Blink

RE: [U2] U2 - SQL Server ODBC Connection via Universe

2008-05-09 Thread JPB-U2UG
There is also Easysoft which seems to be a good one. I've tested it but have not put it into production yet. There seems to be more action being done at getting things from the U2 environment then the other way around. What we are doing here is the other way around, trying to get data from SQL

RE: [U2] Blink Error - Dictionary Related

2008-05-09 Thread Brutzman, Bill
I believe that I have seen a closely-related problem. A talented programmer on this list suggested keeping the dictionary entries 1 through 6 and delteting 7 and above. I sort-of recall that 7 and above may be used to relate U2 to SQL. If there is no SQL linkage, consider making a backup copy,

RE: [U2] U2 - SQL Server ODBC Connection via Universe

2008-05-09 Thread John Hester
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Friday, May 09, 2008 1:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 - SQL Server ODBC Connection via Universe There is also Easysoft which seems to be a good one. I've