File to XI

[Former Member]

Hello..

I saw the web log in SDN ..how to send the XML data to BW....

i have a file in FTP server....so can i bring that file by using sender file adapter .....after converting XML data can we that to BW?????

But here i don't need any mapping.....

Is this scenario is possible?

Thanks..

[Former Member · Accepted solution]

You can certainly pick up the file using File Sender Adapter.

The guide <b>How to Push data from XI to BW</b> explains how to post data to BW using proxies.

If your source and target structures are same then you dont need mapping, otherwise you need to create a map.

regards

Shravan

[Former Member · Accepted solution]

Thanks Shravan..

Here the target is BW and i confused which one is source...

do i need to create third party systems as source or i can use Bw system for both..

I have file in FTP server....Can you please tell me which one to use as a source...

thanks..

[Former Member · Accepted solution]

File is the source .

Which weblog you are referring to ?

In fact, you can use any of the available to pick up the source, lets say you have data in a Oracle database (JDBC Adapter), or it could be in R/3 (RFC, IDOc, Proxy).

If you are referring to a file then you need to create a third party if that system is not an SAP system.

regards

Shravan

[Former Member · Accepted solution]

Hi Padma,

Since you will be picking file from FTP server so your FTP server is source.Define it as third party system in SLD or you can define it as Business Service in Integration directory.

Thanks.

Rekha

[Former Member · Accepted solution]

Thanks for the reply..

When i created third party system in ID i genareted only on communication channel that is HTTP...but where as for other business systems 4 default adapters are genareted...

is that mean my third party system is not created properly????

If i use sender file adapter to my third party biz system is this genarates XML data....becouse i'm not using mapping..

Thanks..

[Former Member · Accepted solution]

HEllo..

I created third party system in SLD ..and i imported in Id...

When i imported third party system in ID i genareted only on communication channel that is HTTP...but where as for other business systems 4 default adapters are genareted...

is that mean my third party system is not created properly????

If i use sender file adapter to my third party biz system is this genarates XML data....becouse i'm not using mapping..

Thanks..

[Former Member · Accepted solution]

Nothing wrong in your Third Party system. Because the rest of the three adapters are RFC, IDOC and Proxy. These are related to SAP systems which are SAPBASIS >= 620 version.

If you look at my previous answer you would know that, third party system is created for all non-SAP systems (it could be a file server, database server)

Since Third Party system is not an SAP system, ID will not propose rest of the three adapters. Anyway the HTTP adapter it created you would not need it unless you want to post data to HTTP adapter.

I've always made sure that not to check the box <b>Create communication channels automatically</b> while importing the Business systems from SLD.

You can use sender file adapter to pick up a file under any Business system and if the data is in plain format you have to use content conversion, if you already have an XML then you dont need to do the conversion.

regards

Shravan

[Former Member · Accepted solution]

Thanks for explaining the concept.

My question is....i don't have XML data ..i have only DB file...now i need to convert that into XML and send it to Bw...

Is this possible with sender adapter with out mapping?

Thanks..

[Former Member · Accepted solution]

Padma as I mentioned you need to perform Content Conversion if the data is in plain data or comma separated or fixedwidth or tab delimited.

Look at the following blogs

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

Content conversion and mapping or two different things. Mapping is needed when you need to change the data format what the receiver wants and the sender format are different.

XI understands XML data only not the flat file format.

regards

Shravan

Message was edited by: Shravan Miryala