Skip to Content
avatar image
Former Member

JAVA(JCO) and BW Connectivity

Hi,

I am using JCO to get data from R/3. At the same time I want to get data from BW server also. Is there any methods available for this activity.

How make it possible, Please provide details.

Thanks,

Ask123

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 31, 2005 at 02:28 PM

    Hi Ashok,

    Read the following weblog written by me to extract data from BW. It's written in JCA but you could do the same in JCO.

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi SS

      Are you using OLAP BAPIs to access data from BI. If yes I would suggest you create a custom RFC in BI where you write your mdx query and then populate an internal table with the query and pass it to the BAPI_MDDASET_CREATE_OBJECT then using the dataset id returned after the BAPI call make calls to the other BAPIs like BAPI_MDDASET_GET_AXISDATA and BAPI_MDDASET_GET_CELLDATA

      Else if you want to do it completely in Java then you better go with BI java sdk with XMLA connector. Here you need to write your java code using the APIs available in BI Java SDK. You can have a look at sdn or SAP help for detail documentation on BI Java. Plz note here you need to configure the XMLA connector through Visual Admin to use it in BI java.

      Cheers

      Sudip