Why our Data Export Service runs via Google

Why our Data Export Service runs via Google

At first, it might sound like an extra administrative burden: adding yet another platform. When you read that authentication for our Data Export Service  is handled via Google, understandable concerns may arise regarding additional administrative burden or the need to manage a new supplier. We understand that completely. 

Nevertheless, we made this  choice very deliberately. In this article, we explain why this approach  not only helps meet current security requirements, but is ultimately also more efficient and secure for your organization. 

No proprietary API, but piggybacking on cloud-native benefits

We are sometimes asked  why we do not offer the data via a standard, self-built API. The answer is practical: the integration capabilities and security  of a cloud-native solution  are many times more extensive and robust than we can facilitate ourselves via a standalone API. 

With this setup, for example, you can integrate the data directly with various dashboarding  tools, something that is not immediately possible with a standard API. Additionally, you can  use the standard  Google REST API and excellent client libraries in a wide variety of programming languages. This makes retrieving, linking, and processing the data much simpler and more stable. 

No data replication: access  to data that already exists

Our Spend Cloud is hosted on the Google Cloud Platform (GCP). For our data warehouse, we use Google BigQuery, a serverless solution. 

A  major advantage of this approach is that we  do not need to replicate or move any data for this export solution. The data is already securely stored in our data warehouse. Using Google  's robust authentication methods, we simply provide you with direct and secure access to your data already stored there  via so-called "views" .     

This brings fundamental advantages.  Google Cloud complies with the strictest contemporary security standards. Because we use  GCP , Google is already a sub-processor under GDPR (we process your data, Google processes it via us). Therefore, no new or unknown data processor is added to the chain.      

Data management: Take control of your data

A logical concern  is that business data  becomes linked to an unmanageable, standalone account. For robust data manageability, it is crucial that control  remains entirely on your side.
 We use a  Google Account to authenticate to the data . Although it is technically possible to use a (private)  Gmail account for this  , we advise against it. The best and most manageable option is to  link a Google Account to an existing business email address. 

By extending an organization-specific address to a  Google Account, you retain control.  If a colleague leaves the company or a role changes, access remains  manageable via your own domain. From this account,  we then jointly generate a Service Account (with access keys) for daily,  automated retrieval tasks by, for example, your BI tool or data warehouse solutions. 

The misunderstanding: A  Google Account vs. a  Gmail Account

Confusion often arises  regarding the terms 'Gmail' and 'Google Account'. They are sometimes used interchangeably  , but for management, the difference is fundamental: 
  1. A  Google Account  is purely an identity and authentication layer (your digital passport to securely  log in to services, such as  Google Cloud or BigQuery).
  2. A  Gmail Account  is a specific email service with an @gmail.com address, which happens to be linked to a Google Account by default 
        
So you absolutely do  not need a new  Gmail account  for this integration; you can use your own trusted corporate domain

How do you set this up?

We have limited the required configuration in  GCP to the absolute minimum and provide  detailed documentation on how to set this up. 

The first step is simple: take an existing business email address and register it as a  Google Account. 
  1. Go to this Google support page. 
  2. Start halfway down the page at the heading " Use an existing  email address " (or "Use an existing email address"). 
As soon as this address is set up and provided to us, we will grant access  to the data views. We will then schedule a short meeting  (30 minutes is more than sufficient) to finalize the setup  on the  Google Cloud side together and create the necessary Service Account. 

Want to know more about the content of the export? Then view the complete documentation on the Data Export Service . 
    • Related Articles

    • Advanced usage of the Spend Cloud portal (Application Managers)

      In the webinar below about using the Spend Cloud Portal for advanced users (Dutch only), we would like to cover a range of skills that will help you get even more out of the Spend Cloud Portal. Are you already familiar with all the functionalities of ...
    • Valuable Insights in the Spend Cloud via ChurnZero

      At Visma | ProActive, we are committed to continuously supporting you as our customer and providing valuable insights into how you use Spend Cloud. That’s why we’re excited to announce an important update about a new subprocessor: ChurnZero. What is ...
    • Where can I see if Spend Cloud has performance issues?

      Unfortunately, there are times when we can experience a system outage. Through announcements here in the portal, we keep you informed in such situations about the problem and provide an estimate of the resolution times. Why are these outages listed ...
    • ProActive as an independent unit within the Visma Group

      In 2018, Visma, a business software provider, acquired the majority of shares in ProActive. Together with Visma's sister companies, ProActive can offer a comprehensive package for all business expenses and HR. ProActive is the company behind the ...
    • Ask your questions about the Spend Cloud via DIRK Chat Help

      To better assist all our users with questions about the Spend Cloud, we have introduced DIRK Chat Help. In this article, we explain everything about how to chat with our AI assistant, DIRK, and what you can expect. What is DIRK Chat Help? DIRK Chat ...