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 |
||
|
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 |
||
|
|
|
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 |
|
|
|
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 |
||
|
||||
Vertica |
||||
XML |
|
Local file upload, or pointer to a shared file on a network drive, or URL Address |