BOIS and BW Connection

[Former Member]

Dear Experts,

Background

BW system is our a single source for data from different legacy and SAP system and therefore we are planning to use BW as staging database for DQ activities. 

What we have done

     1) Created an RFC connection between SAP BW and BOIS

Authorization for the RFC user is SAP_ALL

Issue

   When browsing through table option in Data Insight module of BOIS we are only able to see few folders in extractors but not ay tables

Could anyone let us know how to overcome above issue and also if anyone has followed BW as staging database for BOIS any challenges faced

With Regards

Venkata Kali Akella

[Former Member · Accepted solution]

Hi All,

SAP note 1916294 is holding good for BW as well.

We need to follow steps sequentially.

1. Delete any existing /BODS function group - there is a PDF In the

note that explains how to. (This would need some privilage and needs to be checked from Security personnel).

2. Upgrade SAP - you can skip this step

3. Import transports attached in the note

Please be noted with the above approach we can add tables by name but probable not be able to see all tables at once.

With Regards

Venkata Kali Akella