Google Contacts connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to a Google Contacts database server.

System requirements

Database server

Google Contacts Database Server

Client web browser

• Chrome TM 60 or newer

• Firefox ® 55 or newer

• Safari ® 11.0.2 or newer

Connection instructions

Adding an OAuth security provider

1. Navigate to the App Builder IDE

2. From the Connect menu, click on the Connect to your enterprise link

3. Click on Security Providers then click Create under User Authentication

   

4. To configure Oauth Security Provider, provide the following information:

   • In Settings panel

     • Name: GoogleOAuth (must be named this to match redirect)

     • Type: Select Oauth from the dropdown menu

   • In Properties panel

     • Authorization Endpoint: https://accounts.google.com/o/oauth2/auth

     • ClientId: Credentials from Google API Console (omitted from screenshot)

     • ClientSecret: Credentials from Google API Console (omitted from screenshot)

     • Scopes: https://www.googleapis.com/auth/calendar

       • Visit Google's documentation for further guidance on Scopes. Multiple scopes can be added, separate by a space.

     • Token Endpoint: https://oauth2.googleapis.com/token

5. Click Enabled and Redirect on Challenge.

6. Click Save.

Adding a RDBMS security provider

1. Navigate to the App Builder IDE

2. From the Connect menu, click on the Connect to your enterprise link

3. Click on Security Providers then click Create under Data Source Authentication

   

4. To configure Oauth Security Provider, provide the following information:

   • In Settings panel

     • Name: Recognizable Name

     • Type: Select RDBMS from the dropdown menu

   • In Properties panel

     • AuthorizationType: AuthorizationCode

     • OAuthProvider: Oauth Provider created in previous step

Adding a server

1. Navigate to the App Builder IDE

2. From the Connect menu, click on the Connect to your enterprise link

   

3. Click the Create button on the top left of the Data Servers panel. This will bring up the Add Server page.

   

4. To connect to an Google Contacts server, provide the following information:

   • Name: An identifiable and unique server name

   • Type: Select Google Contacts from the dropdown menu

   • Security Provider: The RDBMS provider set up in previous step

5. After filling in all necessary credentials, click the Save button to save the settings.

6. Click Test Connection to test the OAuth connection and redirect URL.

Import data source

1. Navigate to App Builder IDE.

2. Click on Build Your Application then click on Data Storage Layer.

3. Under Cloud Database find the Google BigQuery Database with the name you chose earlier.

4. Expand the GoogleCalendar panel and click Import

   

5. After import, click on Tables to view imported tables from Google Calendar Server.