Happy SAP HANA Friends
This is a presentation that I did on the Community Theatre at SAP TechEd Las Vegas 2012.
In this presentation, Blagbert helps his friends Nerdbert to set up his first SAP HANA project using different technologies like:
- Python to feed up SAP HANA with some random data.
- R to consolidate the data
- PowerBuilder to consume the data and present it on a graphical style.
If you didn’t attend TechEd in Las Vegas, here’s your chance to see my presentation.
If you attend TechEd in Las Vegas, but you didn’t attend my presentation…well…shame on you! It was a nice presentation 🙂
Feel free to comment 😉
Sorry This confuses me sometimes. I am very new to Hana actually SAP. I have lot of experience in data warehousing. The point that fascinated me into Hana was we don't to have aggregate tables, because its so fast. But I think this example contradicts that message.
Its a very good as a example of how to integrate various technologies. But the point that you are saving data with the aggregates confuses me. My question is as a data architect do I need to design systems with tables for aggregates as shown in the example? It contradicts the purpose and selling point of Hana, at least to me ...
Anil:
Sorry if this leads you to confusion...but we have to differentiate between what can't be done and what you don't need to do.
It's true that in SAP HANA you don't need to store aggregates in tables, because aggregation can be done on the fly, but...keep in mind that my example is using SAP HANA and R, not just SAP HANA. I wanted to show people how to use R and how to save data into a table...I could have used a regression model or other statistic function from R...but the thing is that I wanted to consume the data from PowerBuilder, so in order to be more consistent with my overall example, I needed to break the law a little bit and get that information in a table.
Of course, I wouldn't want anyone to that in a production environment, but my blogs never have that aim...my blogs are about exploring different ways to do things, and for this particular example, this totally makes sense.
Thanks for you comment and I hope my explanation is good enough for you 🙂
Greetings,
Blag.
Alvaro,
Thank you, The reason why questioned that was because, we had a very old similar system running on production. we don't use R but use PL/SQL and load a set of tables accessed by Powerbuilder. When I saw your example it just reminded me about it.
Thank you very much and I look forward for more nice stuff.
Anil