Versions Compared

Version Old Version 1 New Version Current
Changes made by

Juliane Wetzel

Juliane Wetzel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Info
titleINFO

Google Spreadsheet lets you store and access data from anywhere. This connector lets you take Google sheets data and import it to Datameer.

Prerequisites

Info
titleINFO

Make sure you have your Google instance configured accordingly. Datameer will retrieve the data with an OAuth token - without revealing a username and a password to Datameer X. 

Prepare your Google instance:

  1. Create a Client ID for Web application in your Google account.
  2. Set an authorized redirect URI for the local Datameer X instance.

Prepare the default properties in Datameer X:

  1. Open the 'default.properties' file under '/<Datameer installation folder>/conf/live.properties'
  2. Add the following lines at the end:
    No Format
    #Google details for get OAuth token
system.property.webservice.google.oauth.client-id=XXXXXX
system.property.webservice.google.oauth.client-secret=ZZZZZZ

  3. Restart Datameer X. 

Configuring Google Spreadsheet as a Connector

  1. Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
  2. Choose Google Spreadsheet from the drop-down list.
  3. To connect to your Google Docs account, click Authorize Datameer X to retrieve data. You are then taken to a Google portal to generate an OAuth access token for Datameer. The OAuth code is automatically transferred to the appropriate field.
  4. If required, add a description and click Save.

Importing Data with the Google Spreadsheet Connector

  1. Click the + (plus) button and select Import Job or right-click in the browser and select Create new > Import Job.
  2. Click Select Connector, choose the Google Spreadsheet connector, and click Next.
  3. Select the worksheets from the associated Google account. Specify where the header row is and then click Next.
    Image Removed 
  4. Review the defined fields and click Next.
  5. Review the schedule and advanced properties for the job and click Next.
  6. Create a description for the import job and click Save.