How to transfer the data to a Oracle data base

[Former Member]

Hi All,

1. What is the property which automatically pick

ups the file when it is a Flatfile ? (When data came

from flat file)

2. How to transfer the data to a Oracle data base.?

regards,

Kareem.

[Former Member]

Hi,

>> In the Sender File Adapter the Property/Value used in Message Protocol is,

1.<b>"File"</b> for files in which the data is specified in XML format

2.<b>"File Content Conversion"</b> for files in which the data is present in CSV Format or other which needs a conversion.

>>> To Transfer the data to Oracle Data base you need to Configure a Receiver JDBC adapter for your scenario.

In case you are trying the JDBC adapter for the FIRST time then you must configure the JDBC drivers in the XI server. For Detailed procedure refer to the Document "How To Install and Configure External Drivers for JDBC & JMS Adapters" in the below link,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Hope this helps you

[MichalKrawczyk]

Hi,

>>>1. What is the property which automatically pick

ups the file when it is a Flatfile ? (When data came

from flat file)

have a look at :

<i><b>Message Protocol:</b></i> <b>File Content Conversion</b> in file adapter

Regards,

michal

[Former Member]

Hi,

To answer ur second question, u can use JDBC adapter....to transfer data to DB

Sreedhar...