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 S3: The Amazon S3 plugin provides access to data files hosted on S3. Required Fields: Bucket, Region.
AWS Snowflake: The AWS Snowflake plugin allows connection into Snowflake databases. Required fields: Tables and Views, Database, Account, Password, Queries, Username.
- 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.
COVID Tracker: The COVID Tracker plugin allows easy access to data collected by the COVID Tracking Project. Required fields: none
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
EnergyStar: based off https://portfoliomanager.energystar.gov/webservices/home/. Required fields: Username, Password
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 documentation. Required 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/api. Required 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 Analytics: The Google Analytics reads from the Google Analytics API. For information about creating a service account and downloading the credential file, see: https://developers.google.com/analytics/devguides/reporting/core/v4/authorization#service_accounts. For all metrics and dimensions information: https://ga-dev-tools.appspot.com/dimensions-metrics-explorer/ Required fields: Credential File Path
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_id. Required Fields: API Key, Spreadsheet ID
- H -
HAPI-FHIR: The HAPI-FHIR plugin reads data from a server using the FHIR standard for health care data exchange. Data must use the H7 schema. Required fields: Server URL.
- I -
Imap: IMAP plugin for reading from email servers. Required Fields: Password, Port, Server, Username
IBM DB2: The IBM DB2 plugin provides access to tables and views within the specified IBM DB2 database. Required Fields: Tables and Views, Database, Address, Password, Queries, 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
Mark43: The Mark43 plugin reads from Mark43 CAD Required Fields: Department, Password, Username
Microsoft Access: The Microsoft Access plugin provides a connection to tables found in Access files. Required Fields: Root Directory
Microsoft Dynamics: The Microsoft Dynamics plugin supports access to Dynamics user reports and queries. Required Fields Client ID, Client Secret, Username, Password, Resource
Microsoft 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
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.html. Required 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
SurveyMonkey: The SurveyMonkey plugin reads responses from SurveyMonkey surveys using an access token Required fields: Access Token
- 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 (NOTE: For other connections to Munis tables and views, the MSSQL plug-in is recommended)
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 Burea of Economic Analysis (BEA): The BEA plugin provides access to the Bureau of Economic Analysis API for various geographic and demographic details. More information about the API and the API Key please visit the User Guide: https://apps.bea.gov/API/signup/index.cfm Required fields: API Key
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.php. Required Fields: API Key
US Environmental Protection Agency (EPA): The EPA plugin provides access Air Quality System (AQS) API. The AQS is the primary place to obtain row-level data from the EPA's Air Quality System (AQS) database. Required fields: Key, User ID
- V -
- W -
Waze: https://www.waze.com/ccp : Supports traffic, alerts, and irregularities Required fields: Polygon (search area)
- X -
- Y -
- Z -
Comments
Article is closed for comments.