Integrating SAP Analytics Cloud with Google BigQuery

| Analytics , Google Cloud , SAP Analytics Cloud ,

Google BigQuery is a cloud based data warehouse which manages large datasets. You can now import data from Google Big Query into SAP Analytics Cloud and start building visualizations. In this blog we will discuss how to integrate Google BigQuery with SAP Analytics Cloud. Our team has successfully integrated SAP HANA with Google BigQuery, and built stories on SAC connecting to BigQuery. However, in this blog we have used a BigQuery Public dataset to walk you through the integration process. Follow the steps outlined below on how to create an account in GCP and consume public datasets into SAP Analytics Cloud .

1.    Login to Google Cloud Platform.

connecting-sap-analytics-cloud-with-google-big-query

2. To create a GCP project, go to Manage Resourcesoption and click on create Project. Fill in the required details and click on Create.

connecting-sap-analytics-cloud-with-google-big-query

connecting-sap-analytics-cloud-with-google-big-query

3. BigQuery is automatically enabled in new projects. To activate BigQuery in a pre-existing project, go to Enable the BigQuery API.

4. Now, from the main menu, click on the Big Query.

connecting-sap-analytics-cloud-with-google-big-query

 

5. BigQuery public datasets are not displayed by default in the BigQuery web UI. To open the public datasets project, enter the following URL in your browser.

https://console.cloud.google.com/bigquery?p=bigquery-public-data&page=project

Click on PIN PROJECT once the project is opened.

connecting-sap-analytics-cloud-with-google-big-query

Next, let’s look at process to review data in the Google cloud platform through BigQuery (SQL).

1.  For this example, I have taken Public data provided by Google. Below is the raw table present in the Platform.

connecting-sap-analytics-cloud-with-google-big-query

2. Below is the SQL code used to get the data from the table which we need for our story.

 

connecting-sap-analytics-cloud-with-google-big-query

 

3. Click Run Query to test it, and make sure you see the query results without any issues.

connecting-sap-analytics-cloud-with-google-big-query

4. Now login to SAC and click on Create -> Model.

5.  Click on “get data from a data source”

6.  Select the “Google BigQuery”

7.  Select Create new connection

connecting-sap-analytics-cloud-with-google-big-query

8. Enter a name and description for the connection to be created, and  click sign in to the Google Cloud Platform.

connecting-sap-analytics-cloud-with-google-big-query

connecting-sap-analytics-cloud-with-google-big-query

9. Google will ask for permissions to link SAC.

connecting-sap-analytics-cloud-with-google-big-query

10. Once you sign in there will be option to select the project in which data is present (in Google Cloud). Select the project and click Ok.

connecting-sap-analytics-cloud-with-google-big-query

11.  Now this connection has been created. Using the above connection, we will be able to retrieve the data. Select “create new query” and click on Next

connecting-sap-analytics-cloud-with-google-big-query

12. Enter the details of the query and select “Freehand Query”, then copy and paste the SQL code in the query panel. Click on Next.

connecting-sap-analytics-cloud-with-google-big-query

13. Data will be saved as a draft, click on the draft for creating a model.

connecting-sap-analytics-cloud-with-google-big-query

14. Once all the required validations are done, click on the Create Model.

connecting-sap-analytics-cloud-with-google-big-query

Now the required data is obtained form the google cloud platform. On this model we can create a story to showcase the data.

Nineboards can help optimize your Google cloud migration strategies and identify the specific services that suit your business when deploying BigQuery. Contact us today to learn more.

Share with:

FacebookTwitterLinkedIn