TM1 and SAP HANA Integration

Post Reply
deepakjain2020
Regular Participant
Posts: 150
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

TM1 and SAP HANA Integration

Post by deepakjain2020 » Thu Apr 18, 2019 10:42 am

Hi All,

We need to access SAP HANA Views or tables in Cognos TM1.
Can someone help me in getting information on what is the best way to connect to SAP HANA from TM1.

Regards,
Deepak Jain

Bucjeff
Posts: 13
Joined: Tue Jul 28, 2015 4:47 pm
OLAP Product: TM1
Version: Planning Analytics 2
Excel Version: Office 365
Location: Florida USA

Re: TM1 and SAP HANA Integration

Post by Bucjeff » Thu Apr 18, 2019 7:18 pm

We are connecting via ODBC and using sql to extract data from HANA views. Maybe more detail in your question will get more detailed help.
Newb Jeff
10.2.2 FP 3
Excel 2010

deepakjain2020
Regular Participant
Posts: 150
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: TM1 and SAP HANA Integration

Post by deepakjain2020 » Fri Apr 19, 2019 8:06 am

Hi BucJeff,

Did you installed any separate connectors, to create ODBC connection for SAP HANA?
If you can help me in understanding how you created ODBC to connect with HANA directly.

For SQL Server ODBC works fine, but when it comes to HANA, it may not be straight forward.

Regards,
Deepak Jain

moby91
MVP
Posts: 211
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: TM1 and SAP HANA Integration

Post by moby91 » Sat Apr 20, 2019 1:39 pm

You need to download and install the SAP HANA ODBC Driver.
It is commercial software by SAP.
You download it from SAP.
If you can download it, and how you can use it (for trial only or for production), that depends on your relationship/contract with SAP.


Here are some links you may find useful:

https://help.sap.com/viewer/57a28837356 ... 9b950.html
Home/Connecting to your Database Management System on Windows/SAP HANA/Using SAP HANA Service as a Data Source/Connecting to the SAP HANA Service Using the Tenant Database Address/Update Your SAP HANA ODBC Driver

https://community.powerbi.com/t5/Deskto ... d-p/236440
Microsoft Power BI Community > Forums > Get Help with Power BI > Desktop > SAP HANA odbc driver link

a1m80t
Posts: 2
Joined: Mon Mar 09, 2015 11:54 pm
OLAP Product: TM1
Version: 9.1 to 10.2.2
Excel Version: Office 2010

Re: TM1 and SAP HANA Integration

Post by a1m80t » Mon Apr 22, 2019 6:47 pm

TM1 to HANA integration isn't really different and works as expected. I have connected TM1 to HANA with and without SSO/SSL

1. Download and Install ODBC Drivers as mention by Moby91 on the TM1 Server
2. Configure "Windows ODBC Data Sources" as with any other ODBC driver

Drg
Posts: 114
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: TM1 and SAP HANA Integration

Post by Drg » Tue May 07, 2019 1:18 pm

hi
deepakjain2020
we have the development but to upload the data from tm1 to SAP HANA where we use the JDBC driver. Loading data bypassing ODBC looks very dangerous, with timeouts of data types and all the rest ....
Perhaps it makes sense for you to upload data from HANA to files and then upload them to tm1 :roll:

Post Reply