ODS - XI - CSV file

[Former Member]

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

[prabhu_s2]

<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

[Shabarish_Nair]

<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.

[Former Member]

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

[prabhu_s2]

CSV (comma separated value) is comma delimited file

Message was edited by:

Prabhu S

[prabhu_s2]

All RDBMS are supported by strucutres. In ur case (ODS) what are the column lables? The column labels makes out the strucutre of the table. WRT to this u create a DT (source) in XI for mapping to target.

[Former Member]

Thanks.