topic Re: Database to a network location in Talend Studio

Database to a network location

Anonymous — Sat, 16 Nov 2024 04:27:06 GMT

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.

Re: Database to a network location

TRF — Mon, 07 Oct 2019 16:08:41 GMT

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

tOracleInput --> tFileOutputDelimited

Re: Database to a network location

rmartin2 — Mon, 07 Oct 2019 16:12:12 GMT

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 :

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

Re: Database to a network location

Anonymous — Mon, 07 Oct 2019 16:55:51 GMT

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.

Re: Database to a network location

TRF — Mon, 07 Oct 2019 17:00:30 GMT

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

Re: Database to a network location

Anonymous — Mon, 07 Oct 2019 17:05:28 GMT

Yes,

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

Re: Database to a network location

TRF — Mon, 07 Oct 2019 17:08:01 GMT

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

Re: Database to a network location

Anonymous — Mon, 07 Oct 2019 17:13:16 GMT

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

Re: Database to a network location

rmartin2 — Mon, 07 Oct 2019 17:25:04 GMT

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,