skip to main content
Supported SQL and Extensions
 

Try DataDirect Cloud Now

Supported SQL and Extensions

DataDirect Cloud supports the SQL statements and extensions described in this section.
The SQL statements supported are similar in many cases for any data store. However, in some cases, the data store has different levels of SQL support.
Table 44. SQL support for each data store type
Data source
Supported SQL
Amazon Redshift
DataDirect Cloud supports the SQL supported by Amazon Redshift. Refer to your Amazon Redshift documentation for details on SQL syntax.
DB2
DataDirect Cloud supports the SQL supported by DB2. Refer to your DB2 documentation for details on SQL syntax.
Microsoft Dynamics CRM Online
Google Analytics
Greenplum
DataDirect Cloud supports the SQL supported by Greenplum. Refer to your Greenplum documentation for details on SQL syntax.
Informix
DataDirect Cloud supports the SQL supported by Informix. Refer to your Informix documentation for details on SQL syntax.
Microsoft SQL Server
DataDirect Cloud supports the SQL used by Microsoft SQL Server. Refer to the Microsoft SQL Server documentation for details on the SQL syntax.
Oracle
DataDirect Cloud supports the SQL supported by Oracle. Refer to your Oracle documentation for details on SQL syntax.
Oracle Marketing Cloud
Oracle Service Cloud
PostgreSQL
DataDirect Cloud supports the SQL supported by PostgreSQL. Refer to your PostgreSQL documentation for details on SQL syntax.
Progress OpenEdge
DataDirect Cloud supports the SQL supported by the Progress OpenEdge Database, with the following exceptions:
*Stored Procedure Output Parameters
*Multiple Results
*COMMIT, ROLLBACK, and SET TRANSACTION ISOLATION LEVEL1
Follow this link to see the supported SQL syntax for OpenEdge 11.4: https://documentation.progress.com/output/OpenEdge114/openedge114/#page/dmsrf/OpenEdge.01.html.
Progress Rollbase
Oracle Eloqua, HubSpot, and Marketo
Salesforce-based data sources, including Force.com, FinancialForce, ServiceMax, and Veeva CRM
 
SugarCRM
 
Sybase
DataDirect Cloud supports the SQL supported by Sybase. Refer to your Sybase documentation for details on SQL syntax.

1 When using DataDirect Cloud to access OpenEdge data, you (or your applications) do not explicitly control transactions. Instead, all SQL statements are auto-committed.

* Oracle Eloqua, HubSpot, and Marketo
* Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase