frevvo Latest - This documentation is for frevvo v10.1. Not for you? Earlier documentation is available too.
The Google Connector supports Oauth2 - Open Standard for authorization. This requires the account holder to provide consent to the Google connector to access data on their behalf. This is a manual process and must be done for each Google account associated with the connector.
Cloud customers using the Google Connector for the first time will need to:
In-house customers will need to:
On this page:
Installing the Google Connector is a one time process for frevvo In-house customers. The latest version of the connector is installed for all frevvo Online cloud hosted customers, so you can skip the Installation step.
Follow these steps to install the Google Connector: These instructions assume that you have an in-house installation of frevvo v9.0+ up and running.
Make sure the version of frevvo is compatible with the version of the Google Connector you are installing. View the compatibility matrix to check the versions. If you are not using the correct version of frevvo, first upgrade your frevvo server software.
Download the compatible version of the Google Connector from our Extract the .zip file to a temporary location. Copy the google.war to c:\<frevvo-home>\tomcat\webapps..
If you are running frevvo on your local machine, you must set a domain name for your machine - otherwise you can skip this step.
If you are currently using a previous version of the Google Connector and you want to upgrade, follow these steps if you are using the Tomcat bundle:
Ensure you have downloaded the supported version of OpenJDK. Check Supported Platforms before beginning.
Download the Google Connector.
Rename the google-connector-2.3.1.war to google.war and replace the existing one in <frevvo-home>\tomcat\webapps.
Delete the <frevvo-home>\tomcat\webapps\google directory. If this directory is not deleted then the Google Connector will run from the old directory and the newer version won't take effect.
Continue with step 5.
Ex: For Windows edit the C:\WINDOWS\system32\drivers\etc\hosts file as an administrator and modify the 127.0.0.1 entry with a domain name:
Go to https://console.developers.google.com. Login to the google account that you are going to use with the Google connector. View this Google documentation to help you set up your project: https://developers.google.com/adwords/api/docs/guides/authentication, or follow the steps below. If you have a Location Group/Business Account your Google Domain admin will need to set up the organization and give the frevvo user permission to add projects to it. Please see this google documentation for details.
There are several options to configure the connector with the credentials you downloaded in Step 7 above.
Edit the file and append the prefix client.secrets= to the file content.
Append the prefix client.secrets= to the pasted content from the json file
There are two alternative methods to setting the client_ secret property in the frevvo-config.properties file. You can:
If your frevvo external HTTP port is any port other than Port 8082, you must add the frevvo.google.connector.url property to the frevvo-config.properties file in <frevvo-home>\tomcat\conf directory to set the location of the connector. This property defaults to frevvo.google.connector.url=http://localhost:8082/google. For example, if your external HTTP port is Port 80, add this property:
The google.war installation is now complete.
If you are using the frevvo tomcat bundle, the Google Connector log is located in <frevvo-home>\tomcat\logs. The logfile is named google-connector.YYYY-MM-DD.log. Generating separate logfiles make it much easier to search for errors when troubleshooting connector issues. The connector is designed to use the frevvo-config.properties file.
The Google connector logfile defaults to INFO loglevel. To configure DEBUG level logging for the Google connector log:
Logging output defaults to text format. To switch to JSON format, add this property to the frevvo-config.properties file.