JDBC scenario

[Former Member]

Hi All,

In FCC--JDBC scenario,

we can upload data manually,but why we have to go for FCC--JDBC?

Thanks all.

[Former Member · Accepted solution]

Hi,

Please be more clear with ure requirement.

If FCC means File Content Conversion then we JDBC can be used in 2 modes

1. Native SQL String

2. XML SQL Format

The former is used to query the data base directly while the later has some standard message format.

Rgds

Aditya

[Former Member · Accepted solution]

Hi,

You are taking about File to JDBC scenarrio.

<b>

why FCC?</b>

Answer: FCC is used when you have flat file. and flat file cannot be use in XI to prcocess the message trnasformation. so Flat file need to be trnasform to XML file.

using FCC in file adapter convets the flat file in a structure way i.e XML document.

Example of flat file:

Farooq,SAP XI Consultant,26

you have to convet this flat file in a stucture format...like XML.

its XML:

<root>

<name>Farooq</Age>

<Capability>SAP XI Consultant</Age>

<Age>26</Age>

</row>

<b>why JDBC??</b>

JDBC is used to connect the XI with any database usgin vendor specific drivers.

<b>Now why FCC to JDBC??</b>

Say there is a flat file..Employee.txt in FTP server. what ever the information Employee.txt file has data that need to be inserted in database.

so its comes File(using FCC) to JDBC

Hope this will clear you whole picture:)

Thanks

Farooq.

<u><b>

*Rewards Points if you find it useful*</b></u>

[Former Member]

Hi Narsimha,

Are you asking, how to use FCC in JDBC?

Regards,

Sarvesh

[Former Member]

As I understand his question is why it is required to create FCC...or even designing of whole interface.. if data can be manually inserted into the Database tables:)

thanks

Farooq.

[Former Member]

Hi

I think you must have seen some blog like this

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

You can also have a simple file to JDBC Scenario.

In case you have an XML file whose data needs to inserted into the DB

Go for File to JDBC

In case you have a CSV or a flat file apart from XML

Go for FCC to JDBC

In case your file is not on the XI Server

Go for FTP.

//we can upload data manually,

That will be with some adapters help right..instance File Adapter.

Thanks