基于BI Publisher和BI analytics的WebService实现BIEE报表开发（一）

一、BIEE WebService API ：

1、BI Publisher WebService API
http://docs.oracle.com/cd/E28280_01/bi.1111/e22259/reportservice.htm

2、BI analytics WebService API
http://docs.oracle.com/cd/E21764_01/bi.1111/e16364/soa_overview.htm

 

二、BI Publisher WebService：

1、http://192.168.18.188:9704/xmlpserver/services/ReportService?wsdl
   http://xmlns.oracle.com/oxp/service/report       

2、http://192.168.18.188:9704/xmlpserver/services/v2/SecurityService?wsdl
   http://xmlns.oracle.com/oxp/service/v2

3、http://192.168.18.188:9704/xmlpserver/services/PublicReportService?wsdl
   http://xmlns.oracle.com/oxp/service/PublicReportService

4、http://192.168.18.188:9704/xmlpserver/services/v2/ScheduleService?wsdl
   http://xmlns.oracle.com/oxp/service/v2

5、http://192.168.18.188:9704/xmlpserver/services/XMLPService?wsdl
   http://xmlns.oracle.com/oxp/service/report

6、http://192.168.18.188:9704/xmlpserver/services/v2/ReportService?wsdl
   http://xmlns.oracle.com/oxp/service/v2

7、http://192.168.18.188:9704/xmlpserver/services/v2/CatalogService?wsdl
   http://xmlns.oracle.com/oxp/service/v2

8、http://192.168.18.188:9704/xmlpserver/services/ServiceGateway?wsdl
   http://xmlns.oracle.com/oxp/service/service_gateway

 

三、BI analytics WebService：

1、http://192.168.18.188:9704/analytics/saw.dll/wsdl/v6

 

四、根据wsdl文件生成WebService Client

Install / Download WTP

First, you need to install WTP:

or you can just download a complete bundle.

You will find for instance in WTP:

• Axis
• The Jst Server: J2EE Server Tools framework and adapters for selected popular J2EE servers such as Apache Tomcat and OC4J

Creation of a project

First, we need to create project that support the web service. If you go to the preference (Menu/Window/Preference), you can see in the Project Toplology of the web service, that you can use three type of client :

• Dynamic Web Project
• JPA Project
• Java Utility Project

Therefore, we start by creating a java utility project : Menu / File / New Project / Java EE / Utility Project

I use the OC4J server of OBIEE. If you don't know how to configure OBIEE to use OC4J, you can have a look to this article : Eclipse - How to add OC4J as an Eclipse server

Web service client wizard

Then, we have to consume the web service by launching the new web service client wizard and giving it the WSDL file location. For OBIEE, the web service URL is in the form :

http://obiee_host:port/analytics/saw.dll?WSDL

The WSDL contain the complete definition of all class and function that provide the Web Service. More about WSDL ....

Right click on your project, New / Others / Web Service / Web Service Client

Next, we give the web service URL :

http://obiee_host:port/analytics/saw.dll?WSDL

The level must be by default on “Deploy Client”.

Next, check the check box “define custom mapping for …”.

In the next step, you have to enter the namespace of the OBIEE webservice implementation. You can find it in the WSDL file. Just enter the URI, in a browser and you will see in the first line the OBIEE WSDL namespace :

http://obiee_host:port/analytics/saw.dll?WSDL

In the above case, we fina that the namespace is com.siebel.analytics.web/soap/v5.

Then we click on the Add button and enter this values :

• namespace : com.siebel.analytics.web/soap/v5
• package : com.siebel.analytics.web.soap.v5

 

The name of the package must follow the Java rules. No slash as you can find in the namespace.

The result

When you click on the finish button, WTP will create all class and functions by parsing the WSDL file.

You are now ready to use them !

 

附上PDF版本API