SAP DATASPHERE Integration with SAC, Power BI, Tableau and MS Excel - Step-by-step|| BI Tools ||
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Step by Step Data Sphere Integration with SAP Analytics Cloud (SAC), PowerBI, Tableau and MS Excel ||
Topics Covered :
Create a Story in SAC with Data Sphere model and create the same story in PBI, Tableau.
Data Sphere integration with Power BI
Data Sphere integration with Tableau
Data Sphere integration with MS Excel
Steps:
Install HANA client : SAP Development Tools (ondemand.com)
Create DB user in Datasphere
Whitelist IP address : www.whatismyip...
Create ODBC Connection.
Difference of using SAC and other 3rd party tools.
Datasphere Trial setup link : • SAP Datasphere (Data W...
#powerbi #tableau #hanabi #hana #sap #btp #sapbtp
keep working hard
Osm
Good keep it up
brilliant
All time favourite
Biggest fan 💕
Loved it
keep up the hard work
Fascinating oh nycc 🥰
This is osm
love this video
Gazab 🤩
Hola, Muchisimas Gracias...pude realizar mi conexion desde Power BI a DataShpere..Genial tu video :)
you're welcome. Happy to hear it helps you.
keep it up ❤
Superb 👏🏻
Thanks ☺️
Wow good video 😍😍😍
Thanks 🤗
Wah wah wah
nice keep it up😍😍😍
very nice keep it up
Thanks a lot
wowwwww
really good
Very nice...
awsm yaar so awsome 😱😱😱
Fablous
So satisfying
Excelente...Muchisimas gracias
hope you give us the vibe as same you are giving💜💔💔💔💔
really love this
Starring beautiful
Thank you! 😊
Lot’s of love
Hello thanks for covering different tools from a visualization point of view.
1. So for proper representation in Power BI or Tableau we need to do modifications at SAP Datasphere End right?
2. But for Excel to get column descriptions what are the steps we need to do at Datasphere. Could you please provide information about that?
Yes, whatever we can do for PBI and Tableau helps for excel as well because all these 3 options we are consuming Datasphere via ODBC connection. Hope it helps
well try
i respect everyone🥰🥰
Great work man
Thank you....
Great video! I have a question though I was able to upload view from datasphere to power bi using the ODBC but for some reason its not brining in my associations, Do you have any suggestion on that?
Are you able to preview the data in Datasphere view / ADS? Please check you associations defined properly. Jus to test you can try without any association and check in PBI, if that works try adding one by one and test. Let me know your findings.
sir i am getting this error Connection failed(cannot create ssl engine received invalid ssl record header) while connecting at the navigator page of the powerbi while loading data
Could you please share the error message screenshot. Most probably the issue may be due to IP address and IP address should be the external/your internet providers not the one you get from ipconfig which is local.
Can u give some info on hdi containers option and open sql schema
Sure, will prepare a use case and create the video soon!!!
what ip address i should enter there ? i did correctly but still facing error in odbc
sorry for late response... this ip address is not the one we get in ipconfig... this is external ip address which you can find by seaching in google to find external ip address or directly use www.whatismyip.com . basically this is your ISP ip. Ex: If your using Verizon internet then verizon is ur ISP and you have to enter this ISPs ip. even if you're using any 3rd party internet service and unable to find external ip address, you can call their customer care and ask whats ur public Ip.