Connect SAP HANA from SAP BO Data Services

[Former Member]

How do I connect IMDB with Data Services.

And what advantages does the other modes of data transfer including Sybase replication have with respect to Data Services

[rajarshi_muhuri · Accepted solution]

HANA DB can be used like any orther DB while connecting from Data Services .

You have to give

Datastore type: Database

Database type : HANA (available in the drop down menu) .

Database version: HANA 1.x

You have to then configure the Datasource :

The link below gives information for connecting HANA with MS Excel. You would have to do the same for connecting Data Services with HANA.

https://www.experiencesaphana.com/docs/DOC-1138

In nutshell

Control Panel -> Administrative Tools -> ODBC Data Source.

Add user datastore ---> and choose the HDBODBC and follow the instructions like HANA server name details along with the port .

The port is 3xx15, where xx = instance number of the HANA

Finally in Data Service Designer , once you have created the Data Source . you can import the tables into Data services.

Please Note : If your Data Services Designer is a 32 bit version , then you have to install 32 bit HANA client .

[Former Member · Accepted solution]

What Should I give the DataSource name while configuring in the ODBC Administration ?

[rajarshi_muhuri · Accepted solution]

I believe that it should be the SID of the HANA database . ( thats what I had done and it worked )

but I am not sure what exactly you are refering to ? Is this Datastore in DataServices or the ODBC admin panel ? you could perhaps share a screenshot.

[Former Member · Accepted solution]

In BODS 4.1, directly you can HANA Connection in the DS connection types, otherwise you can choose ODBC connection.

thanks

Rao

[Former Member · Accepted solution]

For odbc connection check page number 33 ( screen shots )

https://www.experiencesaphana.com/docs/DOC-1138

thanks

rao

[Former Member · Accepted solution]

I dont see that option at all .

[Former Member · Accepted solution]

I see the tables in Data Services , but its giving a SQLODBC error

[Former Member · Accepted solution]

Let me know what is you BODS version? and send complete SQL error trace, and what user you are using? did you check your Roles and Privileges.

Thanks

Rao

[Former Member · Accepted solution]

Can you explain , how one can connect to the HANA DB directly as one can do in case of SQL server etc ?

Thanks

Anna

[Former Member · Accepted solution]

Dear AnnaWeber,

I believe you are coding guy, my previous experience connect HANA DB trhough VB using ODBC Connection, in DS also same thing.

Please see following link

http://goo.gl/CDcR6

at the moment I don't have DS 4.0 system to send screenshot documents sorry for that

i hope above link understand ODBC connection string and some SQL statements.

Thanks

Rao

[Former Member · Accepted solution]

Check this it's nive Video

http://goo.gl/8vtvU

thanks

Rao

[rajarshi_muhuri · Accepted solution]

I could be wrong , but I too never saw an option to connect to HANA without ODBC drivers . This is a pity as there does not seem to exist a native connectivity option . this makes me wonder , what one has to do when the SAP BODS is sitting on a UNIX box.

Anna : To be on the safe side , install both 32 and 64 bit verions of HANA client , and see if it works . Have you imported the table metadata ?

[Former Member · Accepted solution]

Hi Rajarshi,

I am completely new to HANA and have been trying to install the HANA client for windows to connect it to MSEXCEL.

I am able to get SAP HANA MDX provider in the DATA connections for EXCEL.

BUT for the below step:

• Control Panel -> Administrative Tools -> ODBC Data Source.
  Add user datastore ---> and choose the HDBODBC and follow the instructions like HANA server name details along with the port.

I am unable to see HDBODBC when i try to add a new data store.

Will be glad if anyone could help.

Thanks

Gautam

[Former Member · Accepted solution]

Gautam,

Did you install the right version of HANA client, for e.g 32 bit or 64 bit matching your windows configuration?

Also, from a similar issue recently on a different thread, the hana client revision that you install must match the revision version of the HANA server as well. For. eg. if HANA server is revision 26, then you must be installing revision 26 of HANA client and studio as well I suppose.

Thanks,

Anooj

[rama_shankar3 · Accepted solution]

Gautam:

Please make sure that the front-end and backend HANA components are of the same version.

Also, install both versioins (32-bit and 64-bit) version of HANA client tools. From SPS4, there is a new excel 32-bit client for HANA as well. Just incase you are on HANA SPS4.

Hope this helps.

Regards,

Rama

[Former Member · Accepted solution]

Hi

I'm trying to connect my Data service 4.0 SP2 to my HANA server.
It's a particular server cause it's on amazon web service : so i'm having trouble filling the connection informations :

Using the HDBODBC drivers i have to complete those fields :

Data Source Name : Shoud i specify some amazon informations  like instance name ? AMI ID ? or is it something i have to create inside hana via Hana studio ?

Description :

Server and port ( Server:Port ) : on amazon AWS you have the option to create an elastic ip giving you an ip like 2x.2x.xxx.xxx or should i use the full name like ec2.2x-xx-xxx-xxx.compute-x.amazonaws.com:30x15 ?
Should i use the default users provided in Hana : root or hdbadm ? or is there a database specific user for data services ?

Thanks if you can help me

[Former Member]

With DATAservices you have lot of options, you can customize the data before loading to hana.

with slt trigger based replication approach, for example you load MARA table.

all fields and their data gets loaded into hana db.

There are many fields under MARA which is null and never used fields, so with dataservices you can exclude those rarely used fields and load to hana.

With ref to hana db connection use system dsn odbc connection. and then has to create datastore within dataservices specific to hana loading you must choose the created system dsn.

now you have the option of using ABAP dataflows to get data from ECC and load to target which is hana.

[Former Member]

Check Page number 24, for detailed comparison

http://help.sap.com/hana/hana1_tom_en.pdf

thanks

Rao

[rajarshi_muhuri]

It does seem that Data Services is a more versatile ETL tool for loading plus it has Data cleansing capabilities which I dont think the other two modes of data transfer has . Sysbase replication seems to me to be an expensive add on with separate licensing and suports only one to one transfers , and so does the SLT replication.As such Data Services has real time capabilities too and can do the CDCs.

And finally Data Services can be used for Data Migration, data transfer, data cleansing for MDM , BW and now HANA. As per that document link rao has posted , Data services seems to be the winner . but i dont have knowledge of the other two anyway

[Vitaliy-R]

And when discussing advantages of SBO DS, don't forget that DS license (for HANA db as the only target) comes included with HANA Enterprise package. -VR

[Former Member]

Currently three methods are

u2022Trigger-Based Replication

Trigger-Based Data Replication Using SAP Landscape Transformation (LT) Replication Server is

based on capturing database changes at a high level of abstraction in the source ERP system. This

method of replication benefits from being database-independent, and can also parallelize database

changes on multiple tables or by segmenting large table changes.

u2022 ETL-Based Replication

Extraction-Transformation-Load (ETL) Based Data Replication uses SAP BusinessObjects Data

Services to specify and load the relevant business data in defined periods of time from an ERP

system into the SAP HANA database. You can reuse the ERP application logic by reading extractors

or utilizing SAP function modules. In addition, the ETL-based method offers options for the integration

of third-party data providers.

u2022 Log-Based Replication

Transaction Log-Based Data Replication Using Sybase Replication is based on capturing table

changes from low-level database log files. This method is database-dependent.

You need BODS 4.0 latest SP for connect HANA DB,for Heterogeneous Landscape BODS is best option, Only SAP then can use SLT.

if you using only HANA DB, then BODS is good because it do Data Clensing, transfermation, checking.... ( like BW Transferations ).

for more information you can see here

https://websmp110.sap-ag.de/~sapidb/011000358700000604562011D

Personally I like one BODS environment in the Organization