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 |