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 they see is what you want them to see.
If you dont have rights to the account, you don't login
We have access control on all processes in Dataflo and unidata, only myself and brooke have all the keys to the castle.
All processes have a tracking file with user date and time stamp.

Robert

----- Original Message ----- From: "Kevin Le" <veg...@gmail.com>
To: "U2 Users List" <u2-users@listserver.u2ug.org>
Sent: Friday, April 26, 2013 2: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 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>
<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>
<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<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

Reply via email to