Socrata Gateway: Available Plugins

A variety of plugins are available for Socrata Gateways. This list will change as plugins are added. 

List of Plugins

A -B - C - D - E - F - G - H -I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

- A -

Amazon S3The Amazon S3 plugin provides access to data files hosted on S3. Required Fields: Bucket, Region.

- B -

- C -

CKAN: The CKAN plugin reads items from a CKAN instance and ports them over. Allowable file types: csv, xls, xlsx, tsv, kml, kmz, json, geojson, zip. Required Fields: CKAN URL.

CSV: The CSV plugin reads a CSV file from a specified directory and uploads the contents of the CSV file. Required Fields: Root Directory

- D -

Datasync: The DataSync plugin reads a SIJ file from a specified directory and uploads the contents of the specified CSV file. Required Fields: Root Directory

- E - 

Elastic Search: The Elastic Search plugin supports access to Elastic Search endpoints to pull json given defined indices. Required Fields: Port, Server

Esri: The ESRI plugin provides access to ESRI Map and Feature Servers via their REST endpoints. For more information about the ESRI REST service, please see the developer documentationRequired Fields: ESRI REST URL

Excel: The Microsoft Excel plugin reads the contents of a specified sheet within an Excel spreadsheet and uploads its contents. Required Fields: Root Directory.

Exchange: The Microsoft Exchange plugin supports API access to metadata pertaining to email and calendar items linked to a specified account. Required Fields: Email Address, EWS Server, Password

- F - 

FBI: The FBI API plugin provides access to the API maintained by the FBI containing aggregate crime statistics reported through UCR annual reports. For more information about the API and getting an API key, please see: https://crime-data-explorer.fr.cloud.gov/apiRequired Fields: API Key

FTP: The FTP connects to a provided FTP server and allows access of files contained on the server. Required Fields: Binary transfers, Host, Use passive mode, Password, Port, Username

- G -

Google Sheets: The Google Sheets plugin supports reading directly from a particular sheet within the document and uploading the contents. The sheet must be set so that anyone with a link can view the sheet. For more information on creating a Google API key, please see https://cloud.google.com/docs/authentication/api-keys. For information on the Google Sheets ID, please see https://developers.google.com/sheets/api/guides/concepts#spreadsheet_idRequired Fields: API Key, Spreadsheet ID

- H -

- I -

Imap: IMAP plugin for reading from email servers. Required Fields: Password, Port, Server, Username

- J -

Jira: The JIRA plugin reads ticket metadata through the JIRA API. The default base fields that will be pulled are: creator, reporter, assignee, priority, status, updated, created, duedate, resolutiondate, summary, description. Custom fields can also be specified in the plugin configuration. Required Fields: Custom Fields (optional), Custom JQL Query (optional), Password, URL, Username.

- K -

- L -

- M -

Marketo: The Marketo plugin supports access to Dynamics user reports and queries. Required Fields: Client ID, Client Secret, Custom FIelds, URL

Microsoft Access: The Microsoft Access plugin provides a connection to tables found in Access files. Required Fields: Root Directory

Microsoft SQL Server: The Microsoft SQL Server plugin provides access to table and views within the SQL Server. Required Fields: Database, Address, Password, Username

MySql: The MySQL plugin provides access to table and views within the MySQL database specified. Required Fields: Database, Address, Password, Username

- N -

- O -

 Oracle: The Oracle plugin provides table and view level data sources to be used to power Socrata datasets. The Oracle JDBC must be downloaded and the terms and conditions accepted. More information can be found at: https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.htmlRequired Fields: Database, Address, Password, Username

- P -

PostgreSQL: The PostgreSQL plugin provides table and view level access to postgres databases. Required Fields: Database, Address, Password, Username

PostgreSQL Queries: The PostgreSQL plugin provides query level access to postgres databases. Required Fields: Database, Address, Password, Username

- Q -

- R - 

- S -

Salesforce: The Salesforce plugin reads from the Salesforce API. Due to Salesforce restrictions, queries with two or more custom fields with long text fields are limited to 200 responses per request. Required Fields: Password, Security Token, Username

SAP HANA: SAP HANA database connector. Required Fields: Tables and Views, Database (default: SystemDB), Address, Instance Number (optional), Password, Queries, Username

SeeClickFix: The SeeClickFix plugin provides API access to the SeeClickFix Open311 compliant API based on the V2 schema. For more information about the API and rate limits please see: http://dev.seeclickfix.com/Required Fields: Open 311 Account ID

ServiceNow: Access to Service Now. Required Fields: Password, URL, Username

SFTP: The SFTP plugin connects to a provided SFTP server and allows access of files contained on the server. Required Fields: Host, Password, Port, Username

Shapefile: The shapefile plugin grabs a local zipped shapefile and ingresses it into Socrata. Required Fields: Root Directory

SQLite: The SQLite plugin connects to a provided SQLite file and provides access to tables. Required Fields: Root Directory

Sumo Logic: The Sumo Logic plugin allows searching. Required Fields: Access ID, Access Key

- T - 

Tyler Incode: The Tyler Incode 10/Infinite Visions plugin reads from the database OData API for supporting financial transparency applications. Required Fields: Client ID, Client Secret, Integration, Password, Start Year, URL, Username

Tyler Munis: The Tyler Munis plugin enables the integration with the Tyler Munis ERP product for financial transparency applications. Required Fields: Database, Address, Integration, Password, Query, Username

Tyler New World ERP: The Tyler New World ERP plugin enables financial application integration with New World ERP system. Required Fields: Database, Address, Integration, Password, Query, Username

Tyler New World Public Safety: The Tyler New World Public Safety plugin provides citizen connect and CompStat integrations with the New World system. Required Fields: Database, Address, Integration, Password, Query, Username

Tyler Odyssey: The Tyler Odyssey plugin provides Socrata integrations with the Odyssey court system. Required Fields: Database, Address, Password, Schema, Username

- U -

US Census: The US Census plugin provides access to the Census API for various geographic and demographic details. More information about the API and the API Key please visit the User Guide: https://www.census.gov/data/developers/guidance/api-user-guide.html Required Fields: API Key

US Energy Information Administration: The US Energy Information Administration plugin provides access to the US Energy Information Administration API. More information about the API and the API Key please visit the User Guide: https://www.eia.gov/opendata/register.phpRequired Fields: API Key

- V -

- W - 

- X -

- Y -

- Z - 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.