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.
- 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 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 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 -
- 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.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
- 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.php. Required Fields: API Key
- V -
- W -
- X -
- Y -
- Z -
Comments
Please sign in to leave a comment.