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

June 13, 2013 | 3,352 Views |

Riccardo Brogi

more by this author

SAP Data Services

bods bods 4 bods4 bods4.0 business objects data data services

Follow RSS

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! 🙂

—————————————————————————————————————————————————————————————————————————–

Prepare the HANA Server to host the Data Services Repository

Launch the SAP HANA Studio
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
Right click on Users and select New User
Enter username – in this case DSERV_REPO – and password (the password have to be changed after the first logon) and click on Deploy
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…
Enter the required information and click on Next >
Enter the credentials of the user you just created and click on Finish
Enter a new password and click on OK
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

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)
Click on System DNS tab and then on Add button
Select HDBODBC (in this document is assumed that SAP HANA Client was already installed on the machine where SAP BusinessObjects Data Services is running)
Enter a name for the data source, the host name and the connection port; click on Connect to test it
Enter the credentials of the user previously created on HANA
If the connection is successful, click on OK and close all the windows
Launch the Data Services Repository Manager; clicking on Start -> All Programs -> SAP Business Objects Data Services -> Data Services Repository Manager
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
Click on Get Version to check you are not going to overwrite an existing DB
If the system reports the DB exists but the tables are not valid, you can proceed clicking on Create
Clicking again on Get Version,you will now receive a different message
Click on Close
If you go back to HANA Studio, you can now see that the Tables folder has been populated
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
Click on Data Services
Click on Manage and then on Configure repository
Enter the required information and then click on Test Connection
Click on Save and then on Log Off
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

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
Many repositories can be connected to the same Job Server; so click on Configuration Editor
Select Job Server_1 and click on Edit
Click on Add button
Enter the required information and the click on Apply button
Close the windows clicking on OK and then click on Close & Restart

To report this post you need to login first.

18 Comments

You must be Logged on to comment or reply to a post.

Former Member June 13, 2013 at 8:02 am

very nice effort.

could you please share the same for ORACLE database (if you have)

like (0)
1. Riccardo Brogi Post authorJune 13, 2013 at 8:27 am
  
  Hi Shiva,
  
  thanks for the positive comment! 🙂
  
  Regarding point 2, in my landscapes no ORACLE DBs, sorry.
  
  like (0)
  1. Former Member June 13, 2013 at 3:27 pm
    
    Hi Riccardo,
    
    It is was a awsome brief about how to do it, I’m facing a problem, and you may able to help me, I have create tables(as Target) in my Datastore which is part of Repository, to perform ETL.
    
    this created table could be imported to HANA Studio i dont know why ? to be able to execute Batch-Job :-/ any solution ?
    
    Thanks alot
    
    Mirella
    
    like (0)
    1. Riccardo Brogi Post authorJune 13, 2013 at 9:20 pm
      
      Hi Mirella,
      
      if I understood well, you would like to use HANA also as your Target DB.
      
      What about using template tables instead of importing “old” tables?
      
      You can easily do it – DS will automatically create “physical” table on HANA.
      
      On HANA Studio, create a new user as you did for the repository
      
      On Data Services Designer, click on the Datastores tab
      
      Right-click in the blank area and click on New
      
      In the new windows, enter a name for you target DB
      
      In the Datastore type box, click on Database
      
      In the Database type box, click on SAP HANA
      
      In the Database version box, select HANA 1.x
      
      Check the field Use data source name
      
      In the Data source name box, select the connection to your HANA Server
      
      Insert username & password of the freshly created user
      
      Click on OK button
      
      Open the desired Data Flow and, from the tools palette on the right, select Template Table
      
      Click on the blank space
      
      Enter a name for the table; in the Datastore field select your HANA DB
      
      When you execute the job for the first time, this table would be created inside HANA DB.
      
      like (0)
      1. Former Member June 13, 2013 at 9:54 pm
        
        Hi Riccardo,
        
        I think, you have got me wrong, and sorry for not explaining more clearly, I have already created template tables (as target )and I wanna these to be imported to HANA but it is not working with me at all (weird) :-/ at the beginning it has worked (I could import two tables ) but the others couldn’t .
        
        I thank you very very much !!
        
        Regards,
        
        Mirella
        
        like (0)
        
        Riccardo Brogi Post authorJune 14, 2013 at 6:07 am
        
        Hi Mirella,
        
        ok, I was totally wrong 🙂 .
        
        Essentially, after running a job, you click on the magnifying lens on the bottom-right corner of the target table you can see a SQL error message, right? Honestly no idea what’s the issue…
        
        Have you tried to create a table on HANA, import it on DS Designer and use it as target?
        
        Can you upload at least a screenshot?
        
        Regards,
        
        Riccardo.
        
        like (0)
        
        Former Member June 14, 2013 at 7:17 am
        
        Hi Riccardo,
        
        I did, but didnt work out too 🙁
        
        what i should do ?
        
        Regards,
        
        Mirella
        
        like (0)
        
        Riccardo Brogi Post authorJune 14, 2013 at 2:28 pm
        
        Hi Mirella,
        
        really no clue… just a stupid question: are you using an HANA instance on Amazon EC2?
        
        Is your HANA system currently reachable by the system where you are running DS?
        
        You can easily check it using ODBC (Start -> Control Panel -> Administrative Tools and then click on Data Sources).
        
        Regards.
        
        like (0)
        
        Former Member June 14, 2013 at 3:36 pm
        
        Hi Riccardo,
        
        No, i don’t …does the version of the JobServer or the Repository play a role ?
        
        i have checked ODBC, everything is perfect ..but still having a problem
        
        Regards
        
        like (0)
        
        Riccardo Brogi Post authorJune 17, 2013 at 4:11 pm
        
        Hi Mirella,
        
        no clue…it looks like a problem on HANA side.
        
        Regards,
        
        Riccardo.
        
        like (0)
Former Member July 3, 2013 at 4:56 am

Thanks, very useful. One question: I created a HANA repository by using the user “SYSTEM” and would like to delete this repository now.

Is this possible and how to do that? I didn’t find a “Delete” option in the repository manager.

like (0)
1. Riccardo Brogi Post authorJuly 3, 2013 at 5:23 pm
  
  Hi Wolfgang,
  
  I think you can simply delete it from HANA Studio.
  
  like (0)
  1. Former Member July 10, 2013 at 8:43 am
    
    Hi Riccardo,
    
    thanks a lot!!! I tried that and was able to delete the tables vie HANA studio. But unfortunately I cannot delete the according schema, because the deletion of a schema with the prefix “_SYS_” is not permitted. Data Services create the schema “_SYS_DATAPROV”
    
    like (0)
    1. Riccardo Brogi Post authorJuly 10, 2013 at 12:59 pm
      
      Hi Wolfgang,
      
      are you working with the user “SYSTEM”?
      
      If you created the schema using this user, I’m pretty confident you should be able to delete the schema – anyway I can’t verify it, since I don’t know “SYSTEM” credentials of my HANA Server.
      
      like (0)
      1. Former Member July 11, 2013 at 4:44 am
        
        Hi Ricardo, I created the repository via BOBJ repository manager and so the name of the schema in HANA was created automatically with the prefix “_SYS_”. But you cannot delete a schema with prefix “_SYS_” in HANA…..
        
        like (0)
Former Member November 14, 2013 at 8:34 pm

Hi Riccardo,

Nice step by step blog. What would be the benefit of using HANA DB as repository vs MSSQL? Is there any speed benefit of data processing by jobs?

Thanks,

Rajan

like (0)
1. Riccardo Brogi Post authorNovember 19, 2013 at 5:37 pm
  
  Hi Rajan,
  
  actually this was just an exercise for me, I was just checking if HANA could be used to store also BODS repositories.
  
  And I’m confident you will not face any performance improvement for BODS jobs using HANA… now I expect to be contradicted soon 🙂
  
  Regards,
  
  Riccardo
  
  like (0)
Former Member November 15, 2013 at 6:51 pm

Thank you

Regards,

Jose

like (0)