DCM Supported Connectors and Tools
DCM supports these tools and connectors.
|
Tool / Connector |
Technology (if applicable) |
Available with 21.4 |
|
Input/Output Data |
||
|
Oracle |
ODBC |
YES |
|
|
Quick connect |
YES |
|
|
OCI |
YES |
|
|
OleDB |
NOT NEEDED |
|
|
Bulkload |
YES |
|
MSSQL |
Quick connect |
YES |
|
|
ODBC |
YES |
|
|
OleDB |
NOT NEEDED |
|
|
Bulkload |
YES |
|
HDFS |
|
YES |
|
Amazon Athena |
ODBC |
YES |
|
|
Bulkload |
YES |
|
Amazon Aurora |
ODBC |
YES |
|
Amazon Redshift |
ODBC |
YES |
|
|
Bulkload |
YES |
|
Amazon Redshift Spectrum |
ODBC |
YES |
|
|
Bulkload |
YES |
|
Cassandra |
ODBC |
YES |
|
Databricks |
ODBC |
YES |
|
EXASOL |
ODBC |
YES |
|
Hive |
ODBC |
YES |
|
IBM DB2 |
ODBC |
YES |
|
|
OleDB |
NOT NEEDED |
|
IBM Netezza |
ODBC |
YES |
|
Impala |
ODBC |
YES |
|
Microsoft Analytics Platform System |
ODBC |
YES |
|
|
Bulkload |
YES |
|
|
OleDB |
NOT NEEDED |
|
Microsoft Azure SQL Data Warehouse |
ODBC |
YES |
|
|
Bulkload |
YES |
|
|
OleDB |
NOT NEEDED |
|
Microsoft Azure SQL Database |
ODBC |
YES |
|
|
Bulkload |
YES |
|
MySQL |
ODBC |
YES |
|
NetSuite |
ODBC |
YES |
|
Pivotal Greenplum |
ODBC |
YES |
|
PostgreSQL |
ODBC |
YES |
|
|
Bulkload |
YES |
|
SAP Hana |
ODBC |
YES |
|
Snowflake |
ODBC |
YES |
|
|
Bulkload |
YES |
| OAuth | YES | |
|
Spark |
ODBC |
YES |
|
Teradata |
ODBC |
YES |
|
|
OleDB |
NOT NEEDED |
|
|
Bulkload |
YES |
|
Teradata Aster |
ODBC |
YES |
|
|
OleDB |
NOT NEEDED |
|
Vertica |
ODBC |
YES |
|
Gallery tools |
||
|
Adobe Analytics |
|
NO |
| Anaplan | NO | |
| Automation Anywhere 360 | NO | |
| Box | YES | |
| Dataverse | NO | |
| Dropbox | NO | |
|
Google Analytics |
|
NO |
|
Google BigQuery |
|
NO |
| Google Drive | YES | |
|
Google Sheets |
|
NO |
|
Marketo |
|
NO |
|
Microsoft Azure Data Lake Store |
|
YES |
|
Microsoft Cognitive Services |
|
NO |
|
Microsoft Dynamics CRM |
|
NO |
|
Microsoft OneDrive |
|
YES |
| Outlook 365 | NO | |
| Power BI | YES | |
|
Salesforce |
|
NO |
| SharePoint | YES | |
| Tableau Output | YES | |
| UiPath | YES | |
|
Built-in tools |
||
|
Sharepoint List Input/Output |
|
YES |
|
MongoDB Input/Output |
|
YES |
|
Amazon S3 Download/Upload |
|
YES |
|
Dynamic Input |
|
YES |
|
Download tool |
|
YES |
|
Email tool |
|
YES |
|
Macro support |
|
YES |
|
Machine Learning Send |
|
YES |
|
Machine Learning Predict |
|
YES |
|
In-DB |
||
|
Amazon Redshift |
|
YES |
|
MongoDB Input/Output |
|
NO |
|
Apache Spark Direct |
|
YES |
|
Apache Spark ODBC |
|
YES |
|
Apache Spark on Databricks |
|
YES |
|
Apache Spark on Microsoft Azure HDInsight |
|
YES |
|
Databricks |
|
YES |
|
EXASOL |
|
YES |
| Generic ODBC | YES | |
|
Greenplum |
|
YES |
|
Hive |
|
YES |
|
IBM Netezza |
|
YES |
|
Impala |
|
YES |
|
MS Analytics Platform System |
|
YES |
|
MS Azure SQL DWH |
|
YES |
|
MS Azure SQL DB |
|
YES |
| MS SQL Server | YES | |
|
MySQL |
|
YES |
|
Oracle |
|
YES |
| PostgreSQL | YES | |
|
SAP Hana |
|
YES |
|
Snowflake |
|
YES |
|
Teradata |
|
YES |
|
Vertica |
|
YES |