Samba running on the server is nice because the user only needs to map a
windows drive to it, the UNIX server doesn't have to replicate that
directory out to a windows client.
All the work load is on the client.
Windows apps like excel and access will allow you to imbed the network path
i.e. \\150.0.0.105\tmp\file.name and as long as you authenticated to the
network and have rights to the file, you get it.
in UNIX "ln-s /dbms/live/MIDVALE/CUSTOMER/CUSTOMER/CUSTLIST CUSTLIST" puts
access only to the directory CUSTLIST and nothing else.
if the logical link is created in the samba directory, the unidata owner
owns it, samba owner can access it but not delete it or change it, just copy
it. you can chgown it, chgrp it or chgmod it depending on your needed
rights.
I use logical links all over the place to manage temp files, protect the
file system from overloads, secure directories and efficiently manage disk
space.
For our international plants who use databases on the same box residing in
the USA, it's easier to make a temp CIFS directory to exchange large files
unrelated to the UNIX system but too large to just e-mail. Those plants
already have a mapped directory to the box on each workstation so dropping
image files and the like into a custom folder and allowing them the rights
to remove and insert those files with minimal impact on the UNIX box and the
network secure tunnels between the plants make sense without overloading the
internet mail systems.
If I ever get time to play with Java programming some more, I would like to
write some custom windows apps to pull data from the plants and insert them
into access automatically, no time for the wicked.
Rob
----- Original Message -----
From: "Robert Frailey" <rfrai...@utahmed.com>
To: "U2 Users List" <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 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
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
