...
| Table of Contents |
|---|
| Info | ||
|---|---|---|
| ||
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 | ||
|---|---|---|
| ||
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:
- Create a Client ID for Web application in your Google account.
- Set an authorized redirect URI for the local Datameer X instance.
Prepare the default properties in Datameer X:
- Open the 'default.properties' file under '/<Datameer installation folder>/conf/live.properties'
- 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 - Restart Datameer X.
Configuring Google Spreadsheet as a Connector
...