SAP Analytics Cloud, OneStream and BigQuery architecture rundown

[filipponaggi]

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 help.sap.com, 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 https://femsadev.onestreamcloud.com/, 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 https://femsadev.onestreamcloud.com/, 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 https://cloud.google.com, link in Bibliography

 

BigQuery is leveraging BORG (the Google Orchestrator):

 



Fig 5. From https://cloud.google.com, 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.

https://www.linkedin.com/in/filippo-naggi/

 

See you soon on blog.sap.com

 

Filippo

 

 

 

Bibliography

SAP Analytics Cloud

https://help.sap.com/docs/SAP_HANA_PLATFORM/78209c1d3a9b41cd8624338e42a12bf6/b9489b57634f41afbea1a81...

One Stream

https://femsadev.onestreamcloud.com/OneStreamWeb/Help/Content/PDFs/System%20Requirements%20and%20Arc...

BigQuery

https://cloud.google.com/blog/products/data-analytics/new-blog-series-bigquery-explained-overview