Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Hello SAC, OneStream, and Google BigQuery curious,

in this blog we are going to run down the architecture of today's big planning and analytics market players: SAP Analytics Cloud, OneStream, and Google BigQuery.

This is Filippo, I am working for more than 15 years in the Financial Planning and Analytics universe, both with Functional-Business, Developer, and Application hats.

I would like to share with you the main architecture design for SAP Analytics Cloud, OneStream, and Google BigQuery.

Let's start with SAP Analytics Cloud:

SAC is running as an application on HANA 2.0.x tenants, on hyper scalers.

It can be either deployed as public  (sharing underlying HANA tenant) or private: in this last case, SAC will have a whole HANA system for itself.


Fig 1. From, link in Bibliography


HANA lives on VMs on any chosen hyper-scaler, SAC lives on HANA

SAC doesn’t call any hyper-scaler services as it resides on a HANA tenant.



Now let's look into the OneStream architecture:

Fig 2. From, link in Bibliography


this is a classic architecture, with OneStream XF Framework helping the Application Server to fulfill all the requests.

Going to the application level details, we can see:

Fig 3. From, link in Bibliography


Here, the Web Server Set calls different General Access and Queue Requests.

At the far end of the stack, SQL server instances are used both for Framework and Application.



Finally, this is the Google BigQuery Architecture:

Fig 4. From, link in Bibliography


BigQuery is leveraging BORG (the Google Orchestrator):

Fig 5. From, link in Bibliography

This is a Cloud Native Architecture, with Storage and Compute functions decoupled from servers.


Hope this architecture rundown has been useful for your business.


If you liked the article, please like and share it, and do not forget to add me to your LinkedIn profile.


See you soon on







SAP Analytics Cloud

One Stream


Labels in this area