on 11-21-2007 10:22 AM
I want to export data from ODS table to CSV format files in another FTP server.
Please let me know how to
1. Set up JDBC connector for ODS table (parameters in Communication Channel)
2. Do I need to do mapping to export data to CSV format? If yes, what kind of mapping (graphical, java, etc...) ?
3. Do I need file adapter here?
Thanks a lot
<b>2. Do I need to do mapping to export data to CSV format? If yes, what kind of mapping (graphical, java, etc...) ?</b>
yes u wud require mapping.
<b>3. Do I need file adapter here?</b>
yes file adapter is req for transfring the OSD data to FTP server as CSV files
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<i>1. Set up JDBC connector for ODS table (parameters in Communication Channel)</i>
>>
install the specific drivers to connect to the ODS table
<i>2. Do I need to do mapping to export data to CSV format? If yes, what kind of mapping (graphical, java, etc...) ?</i>
>>>
depends on the complexity of your mapping.
<i>3. Do I need file adapter here?</i>
>>>
yes the file receiver for the CSV file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for replying. But I need configuration parameters to put in Communication Channel.
Is there any difference between pulling out from ODS table and from database in this case?
Secondly, I wonder how the mapping is done, as in ODS side (source), we don't have structure, but only columns that contain data.
Thirdly, is there any difference between .txt and .csv format in this case?
I would need some specific answers.
Thanks
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.