Database to a network location

Highlighted
Five Stars

Database to a network location

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.

Fifteen Stars TRF
Fifteen Stars

Re: Database to a network location

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

tOracleInput --> tFileOutputDelimited


TRF
Seven Stars

Re: Database to a network location

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
Five Stars

Re: Database to a network location

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.

Fifteen Stars TRF
Fifteen Stars

Re: Database to a network location

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


TRF
Five Stars

Re: Database to a network location

Yes,

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

Fifteen Stars TRF
Fifteen Stars

Re: Database to a network location

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

TRF
Five Stars

Re: Database to a network location

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

Seven Stars

Re: Database to a network location

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,

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads