Importing Google Drive Data to a New or Existing Model

If your data files are stored on Google Drive, you can connect directly to Google and select a file from there.

Context

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. Select the appropriate option:
    • If you're creating a new model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Start of the navigation pathGet data from a datasource Next navigation step Google DriveEnd of the navigation path.
        Note
        From the acquire data panel, select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.

    • If you're importing into an existing model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step DatasourceEnd of the navigation path.
      5. Select Google Drive.
        Note
        You can select the filter icon to narrow down the number of datasources in the list. You can filter by datasource 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.
  7. Select the appropriate option:
    • If creating a new model: In the Draft Data dialog, select the dataset that you just uploaded.
    • If importing to an existing model: In the Draft Sources list, select the dataset that you just uploaded.

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 the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.