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!
As as the output folder is available from the place where the job runs, you just need the following:
tOracleInput --> tFileOutputDelimited
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 :
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.
Ok.. I am able to access this folder from my file explorer.
So, this might be because Talend is not installed as administrator?
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).
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema