About david_stocker

david_stocker · 04-03-2024

Good news for customers looking for live data access to Google BigQuery (GBQ)! With the release in Q4 of 2024, SAP Analytics Cloud (SAC) plans to get its first live SQL data access. Google BigQuery (GBQ) will be the first SQL data source consumed by ...

david_stocker · 02-08-2023

This is part of a series on exploring the SAP Analytics Cloud (SAC) data export API. When the series is complete, it will also be available as a single tutorial mission. We’ve taken a tour of SAC’s Model Export API, began constructing our Python AP...

david_stocker · 01-30-2023

This is part of a series on exploring the SAP Analytics Cloud (SAC) data export API. When the series is complete, it will also be available as a single tutorial mission. The completed export API wrapper can be found on github. We’ve taken a tour of...

david_stocker · 01-24-2023

This is part of a series on exploring the SAP Analytics Cloud (SAC) data export API. When the series is complete, it will also be available as a single tutorial mission. Now that we’ve taken a tour of SAC’s Model Export API, we can begin constructin...

david_stocker · 01-11-2023

This is part of a series on exploring the SAP Analytics Cloud (SAC) data export API. When the series is complete, it will also be available as a single tutorial mission. We’ve configured our SAP Analytics Cloud (SAC) tenant to accommodate an applica...

david_stocker · 03-31-2023

You can update master data in private dimensions during the course of loading fact data, but I suspect that this discussion is really about load jobs specific to master data. Loading master data without fact data into a private dimension would sugge...

david_stocker · 05-12-2022

You can't. Excel and csv uploads are always on a one-off basis. If you wanted to serialize uploads, e..g to schedule, you should use a file server, Google drive or sharepoint connection (for the last, you'll need to use BTP open connectors).

david_stocker · 05-04-2022

We don't have this sort of dynamic tables in either the story or the app right now. We've got ideas for how to do it, but nothing concrete on the backlog at the moment. There are a couple of approaches you can take for your use case:1 - You could ...

david_stocker · 05-03-2022

It looks like your S/4 is configured for SAML. SAC's import connection for S/4 uses 3 legged OAuth and needs user/password credentials.

david_stocker · 05-03-2022

Until now, we've not had a clean mechanism to export to DWC; aside from exporting to a file and then uploading that file into DWC. With QRC 2022.Q2 (May 21 general availability), SAC will expose a new OData (REST) export API. With this, DWC will be...

User Statistics

User Activity

Live Data Connectivity to Google Big Query

Data Export API: Building a Python Wrapper (Part 3)

Data Export API: Building a Python Wrapper (Part 2)

Data Export API: Building a Python Wrapper (Part 1)

Data Export API: A tour of the API

Re: Why are only Public dimensions supported for file upload of master data?

Re: How to upload a folder of Excel files in SAC

Re: How to export data from SAP Data Warehouse Cloud?

Re: Logon Credentials SAP Analytics Cloud S/4 HANA ODATA Connection Query

Re: How to export data from SAP Data Warehouse Cloud?