5.2 Supported Connection Types
This topic lists the connection types that are supported for connecting to Data Transforms.
Note:
APPLIES TO:
Data Transforms that is available as a separate listing on Marketplace called Data Integrator: Web Edition.- For the connectors that require driver installation, you need to copy the jar files to the
/u01/oracle/transforms_home/userlibsdirectory before you add the connection. - Apart from the connection types listed here you can create custom connectors, which you can use to connect Data Transforms to any JDBC supported data sources. See Create Custom Connectors.
| Name | Type | Supported in Data Integrator: Web Edition | Supported in Data Transforms built into Autonomous Database | Supported in Data Transforms built into OCI GoldenGate | Supports Write Operation | Notes |
|---|---|---|---|---|---|---|
| Aha! | Application | Yes | Yes | Yes | No | |
| Ahrefs | Application | Yes | Yes | Yes | No | |
| Amazon Aurora | Database | Yes | Yes | Yes | Yes | |
| Amazon EMR Hive | Database | Yes | Yes | Yes | No | |
| Amazon Redshift | Database | Yes | Yes | Yes | Yes | |
| Apache Hive | Database | Yes | Yes | Yes | No | |
| Apache Spark SQL | Database | Yes | Yes | Yes | No | |
| AWS S3 | Database | Yes | Yes | Yes | No | |
| Azure Billing | Application | Yes | Yes | Yes | No | |
| Azure Compute | Database | Yes | Yes | Yes | No | |
| Azure Data Lake Storage | Database | Yes | Yes | Yes | No | |
| Azure Reserved VM Instances | Database | Yes | Yes | Yes | No | |
| Azure Resource Health | Application | Yes | Yes | Yes | No | |
| Azure SQL Database | Database | Yes | Yes | Yes | Yes | |
| Azure Synapse Analytics | Database | Yes | Yes | Yes | Yes | |
| BigCommerce | Application | Yes | Yes | Yes | No | Requires driver installation |
| Cassandra | Database | Yes | Yes | Yes | Yes | |
| Cloudera CDH Hive | Database | Yes | Yes | Yes | No | |
| Cloudera Impala | Database | Yes | Yes | Yes | No | |
| Confluence Cloud | Database | Yes | Yes | Yes | No | |
| Data Transforms | Service | Yes | Yes | Yes | No | For instructions on connecting to an existing Data Transforms instance, see Create a Data Transforms Connection for Remote Data Load. |
| DataStax | Application | Yes | Yes | Yes | Yes | |
| Delta Share | Application | Yes | Yes | Yes | No | For instructions on creating a connection using Delta Share, see Create a Delta Share Connection |
| DocuSign | Database | Yes | Yes | Yes | No | |
| eBay | Application | Yes | Yes | Yes | No | Requires driver installation |
| EnterpriseDB | Database | Yes | Yes | Yes | Yes | |
| FinancialForce | Application | Yes | Yes | Yes | Yes | |
| FourSquare | Application | Yes | Yes | Yes | No | |
| Generic Rest | Application | Yes | Yes | Yes | No | For information about connecting to any REST service endpoint to create a connection, see Create a REST Server Connection. |
| Generic Rest Config | Application | Yes | No | No | No | For information about connecting to any REST service endpoint to create a connection, see Create a REST Server Connection. |
| GitHub | Application | Yes | Yes | Yes | No | |
| Google Ads | Application | Yes | No | No | Depends on the driver | Requires driver installation |
| Google AdSense | Application | Yes | Yes | Yes | No | |
| Google Analytics | Application | Yes | Yes | Yes | No | |
| Google BigQuery | Database | Yes | Yes | Yes | No | |
| Google Calendar | Application | Yes | Yes | Yes | No | |
| Google Campaign Manager | Application | Yes | Yes | Yes | No | |
| Google Contacts | Application | Yes | Yes | Yes | No | |
| Google Drive | Database | Yes | Yes | Yes | No | |
| Google Search Ads 360 | Application | Yes | Yes | Yes | No | |
| Greenplum | Database | Yes | Yes | Yes | No | |
| Hortonworks Hive | Database | Yes | Yes | Yes | No | |
| HubSpot | Application | Yes | Yes | Yes | No | |
| Hypersonic SQL | Database | Yes | Yes | Yes | Yes | |
| IBM BigInsights | Database | Yes | Yes | Yes | No | |
| IBM DB2 Hosted | Database | Yes | Yes | Yes | Yes | |
| IBM DB2 UDB | Database | Yes | Yes | Yes | Yes | |
| IBM DB2 Warehouse | Database | Yes | Yes | Yes | Yes | |
| IBM DB2/400 | Database | Yes | Yes | Yes | Yes | |
| Informix | Database | Yes | Yes | Yes | No | |
| Jira | Application | Yes | Yes | Yes | No | |
| Klaviyo | Application | Yes | Yes | Yes | No | |
| Magento | Application | Yes | No | No | Depends on the driver | Requires driver installation |
| Mailchimp | Application | Yes | Yes | Yes | No | |
| MapR Hive | Database | Yes | Yes | Yes | No | |
| Marketo | Application | Yes | Yes | Yes | No | |
| Microsoft Dynamics 365 | Application | Yes | Yes | Yes | Yes | |
| Microsoft SharePoint | Application | Yes | Yes | Yes | Yes | |
| Microsoft SQL Server | Database | Yes | Yes | Yes | Yes | |
| Mongo DB | Database | Yes | Yes | Yes | Yes | |
| MySQL | Database | Yes | Yes | Yes | Yes | Make sure that the system variable property sql_require_primary_key is set to OFF. Otherwise, an ADW to MySQL mapping could fail with a “Table does not exist” error.
|
| MySQL Heatwave | Database | Yes | Yes | Yes | Yes |
If MySQL Heatwave database is created with high availability, then write operation is not supported. Make sure that the system variable property |
| Netezza | Database | Yes | No | No | Depends on the driver | Oracle Data Transforms uses the Netezza JDBC to connect to a NCR Netezza database. This driver must be installed in your Data Transforms userlibs directory. See Download the Netezza JDBC driver for more information.
|
| Oracle | Database | Yes | Yes | Yes | Yes | For Data Integrator Web Edition, write operation is supported only on Oracle cloud database targets. For details refer to the Oracle terms of use before deploying the image from OCI marketplace. |
| Oracle Analytics Cloud | Application | Yes | Yes | Yes | No | |
| Oracle Business Intelligence Cloud (BICC) Connector | Application | Yes | Yes | Yes | No | For information about creating a connection using Oracle Business Intelligence Cloud (BICC) Connector, see Create an Oracle Business Intelligence Cloud Connector Connection. |
| Oracle EBS | Application | Yes | Yes | Yes | Yes | |
| Oracle Financials Cloud | Application | Yes | Yes | Yes | No | For information about creating a connection using Oracle Financials Cloud, see Create an Oracle Financials Cloud Connection. |
| Oracle Fusion ERP | Application | Yes | Yes | Yes | No | |
| Oracle Fusion Sales | Application | Yes | Yes | Yes | No | |
| Oracle Fusion Service | Application | Yes | Yes | Yes | No | |
| Oracle GoldenGate – OCI | Service | Yes | Yes | Yes | Yes | |
| Oracle Marketing Cloud | Application | Yes | Yes | Yes | Yes | |
| Oracle NetSuite | Application | Yes | Yes | Yes | No | For information about creating a connection using Oracle Netsuite, see Create and Use an Oracle NetSuite Connection. |
| Oracle Object Storage | Database | Yes | Yes | Yes | Yes | For information about creating a connection using Oracle Object Storage, see Create an Oracle Object Storage Connection. |
| Oracle People Soft | Application | Yes | Yes | Yes | No | |
| Oracle Sales Cloud | Application | Yes | Yes | Yes | No | |
| Oracle Service Cloud | Application | Yes | Yes | Yes | No | |
| Oracle SIEBEL | Application | Yes | Yes | Yes | No | |
| PayPal | Application | Yes | Yes | Yes | No | |
| Pivotal HD | Database | Yes | Yes | Yes | No | |
| Pivotal HDB | Database | Yes | Yes | Yes | No | |
| PostgreSQL | Database | Yes | Yes | Yes | Yes | |
| Qmetry | Application | Yes | Yes | Yes | No | |
| QuickBooks Online | Application | Yes | Yes | Yes | No | |
| QuickBooks Payments | Application | Yes | Yes | Yes | No | |
| Quora Ads | Application | Yes | Yes | Yes | No | |
| Sage | Application | Yes | Yes | Yes | No | |
| Salesforce Chatter | Application | Yes | Yes | Yes | No | |
| Salesforce.com | Application | Yes | Yes | Yes | Yes | |
| SAP BW/4HANA | Database | Yes | Yes | Yes | No | |
| SAP HANA | Application | Yes | Yes | Yes | No | |
| SAP NetWeaver | Database | Yes | Yes | Yes | No | |
| SAP S/4HANA Cloud | Application | Yes | Yes | Yes | No | |
| Semrush | Application | Yes | Yes | Yes | No | |
| ServiceNow | Service | Yes | Yes | Yes | No | |
| Shopify | Application | Yes | Yes | Yes | No | Requires driver installation |
| Snowflake | Database | Yes | Yes | Yes | Yes | |
| Square | Application | Yes | Yes | Yes | No | |
| Stripe | Application | Yes | Yes | Yes | No | |
| Sybase As Anywhere | Database | Yes | Yes | Yes | Yes | |
| Sybase as Enterprise | Database | Yes | Yes | Yes | Yes | |
| Sybase AS IQ | Database | Yes | Yes | Yes | Yes | |
| TeamCity | Application | Yes | Yes | Yes | No | |
| Teradata | Database | Yes | No | No | Depends on the driver | Data Transforms uses the Teradata JDBC Driver to connect to a Teradata Database. To use Teradata as a data source the Teradata Gateway for JDBC must be running, and this driver must be installed in your Data Transforms userlibs directory. You will find the driver here: https://downloads.teradata.com/download/connectivity/jdbc-driver.
|
| Teradata 17+ | Database | Yes | No | No | Depends on the driver | Data Transforms uses the Teradata JDBC Driver to connect to a Teradata Database. To use Teradata as a data source the Teradata Gateway for JDBC must be running, and this driver must be installed in your Data Transforms userlibs directory. You will find the driver here: https://downloads.teradata.com/download/connectivity/jdbc-driver.
|
| Tumblr | Application | Yes | Yes | Yes | No | |
| Application | Yes | Yes | Yes | No | ||
| Veeva CRM | Application | Yes | Yes | Yes | Yes | |
| Volusion | Application | Yes | Yes | Yes | No | |
| Wistia | Application | Yes | Yes | Yes | No | |
| WooCommerce | Application | Yes | No | No | Depends on the driver | Requires driver installation |
| WordPress | Application | Yes | Yes | Yes | No | |
| Workday | Application | Yes | No | No | Depends on the driver | Requires driver installation |
| Xero | Application | Yes | Yes | Yes | No | Requires driver installation |
| Yelp | Application | Yes | Yes | Yes | No | |
| Zendesk | Application | Yes | Yes | Yes | No | Requires driver installation |
| Zoho CRM | Application | Yes | Yes | Yes | No | |
| Zoom | Application | Yes | Yes | Yes | No |
Parent topic: Connections