Re: [U2] What tools do you use for data warehouse...

2013-04-28 Thread Manu Fernandes
-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

Re: [U2] What tools do you use for data warehouse...

2013-04-28 Thread Robert Frailey
cool thanks - Original Message - From: Wols Lists antli...@youngman.org.uk To: u2-users@listserver.u2ug.org Sent: Friday, April 26, 2013 4:38 PM Subject: Re: [U2] What tools do you use for data warehouse... On 26/04/13 20:33, Kevin Le wrote: We have a few applications written in VB

[U2] What tools do you use for data warehouse...

2013-04-26 Thread Tom Whitmore
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

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Dan Goble
-mail in error and delete all copies of this message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, April 26, 2013 1:50 PM To: U2 Users List Subject: [U2] What tools do you use for data

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Robert Frailey
: Friday, April 26, 2013 1:02 PM Subject: Re: [U2] What tools do you use for data warehouse... Tom, We use a tool called Kourier from Koretechologies that does a nice job. Very flexible and you can schedule the tasks to be done. -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Robert Frailey
Medical Products Inc. Femcare-Nikomed Ltd. rfrai...@utahmed.com 801-569-4016 - Original Message - From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, April 26, 2013 11:50 AM Subject: [U2] What tools do you use for data warehouse... Hi

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Kevin Le
26, 2013 11:50 AM Subject: [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

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Wjhonson
...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 12:33 pm Subject: Re: [U2] What tools do you use for data warehouse... We have a few applications written in VB that use ODBC to access Unidata... but I find it to be a security risk since ODBC can be used in Access

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Robert Frailey
- From: Kevin Le veg...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 12:33 pm Subject: Re: [U2] What tools do you use for data warehouse... We have a few applications written in VB that use ODBC to access Unidata... but I find it to be a security risk since ODBC

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Jeff Schasny
There is really no reason to export the data from Universe. When I created the data warehouse product for Eclipse we simply collected all the data from the various transaction files associated with a specific reporting function and wrote them out on demand for a given query to a flattened out

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Kevin Le
801-569-4016 - Original Message - From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, April 26, 2013 1:37 PM Subject: Re: [U2] What tools do you use for data warehouse... For constant repeating queries, dump the data *from* Unidata instead of doing

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Rutherford, Marc
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Friday, April 26, 2013 12:02 PM To: U2 Users List Subject: Re: [U2] What tools do you use for data warehouse... Tom, We use a tool called Kourier from Koretechologies that does a nice job. Very

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Wjhonson
Why can you not dump it to a protected directory? -Original Message- From: Kevin Le veg...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 1:30 pm Subject: Re: [U2] What tools do you use for data warehouse... How about limiting access

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Robert Frailey
:29 PM Subject: Re: [U2] What tools do you use for data warehouse... How about limiting access and audits? I see you are form a medical company. How are you protecting your data and applying hippa? On Friday, April 26, 2013, Robert Frailey wrote: Dump it to a pointer on a CIFS volume

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Robert Frailey
you can and I do this a lot to keep different plants from seeing other plant reports and data. - Original Message - From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, April 26, 2013 2:50 PM Subject: Re: [U2] What tools do you use for data warehouse... Why

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Robert Frailey
u2-users@listserver.u2ug.org Sent: Friday, April 26, 2013 3:03 PM Subject: Re: [U2] What tools do you use for data warehouse... In samba you can setup authorized access to the CIFS volumes Its easy to make a directory in temp or some odd obsure place and do a logical link. the only thing

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Wols Lists
On 26/04/13 20:33, Kevin Le wrote: We have a few applications written in VB that use ODBC to access Unidata... but I find it to be a security risk since ODBC can be used in Access and allow the user to dump entire tables of data with no controls/auditing/logging. Are there any other ways of

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Mecki Foerthmann
SSIS of course. Why would anybody want to use anything else? On 26/04/2013 18:50, Tom Whitmore wrote: 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