Skip to content

Connectors for Web Services#

Amazon EC2

Amazon EC2#

Connect to your Amazon account to measure your Ec2 usage. Analyze the instances, volumes, and images associated with your Amazon account.

Configuring Amazon EC2 as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Amazon EC2" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Enter the the "AWS Access Key" and the "AWS Access Secret" and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

JIRA

JIRA#

Prerequisites#
INFO

Set up your JIRA instance and create an API token there. Make sure you know your user name and the API token as the password.

Configuring JIRA as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "JIRA" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Enter the Schema from the drop-down, the host, the port and the root path in the 'Web Service' section.

  4. Enter the user name and password in the 'Authentication' section and confirm with "Next". The 'Save Connection' tab opens.

  5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

GitHub

GitHub#

Github provides a number of APIs to query the various attributes of GitHub repositories. One of the important attributes is the details of the commits made across a repository. Github exposes the APIs over HTTPS. The response format for these APIs are JSON. The GitHub connector allows you to analyze the response of the APIs.

Configuring GitHub as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "GitHub" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. You have two options to authenticate: Choose "Basic Authentication" as the Method, then enter a "User" and "Password", or select "OAuth2 Authentication" click on "Request Access Permission". You are taken to a GitHub portal to generate an OAuth access token for Spectrum.The OAuth code is automatically transferred to the appropriate field and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Google AdSense

Google AdSense#

This connector allows you to connect to a Google Adsense account and import associated data.

Configuring Google AdSense as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Google AdSense" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Click on "Authorize Spectrum to retrieve data". You are then taken to a Google portal to generate an OAuth access token for Spectrum. The OAuth code is automatically transferred to the appropriate field. and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Google Analytics

Google Analytics#

The Google Analytics connector allows you to connect to Google Analytics and import an account's statistical data.

Configuring Google Analytics as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Google Analytics" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Click on "Authorize Spectrum to retrieve data". You are then taken to a Google portal to generate an OAuth access token for Spectrum. The OAuth code is automatically transferred to the appropriate field. and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Google Fusion Tables

Google Fusion Tables#

Fusion Tables is an experimental data visualization web application to gather, visualize, and share larger data tables.

Configuring Google Fusion Tables as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Google Fusion Tables" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Click on "Authorize Spectrum to retrieve data". You are then taken to a Google portal to generate an OAuth access token for Spectrum. The OAuth code is automatically transferred to the appropriate field. and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Google Spreadsheet

Google Spreadsheet#

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

Configuring Google Spreadsheet as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Google Spreadsheet" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Click on "Authorize Spectrum to retrieve data". You are then taken to a Google portal to generate an OAuth access token for Spectrum. The OAuth code is automatically transferred to the appropriate field. and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Marketo REST - Lead List

Marketo REST - Lead List#

This connector allows users to import data from a Marketo account.

Configuring Marketo REST - Lead List as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Marketo REST - Lead List" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Provide the "Web service hostname", the "Client ID", and the "Client Secret" and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Marketo SOAP - Lead Activity

Marketo SOAP - Lead Activity#

This connector allows users to import data from a Marketo account.

Configuring Marketo SOAP - Lead Activity as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Marketo SOAP - Lead Activity" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Provide the "Web service hostname", the "Client ID", and the "Client Secret" and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

New York Times API

New York Times API#

With the New York Times Article Search API, you can search New York Times articles from 1981 to today, retrieving headlines, abstracts, lead paragraphs, links to associated multimedia, and other article metadata.

Configuring New York Times API as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "New York Times API" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Enter the API key you register for at the NY Times development site. Then check that you understand the terms and conditions at http://developer.nytimes.com/Api_terms_of_use and confirm with "Next". The 'Save Connection' tab opens.

  4. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  5. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Salesforce

Salesforce#

Salesforce is an enterprise cloud computing firm. It specializes in social and mobile cloud technologies, including sales and CRM applications helping companies connect with customers, partners, and employees.

Prerequisites#
INFO

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

Configuring Salesforce as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Salesforce" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Select "HTTPS" from the drop-down Schema and enter the "host" and the "root path".

  4. Click on "Authorize Spectrum to retrieve data". You are then taken to a salesforce.com portal to generate an OAuth access token for Spectrum.The OAuth code is automatically transferred to the appropriate field.

  5. Confirm with "Next". The 'Save Connection' tab opens.

  6. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  7. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Twitter REST API

Twitter REST API#

This connector is a powerful tool to perform searches on Twitter. You can create searches using Twitter REST API calls.

Prerequisites#

In order to use the connector, it is required that you have:

  • a Twitter account

  • Twitter developer access

  • a Twitter developer app for use with Spectrum

Configure the Twitter REST API Plug-In#

  1. Click on the "Admin" tab and select "Plug-Ins" from the menu on the left.

  2. Find the "Twitter Plug-In" and click on the gear icon to open the configuration options.

  3. Copy the "Twitter Callback URL".

  4. Log into your Twitter developer account profile and find the app you created associated with Spectrum.

  5. Open the Twitter app and enter/paste the "Callback URL".

  6. In your Twitter developer app, click on the "Keys and Tokens" tab. Copy your "API key" and "API key secret".

  7. In the Spectrum Twitter plug-in configuration, enter your "API key" and "API key secret".

  8. Click "Save".

Configuring Twitter REST API as a Connector#

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Twitter REST API" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. To connect to your Twitter Rest API account, click on "Authorize Spectrum to retrieve data". You are then taken to a Google portal to generate an OAuth access token for Spectrum. The OAuth code is automatically transferred to the appropriate field

  4. Confirm with "Next". The 'Save Connection' tab opens.

  5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Zendesk Connector

Zendesk Connector#

The connector allows you to connect to a Zendesk account and access fields within Zendesk to import the data of those fields to Spectrum.

Configuring Zendesk as a Connector#

To configure a Zendesk connector:

  1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

  2. Select "Zendesk" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

  3. Select "HTTPS" from the drop-down Schema and enter the "host", the "Port" and the "root path".

  4. Enter the "User" and "Password" and confirm with "Next". The 'Save Connection' tab opens.

  5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.