XML file data load to NW2004s-BI

[Former Member]

HI,

I am trying to load the XML file data to NW2004s-BI .

I have created the file Data source, infosoucrce and data store object. I have maintained the transformation rule for data source and info source also for infosource and data store object.

But I am not able to create the XML DataSource (BW DataSource with SOAP Connection)

I tried to create the XML data source but there is no option as Extras -> Create BW Data source with SOAP Connection but when you right click on the transformation rule and select change, there is option as extras -> Display Generated program but not the Create BW Data source with SOAP Connection .

could you please help me to create the XML data source in NW2004S. The transaction code GEN_DS is not available in NW2004s-BI

Thanks in Advance.

Amit

[Former Member]

HI AMIT BAJ,

I am introducing my self.

I am Rajesh working in SAP-BI.

I saw your question to load the data from XML file to NW2004s BI. Now i have the same requirement. This question you posted in 2nd FEB 06. So i think u got a solution.

Please help me. If u have any document for that. please send to my ID

rajesh_1582@yahoo.com

Thanks in advance

Rajesh

[Former Member]

Hi AMIT BAJ and Rajesh,

I have the same requirement with you, could you please give me your solution document for that, thank very much,

please send to my email address:

charles.bo.lin@accenture.com

or just post your solution in here.

Urgent!!!

[Former Member]

Hi,

Take a look at this -

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f027dde5-e16e-2910-97a4-f2310464...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e698aa90-0201-0010-7982-b498e02a...

Hope this helps,

Bye...

[Former Member]

Could you please email me documents you have received from Rajesh.

My email is shailendra.jain@owenscorning.com

[Former Member]

Hi Michael

As you suggest to use the web service data source, I just want to confirm the same as I have the XML file at the desk top and I want to load the data from that file to BI.

In this case still web service data souce will work?

Thanks in Advance.

Amit

[Former Member]

Hello Amit,

a WebService data source can not pull data. The data needs to be pushed to BW via SOAP, Proxy ... etc.

Kind reg.

Michael

[Former Member]

Hello Amit,

please follow the next steps:

(1) create a WebService SourceSystem

(2) create a DataSource --> SourceSystem see (1)

(3) generate DataSource

(4) create InfoPackage

---> the Webservice is gernerated and can be used

(5) send data via WebService to BW

(6) data is inserted in the PSA (no Delta Queue is used anymore)

I hope I haven't forgot a step.

Cheers

Michael

SAP AG RIG

[Former Member]

Amit

This is Sat again. Did you check these links

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm.

Thanks

Sat