Database to a network location

[Anonymous]

Hi, '

I am trying to load data from Oracle database into a csv file which should be created in my shared network location.

Can someone suggest the components to be used for the above.

Thanks in advance!

Alekhya.

[TRF]

As as the output folder is available from the place where the job runs, you just need the following:

tOracleInput --> tFileOutputDelimited

[rmartin2]

Hi !

Whichever (Windows or Linux) OS you use, a network shared location is a simple folder.

I think that your problem is to ensure that the folder is mounted.

So you need to :

1. Test whether or not the folder exists
2. Create if not (with a simple command line)
3. Do your stuff in the folder

[Anonymous]

Thanks for the reply @TRF 

I already tried this way..but it is throwing an error stating "Access is denied". So, I am searching is there any other way to achieve the above.

[TRF]

The message is clear, you need the RW permission to the target folder/file

[Anonymous]

Yes,

Apart from tfileoutputdelimited, do we have any other component which can be used to generate a csv file in a shared network?

[TRF]

This is the dedicated component (your problem is not the component, it's about your access rights to the target folder)

[Anonymous]

Ok.. I am able to access this folder from my file explorer.

So, this might be because Talend is not installed as administrator?

Thank You,

Alekhya

[rmartin2]

No, it's because your network drive can't manage user rights.

And if your shared drive is on Linux, it's worse, because you need to give full access to everybody.

Basically, when you create something inside a shared location, it belong to the holder (some random server). The folder/file will be created for a user, represented by number.

But user "foo" (n°1) on a computer may be n°406 for example on another one. So rights won't match unless it's a fully Windows managed or full Linux managed (with some precautions).

So you need to grant full access to this folder to anyone, because the server is not able to get your identity (basically).

So indeed, talend doesn't have permission, but it's unwise to just use "administrator mode". It's bypassing the problem.

As said before, just give full access when mounting your NTFS drive (or other file system type).

Sincerely,