skip to main content
Parameters for all supported Data Store types
 

Try DataDirect Cloud Now

Parameters for all supported Data Store types

You define the information that DataDirect Cloud needs to connect to the data store in a Data Source definition. Tabs and fields of the Data Source definition allow you to configure behavior that can improve performance and enable OData access. Follow the links below to find descriptions of the parameters available for each supported data store. The parameters for cloud and on-premise are often similar for the same type of data store. However, since the environments often have different requirements for security and other connection features, the topics describe cloud and on-premise connection parameters separately.
Table 2. Connection Parameters for each data store type
Data source
Supported Connection Parameters
Amazon Redshift
Apache Hadoop Hive
DB2
Google Analytics
Greenplum
HubSpot
Informix
Marketo
Microsoft Dynamics CRM
Microsoft SQL Server
MySQL
Oracle
Oracle Eloqua
Note: The Eloqua data store has been replaced by the Oracle Marketing Cloud data store. For compatibility purposes, the Eloqua data store remains available for access in this release. However, the Eloqua data store will be deprecated in a future release.
Oracle Marketing Cloud
Oracle Service Cloud
PostgreSQL
Progress OpenEdge
Progress Rollbase
Salesforce-based data sources
SugarCRM
Sybase ASE
* Amazon Redshift connection parameters
* Apache Hadoop Hive connection parameters
* DB2 connection parameters
* Google Analytics connection parameters
* Greenplum connection parameters
* HubSpot connection parameters (Beta)
* Informix connection parameters
* Marketo connection parameters
* Microsoft Dynamics CRM connection parameters
* Microsoft SQL Server connection parameters
* MySQL connection parameters
* Oracle connection parameters
* Oracle Eloqua connection parameters
* Oracle Marketing Cloud connection parameters
* Oracle Service Cloud connection parameters
* PostgreSQL connection parameters
* Progress OpenEdge connection parameters
* Progress Rollbase connection parameters
* Salesforce (and related data store) connection parameters
* SugarCRM connection parameters
* Sybase ASE connection parameters
* About mapping options