Pre-built data connectors exist for the below data sources In addition, our flexible and open architecture enables connection to all ODBC supported data sources.
| Data Source |
Read Support |
Write Support |
In-Process Execution |
| Excel |
✔ |
✔ |
|
| PowerPivot |
✔ |
✔ |
|
| SQL Server |
✔ |
✔ |
✔ |
| SQL Azure |
✔ |
✔ |
|
| Text |
✔ |
|
|
| Cloudera CDH5; Impala |
✔ |
✔ |
✔ |
| Hadoop Hive |
✔ |
✔ |
|
| Salesforce |
✔ |
✔ |
|
| Oracle |
✔ |
✔ |
|
| mySQL |
✔ |
✔ |
|
| All ODBC-supported data sources |
✔ |
* |
|
| Pivotal Hawq |
✔ |
✔ |
|
| Pivotal Greenplum 4.x or later |
✔ |
✔ |
✔ |
| PostgreSQL 8.3 or later |
✔ |
✔ |
✔ |
* assuming the ODBC provider has write capabilities