Data Sources and Sinks
Intended audience: END-USERS DEVELOPERS ADMINISTRATORS
AO Platform: 4.3
Overview
This topic includes a reference list of the Data Sources and Sinks available in the AO Platform.
Data Providers | Available in | Data Source | Data Sink | Structured Response | Raw Response | Comments |
|---|---|---|---|---|---|---|
CSV | YES | YES | YES | Read comma, tab or custom delimited text files | ||
RSS | YES | YES | Read RSS feed URL | |||
REST | YES | YES | Read data from REST URL | |||
Google Search | YES | YES | YES | Run a search using Google custom search engine | ||
HTML | YES | YES | YES | Read content of a web page that returns HTML content | ||
YES | YES | Read content of a PDF document | ||||
PDF Text | YES | YES | YES | Read text content from PDF | ||
PDF Image | YES | YES | YES | Extract and write an Image from/to PDF file | ||
PDF Bounding Box | YES | YES | YES | Read content of a PDF document | ||
PDF Page | YES | YES | Read data from PDF Pages | |||
Microsoft Powerpoint | YES | YES | Read content of a powerpoint presentation and returns the content as a string | |||
Microsoft Office File | YES | YES | Read Microsoft files (Excel, PPT, Visio, Word) | |||
Microsoft Excel | YES | YES | YES | Read and write Excel file that contains less than 20,000 records | ||
Microsoft Excel Large | YES | YES | YES | Read Excel file that contains more than 20,000 records | ||
Microsoft Word | YES | YES | Read data from WordDocx4j | |||
File List | YES | YES | Returns list of files from a specified directory | |||
H2 - Database | YES | YES | YES | Read and write data from/to H2 (JDBC) | ||
PostgreSQL - Database | YES | YES | YES | YES | Read and write data from/to PostgreSQL (JDBC) | |
SAP HANA - Database | YES | YES | YES | YES | Read and write data from/to SAP HANA (JDBC) | |
Oracle - Database | YES | YES | YES | YES | Read and write data from/to Oracle (JDBC) | |
MySQL - Database | YES | YES | YES | YES | Read and write data from/to MySQL (JDBC) | |
Microsoft SQL Server - Database | YES | YES | YES | YES | Read and write data from/to Microsoft SQL Server (JDBC) | |
Microsoft SQL Server - Analytics Services | YES | YES | YES | Read data from Microsoft SQL Server - Analytics Services | ||
Apache Hive - Database | YES | YES | YES | Read and write data from/to Apache Hive (JDBC) | ||
Amazon Redshift - Database | YES | YES | YES | YES | Read and write data from/to Apache Redshift (JDBC) | |
Apache Cassandra - Database | YES | YES | YES | Read and write data from/to Apache Cassandra (JDBC) | ||
Apache Druid - Database | YES | YES | YES | YES | Read and write data from/to Apache Druid (JDBC) | |
CrateDB - Database | YES | YES | YES | Read and write data from/to CrateDB (JDBC) | ||
SnappyData - Database | YES | YES | YES | Read and write data from/to SnappyData (JDBC) | ||
Google BigQuery - Database | YES | YES | YES | YES | Read and write data from/to Google BigQuery (JDBC) | |
Azure Synapse Analytics | YES | YES | YES | Read data from Azure Synapse Analytics | ||
Azure Data Lake Storage | YES | YES | YES | Read data from Azure Data Lake Storage (JDBC) | ||
Jira | YES | YES | YES | Read data from Atlassian Jira (JDBC) | ||
Databricks | YES | YES | YES | Read data from Databricks (JDBC) | ||
Salesforce - Database | YES | YES | YES | Read and write data from/to Salesforce (JDBC) | ||
Neo4j - Database | YES | YES | YES | Read and write data from/to Neo4j (JDBC) | ||
Snowflake - Database | YES | YES | YES | YES | Read and write data from/to Snowflake (JDBC) | |
Elasticsearch - Database | YES | YES | YES | YES | Read and write data from/to Elasticsearch (JDBC) | |
MongoDB - Database | YES | YES | YES | Read and write data from/to MongoDB (JDBC) | ||
Oracle 12c - Database | YES | YES | YES | Read and write data from/to Oracle 12c (JDBC) | ||
Weaviate - Vector Database | YES | YES | Read and write data from/to Weaviate | |||
Pinecone - Vector Database | YES | YES | Read and write data from/to Pinecone | |||
Trino | YES | YES | YES | Read data from Trino | ||
Any File Content | YES | YES | Read content of a file and return as a string | |||
GeoJSON | YES | YES | YES | Read and write from/to GeoJSON file | ||
URL Crawler | YES | YES | WebCrawler returning URLs for a website | |||
JPA | YES | YES | YES | Read and write from/to relational database using JPA repositories | ||
Cache | YES | YES | YES | Read and write objects from/to Ignite Cache | ||
Asprise OCR | YES | YES | Read content from an Image using Asprise OCR | |||
Tessaract | YES | YES | YES | Read content from an Image using Tess4J OCR/API | ||
Any Data | YES | YES | YES | Read content from any data - text, list or map | ||
Esri Shapefile | YES | YES | Read GIS data from an ESRI Shape file | |||
Esri REST | YES | YES | Read content from ArcGIS Rest services | |||
File Metadata | YES | YES | Read metadata of a file | |||
S3 File List | YES | YES | Read files from S3 AWS Bucket | |||
Custom Data | YES | YES | Read and write from/to custom datasource | |||
XML | YES | YES | YES | Read data from XML file | ||
XML REST | YES | YES | Read data from XML REST file | |||
Stored Procedure | YES | YES | Read data from Stored Procedure | |||
Config Database | YES | YES | Read data from PostgreSQL database | |||
URL Content | YES | YES | Read data from External article | |||
Image | YES | YES | YES | Read and write from/to Image | ||
YES | YES | YES | Read and write data from/to Email | |||
Autocomplete Elasticsearch | YES | YES | Read data from Autocompletion Elasticsearch | |||
Google Vision | YES | YES | YES | Read data from Google Vision | ||
Resource Path List | YES | YES | Returns list of Resource path files from a specified directory | |||
MSO Query | YES | YES | Read data from a JDBC compliant RDBMS database | |||
Python | YES | YES | Read data from Python | |||
SAP Ariba REST | YES | YES | Read data from SAP Ariba REST URL | |||
Solr | YES | YES | YES | Read and write data from/to Solr search | ||
SOAP | YES | YES | YES | Read data from SOAP data source | ||
JSON | YES | Write data to a file in the JSON format | ||||
MSO Data | YES | Write data to output as an MSO | ||||
File Download | YES | Download file from a designated URI | ||||
Log | YES | Write data to Log file | ||||
Notification | YES | Raise an AO Platform server notification | ||||
File Upload | YES | Upload a file | ||||
DocuSign | YES | Write data to Docusign file | ||||
Text File | YES | Write data into a TextFile | ||||
Kafka | YES | Write data to Kafka | ||||
File Cleanup | YES | Delete a File | ||||
DOCx to PDF | YES | Write data from DOCx to PDF | ||||
File Copy | YES | Write data to File Copy | ||||
Directory Copy | YES | Write data to Directory Copy | ||||
JMS | YES | Write data to JMS | ||||
Split PDF to Images | YES | Split PDF to Images |