Model Lite Data Sources

The following is a list of data sources supported in the Model Lite wizard:

Source

Icon

Target

Compatible with Pulse

Configuration

Access

 

 

Local file upload, or pointer to a shared file on a network drive

Amazon Athena

 

Requires setup and configuration in Administration

Amazon S3

   

Requires setup and configuration in Administration

Apache Presto

Requires setup and configuration in Administration

Apache Hive

 

Requires setup and configuration in Administration

Azure Blob

   

Requires setup and configuration in Administration

DB2

Requires setup and configuration in Administration

Exasol

Requires setup and configuration in Administration

Excel

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

Facebook

   

Requires setup and configuration in Administration

Firebird

 

 

Requires setup and configuration in Administration

Google BigQuery

Requires setup and configuration in Administration

Greenplum (Pivotal)

 

Requires setup and configuration in Administration

In Memory

Requires setup and configuration in Administration

JSON

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

Mongo BI CX

 

Requires setup and configuration in Administration

Multi files

 

 

Enter the shared folder path and the files to include in the upload. Each file must have the same structure (columns).

Note: this data source is not available in the Community Edition.

MySQL

Requires setup and configuration in Administration

OData

 

 

Requires configuration in the client (add the node to the Data Flow and enter the OData Service URL in the Properties panel)

ODBC

     

Oracle

Requires setup and configuration in Administration

PostgreSQL

Requires setup and configuration in Administration

Python as a source

N/A

 

 

Pyramid Queries

N/A

 

 

R as a source

N/A

 

 

Redshift

 

Requires setup and configuration in Administration

RSS

 

 

Add the Feed URL

Salesforce

 

 

Requires setup and configuration in Administration

SAP HANA

 

Requires setup and configuration in Administration

Sas Data Set

 

 

Local file upload, or pointer to a shared .sas7bdat file on a network drive, or URL Address

SharePoint

     

SQL Server

Requires setup and configuration in Administration

SQL Server Azure

 

Requires setup and configuration in Administration

Snowflake

Requires setup and configuration in Administration

Sybase

 

Requires setup and configuration in Administration - select Shared Folder property

Teradata

Requires setup and configuration in Administration

Text

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

Twitter

     

Vertica

     

XML

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address