OIC BI - Call Webservice from Fusion BI Report

Usecase: Here, we have a requirement to get PAAS DB data which will be using in ERP BI REPORT generation. So in simple, we will call an OIC exposed SOAP sync web service( this service will fetch DB data) from FUSION BI report.

Implementation steps:

1. Go to Tools >> Reports and Analytics >> browse catalog >> Administration >> Publisher >> Manage Publisher >> Create a data source for Web service connection.
2. Add a data source  and provide following details:
1. Data source name
2. Server protocol : https or http
3. Server : host name
4. Port: 443
5. URL suffix: ic/ws/integration/v1/flows/soap/SD_EMPLOYEESYNCWSDL/1.0/?wsdl
6. Session timeout: 500
7. Complex type: checked
8. Ws-security: 2004
9. Authentication type: XML Soap
10. Username
11. Password
12. WSDL protected by HTTP basic auth : checked.
13. Add BI Author Role and BI Consumer Role.
3. Create data model based on web service option >> select created data source , method and parameter if any.
4. Go to data tab >> view >> save as sample data and save the data model
5. Create report based on data model and test.

Detailed screenshots:

Create data source for web service connection.

Create data model.

Create Report:

Test:

Notes:

1. If you use basic authentication as security while creating soap connection , then we need to select " WSDL protected by HTTP BASIC auth", else the data model will.give below error:

Parseerror 

H3(This page contains the following errors)

Div(error on line 3 at column 1: Start tag expected , '<' not found)

H3 (Below is a rendering of thr page up to the first letter)

2. We can create data source for following types:

• JDBC 

• JNDI 

•  File 

•  LDAP 

•  OLAP 

•  Web Services 

•   HTTP 

•  Conten Server

3. Disadvantages:

It only supports sync soap service call. It does not support one way or async call.