Dump it to a pointer on a CIFS volume on the server, all they or anyone
will see is the file from a mapped windows workstation drive.
I think our Programmer, Brooke has incorporated an export function in our
Salesorders to automatically dump shipping data from every Salesorder and
append it to a file
in a CIFS directory. Our FedEx/UPS Computers in the US, Ireland and England
automatically pull that data file real-time, or sort of real-time to create
the shipments.
We do lots of data exports for excell and access.
E-mail Brook and ask him about it. bkend...@utahmed.com
Thank You
Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Femcare-Nikomed Ltd.
rfrai...@utahmed.com
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 *on the fly* requests.
So if you *always* need the list of invoices, products, amounts, just dump
it to a tab-file from inside Unidata every night in a batch.
-----Original Message-----
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 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 getting data from Unidata that could be more
secure?
Kevin
On Friday, April 26, 2013, Robert Frailey wrote:
Call Kore and talk with Paul. Their products are very reasonable.
Paul Trebbien
Kore Technologies, Senior Support Tech.
"Solutions that work. People who care."
Direct 858.300.2618 Fax 858.300.2600
Main 858.678.0030 Web koretech.com
Thank You
Robert Frailey
Manager Information Systems
Utah 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,
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<http://listserver.u2ug.org/mailman/listinfo/u2-users>
______________________________**_________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users>
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users