Creating a Dataset from Google Drive Data

You can import data from Google Drive into a dataset.

Context

Note
If your SAP Analytics Cloud system is hosted on a data center located within China, this feature is not available.

When you connect to Google Drive, you can import any of the following file formats: Google Sheets, comma-separated-values text files (csv), and Microsoft Excel files (xlsx).

Note
The login prompt for Google Drive is displayed in a popup dialog. You'll need to disable the popup blocker in your browser before trying to connect.
Note
You can also import files from Google Drive in stories when adding data to a new story.

Procedure

  1. Create a new dataset and choose a data source:
    1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  DatasetEnd of the navigation path.
    2. Select Data from a data source.
    3. Select Google Drive.
    Note
    From the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
  2. Select a Google account, or create a new Google connection, or type or paste the URL for your file directly into the dialog.
    For your first access to Google Drive, you'll need to sign in to your Google Drive account.
  3. Choose a file from the list, and select Next.
  4. If you're importing from Google Sheets, and there are multiple sheets, select the sheet you want to import, and select Next.
  5. If you're importing a .csv file, select which delimiter is used in the file, or select Auto-detect.
  6. Select OK to begin the import procedure.

Results

The data is imported from Google Drive, and is displayed in the data integration view.
Note
You are still signed in to Google. When you are finished using SAP Analytics Cloud, it is recommended to sign out of your Google account. To sign out, you can select Sign Out in the Select Google Drive File dialog, or sign out of Google in your browser.

Next Steps

After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.