Data Sources and Sinks

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

PDF

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

Email

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

Semantic SQL

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