Create a DWC - SAP BW Bridge Project
We’ve started our first Data Warehouse Cloud (DWC) project using SAP BW bridge.
Before you start modelling BW objects in SAP BW bridge, you first needed to create an SAP BW bridge project.
The BW bridge project is used to manage the connection to the SAP BW bridge tenant that you want to work with.
The BW bridge project acts as a container (on the front end) for the SAP BW bridge metadata objects located in the system.
The following is a step-by-step guide to create an SAP BW Bridge Project (please note - SAP BW Modelling Tools version 1.24 PL1 (=1.24.13) must be installed).
1. Open the BW Modelling Tools (in either eclipse or SAP HANA Studio).
2. To launch the project creation wizard, choose File -> New -> Project in the main menu.
3. Select the project type Business Warehouse -> BW bridge Project and choose Next.
4. In the Connection to an ABAP Service Instance dialog, choose Use a Service Key and choose Next.
5. You now need to determine the Service Key from the SAP Data Warehouse Cloud
· Logon to SAP Data Warehouse Cloud Tenant.
· From the side navigation, choose Space Management.
· Select the space BW Bridge.
· Navigate to the section Connections -> Settings -> Select Go to Connections.
· Mark the local connection BWBRIDGE and choose Edit.
· Under SAP BW Bridge Modelling Tools Access choose (Copy to clipboard) next to SAP BW Service Key.
· Due to an issue, the SAP BW Service Key may contain superfluous lines that must be manually removed. To check if this is required, format the copied string with an offline JSON viewer and verify if the service key starts with these lines:
· Only in this case, remove the following lines along with the corresponding closing brace in the second to last line.
6. Once done, paste the service key (above) into the field Service Key in JSON Format and choose Next.
7. In the Logon to the SAP Cloud System dialog, choose Open Logon Page in Browser. A browser window is opened.
8. In the browser window, enter your credentials for your SAP Data Warehouse Cloud tenant (e-mail address and password) and logon. You should see the message "You have been successfully logged on".
9. You can close the page in the browser and continue in SAP HANA Studio / Eclipse.
10. In the Service Instance Connection dialog, enter a language key in the field Language and choose Next.
11. In the Project Name dialog, confirm the suggested Project Name or choose an own project name and choose Finish.
12. In SAP HANA Studio / Eclipse, from the main menu choose Window -> Perspective -> Open Perspective -> Other.
13. In the Open Perspective dialog, choose BW Modelling and choose Open. You should see the BW bridge project you created before.
14. When opening the newly created BW Bridge project – the following pop-up window will appear - In the Logon to the SAP Cloud System dialog, choose Open Logon Page in Browser. A browser window is opened.
15. In the browser window, enter your credentials for your SAP Data Warehouse Cloud tenant (e-mail address and password) and logon. You should see the message "You have been successfully logged on".
16. You can close the page in the browser and continue in SAP HANA Studio / Eclipse.
You now have just successfully set up your first BW Bridge Project 😊!!
If you or your colleagues have further questions or queries, please do not hesitate to contact us at firstname.lastname@example.org .