HOWTO - Create a SAP BusinessObjects Data Services Repository on SAP HANA

[RiccardoBrogi]

Just a brief guide about creating a SAP BusinessObjects Data Services Repository on SAP HANA.

I hope this guide would be helpful for you. Have fun! :smile:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Prepare the HANA Server to host the Data Services Repository

1. Launch the SAP HANA Studio
   
   
2. To create the specific user – and the connected schema that will host all the tables of the new Data Service Repository – expand the desired HANA System and then Security folder
   
   
   
   
   
3. Right click on Users and select New User
   
   
   
   
4. Enter username – in this case DSERV_REPO – and password (the password have to be changed after the first logon) and click on Deploy
   
   
   
   
5. The easiest way to check if the user was successfully created and to change the linked password is to add a new connection to the HANA Server, naturally using the credentials just created. So, right click on the Navigation Panel and select New System…
   
   
   
   
6. Enter the required information and click on Next >
   
   
   
   
7. Enter the credentials of the user you just created and click on Finish
   
   
   
   
8. Enter a new password and click on OK
   
   
   
   
   
9. Expanding the freshly added system, the Catalog folder and the schema DSERV_REPO, you can check that there are no tables inside

Create the Data Service Repository

1. In order to create an ODBC Connection, on the system where SAP Data Services have been installed, navigate to Start -> Control Panel -> Administrative Tools and then click on Data Sources (ODBC)
   
   
2. Click on System DNS tab and then on Add button
   
   
   
   
3. Select HDBODBC (in this document is assumed that SAP HANA Client was already installed on the machine where SAP BusinessObjects Data Services is running)
   
   
   
   
4. Enter a name for the data source, the host name and the connection port; click on Connect to test it
   
   
   
   
   
5. Enter the credentials of the user previously created on HANA
   
   
   
   
6. If the connection is successful, click on OK and close all the windows
   
   
   
   
7. Launch the Data Services Repository Manager; clicking on Start -> All Programs -> SAP Business Objects Data Services -> Data Services Repository Manager
   
   
8. Obviously select SAP HANA as Database type; click on the check box Use Data Source Name and select the ODBC connection you created before; enter username e password
   
   
   
   
9. Click on Get Version to check you are not going to overwrite an existing DB
   
   
   
   
10. If the system reports the DB exists but the tables are not valid, you can proceed clicking on Create
    
    
    
    
11. Clicking again on Get Version,you will now receive a different message
    
    
    
    
12. Click on Close
13. If you go back to HANA Studio, you can now see that the Tables folder has been populated
    
    
    
    
14. Now you need to create a Data Services Connection to the new Data Services Repository stored on HANA.
    Go to Start -> All Programs -> SAP Business Intelligence -> Information platform services 4.0 and click on Information platform services Central Management Console; login on Central Management Console
    
    
    
    
15. Click on Data Services
    
    
    
    
16. Click on Manage and then on Configure repository
    
    
    
    
17. Enter the required information and then click on Test Connection
    
    
    
    
    
    
18. Click on Save and then on Log Off
    
    
19. If you login on Data Services Designer (go to Start -> All Programs -> SAP Business Objects Data Services, click on Data Services Designer), you will see that the new repository is now present
    
    
    
    
    

Configure a job server

1. You now need to configure a Job Server so you can execute jobs on the Data Services Repository hosted on HANA.
   Go to Start -> All Programs -> SAP Business Objects Data Services and click on Data Services Server manager
   
   
2. Many repositories can be connected to the same Job Server; so click on Configuration Editor
   
   
   
   
3. Select Job Server_1 and click on Edit
   
   
   
   
4. Click on Add button
   
   
5. Enter the required information and the click on Apply button
   
   
   
   
6. Close the windows clicking on OK and then click on Close & Restart