Data, Process, Insights & things I write about
Analysing the data in SAP systems can be done in many ways. While SAP would like all customers to use the tools from their portfolio, many customers prefer to use other platforms. Snowflake is arguably one of the most… Read More » SAP Factory Calendar in Snowflake
Apart from writing blog posts I have written answers to many questions on several Q&A sites like StackOverflow and SAP Community. Some of those answers received good feedback and/or the answer surprised me once I worked… Read More » Answers Pinboard
When SAP tries to explain HANA as a technology the buzz words “Big Data” have always been part of the story. Commonly “Big Data with HANA” then gets specified to mean one or another thing - often to caveat what the… Read More » SAP HANA middle of the road for Big Data or just average?
What is this about? # In his blog post Why are scalar UDFs so slow? Jörg Brandeis wonders why user defined scalar functions (scalar UDFs) are slow compared to plain SQL. This is an important question since UDFs would… Read More » Why are your scalar UDFs slow? (mine aren't)
Remember my post from earlier in April 2020? (Getting data into HANA - the easy way) In it, I described how to use DBeaver to load CSV files into HANA quick and hassle-free. For DBeaver activities like importing or… Read More » DBeaver log files: beware and free up disk space
In a recent blog post SAP presented several ways to load data into a HANA instance. The main approach shown was to use a combination of Python, SQLAlchemy, and Pandas (a Python data analysis library) as well as the… Read More » Getting data into HANA - the easy way
Q&A forums can be a treasure trove of interesting questions that turn out to have counter-intuitive answers. In “Why does select statement taking too long when primary key is present?” the OP made an interesting… Read More » One in a Million
One of the benefits of answering questions from users is that there usually is a pretty good chance that I will learn something along the way. Today’s case was no different. In fact, I learned quite a bit. Read More » Machine learnings of hana, odbc, and macos
Sometimes, when I am looking for the solution to a problem by googling, I find my own blog posts or forum replies. These found-again solutions are one of the nice returns from prolonged activity in forums and usually a… Read More » [NTM] HANA STUDIO NoClassDefFoundError: javax/xml/soap/SOAPException
Most folks working with SQL DBs for a while will likely come to see how beginners in this area struggle with “declaritive code” and “tell the DB what you want not how to do it” Read More » New year, same issues and some tips.