Java Application ,SAP BW

[Former Member]

Hi,

I have a problem something like this:

Using Java i need to Update and maintain Data in SAP BW system. These are customer or 'Z' tables.Data is stored in BW system.

I NEED HELP ON HOW TO START OFF WITH AN APPLICATION that implements java connectors with SAP BW to manuipulate BW tables.

Any source of info that cud give me a clear idea on coding and prerequistes stuff to do make this application running is much much appreciated.

It wud be gr8 if someone cud atleast throw some light.

Thank you so much guys .

Regards.

[gregorw · Accepted solution]

Hello Naresh,

you have to write ABAP RFC Enabled Function Modules in the BW Server to do what you want. They can be called with SAP JCo.

Regards

Gregor

[Former Member · Accepted solution]

Thanx for the answer Gregor,

But iam confused with the concepts like:

1.Java BI SDK.

2.Netweaver Developer studio(NDS).

3.Web Application server 6.4(WAS).

while surfing online i found lot of details on how to build a java application using BI java connectors libraries in a NDS and deploy it in WAS.

Using those(BISDK)APIs, we can connect to BI and manipulate the tables.

I actually thought of coding ABAP RFC using SAP Jco.

Could You plz, look into it and advise?

thanx.

Bye

[Former Member]

hi naresh,

there is nothing confuse in the new concepts. its very clear the BI Java SDK is a new free open source software developed by SAP. This is new technology where SAP had opened the gates to access the bw data using the Java. with this application it is very easy to access or manipulate the BW data, its a new modern terminology in accessing...just follow these:

as the BI Java SDK application program sequence look like:

1. first you connect to sap bw via. differenct available BI Java connectors and select the one how u wish to continue.

2. what kind of metadata u want to extract from bw like infocube, ods or master data. using the bi java methods

3. in general by several methods u can create a query or defalut query with measure and can be implemented.

4. when u run the java application the rendering results are displayed in a mode of html or as per ur choice.

just try in this way.

coming to ur next question with NW Dev studio, its an IDE from SAP used for enhanced plug-ins for sap developement applications. this is based on eclipse ide and other example could be jbuilder ide.

the last question is WAS it is a web application server 6.40 from SAP similar like websphere, apache kind of like this. this was concentrates more on 3 layers.

by using bi java API u can connect and manupulate the bw tables. i am sure in this. i tried in accessing and extractin data with this bi java. coming to my knowledge where as Jco can extract data from only OLTP SAP systems not for BW. if u need further help just ping me. have fun

rgds,

srinu...

[Former Member]

Hi Srinu,

i surfed through the forums searching for some guidance and found your post...

Maybe you can help me with my "problem": I am creating a Java-Application (independent from SAP) and have to get data of an SAP BW-Infocube (or query) and work with it in my application.

I know that I can get data with the BI SDK but I haven't worked with it so much and only recognized, that all the tutorials use JSPs and Servlets that I don't want to use. Can I use these methods from the BI SDK also in a "normal" Java-Environment?

The other possibility would be to work with the JCo. Do I have to write own ABAP-Code to extract data from the BW or are there any existing BAPIs, which could do that for me?

Thanks in advance for your help.

Markus

[Former Member]

check out my following weblog. It's written in JCA but you can easily rewrite the code in JCO.

/people/prakash.singh4/blog/2005/03/12/get-bw-data-in-portal-via-jca-using-mdx-statement

[Former Member]

If you are talking about the J2EE Connector Architecture, I believe the official spec says you should also be able to use the connection in a non J2EE environment...

Enjoy