skip to main content
Querying data stores with SQL : Supported SQL and Extensions
  

Try Now

Supported SQL and Extensions

Hybrid Data Pipeline 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 184. SQL support for each data store type
Data source
Supported SQL
Amazon Redshift
Hybrid Data Pipeline supports the SQL supported by Amazon Redshift. Refer to your Amazon Redshift documentation for details on SQL syntax.
DB2
Hybrid Data Pipeline supports the SQL supported by DB2. Refer to your DB2 documentation for details on SQL syntax.
Microsoft Dynamics CRM Online
Google Analytics
Greenplum
Hybrid Data Pipeline supports the SQL supported by Greenplum. Refer to your Greenplum documentation for details on SQL syntax.
Informix
Hybrid Data Pipeline supports the SQL supported by Informix. Refer to your Informix documentation for details on SQL syntax.
Microsoft SQL Server
Hybrid Data Pipeline supports the SQL used by Microsoft SQL Server. Refer to the Microsoft SQL Server documentation for details on the SQL syntax.
Oracle
Hybrid Data Pipeline supports the SQL supported by Oracle. Refer to your Oracle documentation for details on SQL syntax.
Oracle Marketing Cloud
Oracle Sales Cloud
Oracle Service Cloud
PostgreSQL
Hybrid Data Pipeline supports the SQL supported by PostgreSQL. Refer to your PostgreSQL documentation for details on SQL syntax.
Progress OpenEdge
Hybrid Data Pipeline 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
Refer to OpenEdge SQL Statements in the OpenEdge documentation for details.
Progress Rollbase
Salesforce-based data stores (Salesforce, Force.com, FinancialForce, ServiceMax, and Veeva CRM
SugarCRM
Sybase
Hybrid Data Pipeline supports the SQL supported by Sybase. Refer to your Sybase documentation for details on SQL syntax.

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

* Alter Session (EXT)
* Alter Table for Salesforce
* Create Table for Salesforce
* Delete
* Drop Table
* Explain Plan
* Insert
* Select
* Update
* SQL Expressions
* Subqueries