Accessing CSV files on local drive

travissolt · Post by **travissolt** » Thu Feb 22, 2007 12:25 pm

Is there a way to access a CSV file on my local drive without FTP'n it into the UNIX environment.

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Feb 22, 2007 12:27 pm

Open it Microsoft Excel.

travissolt · Post by **travissolt** » Thu Feb 22, 2007 12:31 pm

Sorry should have been more specifc. I want to bring in a csv file as a source table in datastage but do not want to have to FTP it to unix first. Can datastage (unix setup) read csv or txt files off of a local drive.

Thanks

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Feb 22, 2007 12:34 pm

Is there any restrictions on FTP? or its just that you dont want to add an extra step.

If there are no restrictions on FTP then you can use the FTP plugin stage to read the remote file

ganesh123 · Post by **ganesh123** » Thu Feb 22, 2007 12:35 pm

No its not possible becoz your server software is loaded on Unix box. So you have to FTP to unix.

On your local machine there is only client part.

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Feb 22, 2007 12:39 pm

OH. You you want to pick files from your client machine. Just like you open a testpad or something?

I dont think thats possible

travissolt · Post by **travissolt** » Thu Feb 22, 2007 12:44 pm

When I used Informatica I could point to a table locally and bring it in as a source (say for an initial population or test load). I could also access the unix side if I wanted to store an output file. Just making datastage did or did not have the same functionality before I went down the FTP path.

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Feb 22, 2007 12:46 pm

convert your client installation to server and you will have this functionality.

Its just that you cant access local files on the client machine unless you FTP it to the server.

chulett · Post by **chulett** » Thu Feb 22, 2007 12:49 pm

Your UNIX-based DataStage server needs to be able to 'see' your local drive in order to access files on it. You'd need to arrange an NFS mount or use something like Samba to enable that.

travissolt · Post by **travissolt** » Thu Feb 22, 2007 12:59 pm

So the functionality is there it just needs to be setup. Is that something each user would have to establish or will the DBA's need to set it up on the box? If I sent your previous post to the DBA's would it give them enough info to figure it out.

narasimha · Post by **narasimha** » Thu Feb 22, 2007 1:02 pm

It would be more of an 'SA' thing rather than a 'DBA'.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 22, 2007 2:01 pm

Is this for a parallel job (as marked) or a server job (as posted)?

travissolt · Post by **travissolt** » Thu Feb 22, 2007 2:07 pm

I would want to access the file in a parallel job (i think that is your question)

ray.wurlod · Post by **ray.wurlod** » Thu Feb 22, 2007 2:11 pm

... then why did you post in the Server forum?

Craig covered the possibilities; either use an FTP stage or use a facility like Samba that makes your Windows folders visible to your UNIX machine (as if they were mounted there) or vice versa.