DCM Supported Connectors and Tools
DCM supports these tools and connectors.
Tool / Connector |
Technology (if applicable) |
Supported |
Input/Output Data |
||
Oracle |
ODBC |
YES |
|
Quick connect |
YES |
|
OCI |
YES |
|
OleDB |
NO |
|
Bulkload |
YES |
MSSQL |
Quick connect |
YES |
|
ODBC |
YES |
|
OleDB |
NO |
|
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 |
NO |
IBM Netezza |
ODBC |
YES |
Impala |
ODBC |
YES |
Microsoft Analytics Platform System |
ODBC |
YES |
|
Bulkload |
YES |
|
OleDB |
NO |
Microsoft Azure SQL Data Warehouse |
ODBC |
YES |
|
Bulkload |
YES |
|
OleDB |
NO |
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 |
NO |
|
Bulkload |
YES |
Teradata Aster |
ODBC |
YES |
|
OleDB |
NO |
Vertica |
ODBC |
YES |
Gallery tools |
||
Adobe Analytics |
|
NO |
Anaplan | YES | |
Automation Anywhere 360 | NO | |
Box | YES | |
Dataverse | NO | |
Dropbox | NO | |
Google Analytics 4 |
|
YES |
Google Drive | YES | |
Marketo |
|
NO |
Microsoft Azure Data Lake Store |
|
YES |
Microsoft OneDrive |
|
YES |
Outlook 365 | YES | |
Power BI | YES | |
Salesforce Input |
|
YES |
Salesforce Input | NO | |
SharePoint | YES | |
Tableau | 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 |