Skip to Content
Technical Articles
Author's profile photo Hiroki Sakamoto

How to create connection with Google Drive in SAP Analytics Cloud

Introduction

I’ll explain how to use the data from Google Spreadsheet on SAP Analytics Cloud.

After reading this blog post, you can import data from Google Drive and create batch scheduling to refresh data.

 

 

1. Prepare the dataset on Google Drive

First of all, you have to create a dataset and upload the file on Google Drive.

You can edit data on Google Spreadsheet. The points to change will be reflected after refreshing on SAP Analytics Cloud.

 

 

2. Create connection with Google Drive in SAP Analytics Cloud

Then, we will create connection between Google Drive and SAP Analytics Cloud.

Open SAP Analytics Cloud and move to “Modeler”.

Select “From a Data Source”.

 

Select “Google Drive”.

 

Select “Google Account” and click “Create New Connection”.

 

Select Google Account that you upload the dataset.

 

Select “Allow”.

 

Fill out “Google Account Name” and “Description”.

Select “Create”.

 

Select “Google Account” that you registered.

Select “Next”.

 

You can see the file(dataset) you upload.

Select the file and you can access the dataset on Google Drive.

 

Setup the model and click “Create Model”.

 

 

3. Visualize the dataset

Move to “Stories” and select the model.

You can visualize the datasets from Google Drive.

 

 

4. Refresh data on SAP Analytics Cloud

You can add modifications to Google Spreadsheet.

After edited the datasets, you need to open the model and click the refresh icon.

 

The model was refreshed manually.

If you create batch scheduling, click the calendar icon to setup.

 

 

Conclusion

You can create connection with Google Drive and refresh data easily in SAP Analytics Cloud.

Check steps below to do smoothly.

  1. Prepare the dataset on Google Drive
  2. Create connection with Google Drive in SAP Analytics Cloud
  3. Visualize the dataset
  4. Refresh data on SAP Analytics Cloud

If you need more help, please leave me a comment.

 

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Peter Baumann
      Peter Baumann

      Hi Hiroki!

       

      Do you see some Enterprise scenarios using Google Drive with SAC?

       

      Thanks,

      Peter

      Author's profile photo Hiroki Sakamoto
      Hiroki Sakamoto
      Blog Post Author

      Hi Peter,

       

      Hi Peter!

       

      Thank you for the comment.

      I think this feature is very effective for marketing departments. Marketing departments often use Google Analytics and Google Form to understand market reactions. If they create a connection with Google drive, they can integrate  these data and visualize on SAP Analytics Cloud. that help them to find insights easier.

      What's more, It is a common use case in the context of budget planning. Customers sometimes manage and aggregate data by department, region and things like that on Google Spreadsheet. Connection between Google Drive and SAP Analytics Cloud helps customers to reuse it and use the Planning function to do more sophisticated budget control.

       

      Hiroki