Supported SQL and Extensions

Table 192. SQL support for each data store type
Data store	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.
Autonomous REST Connector	Alter Session (EXT) Select
DB2	Hybrid Data Pipeline supports the SQL supported by DB2. Refer to your DB2 documentation for details on SQL syntax.
Microsoft Dynamics CRM Online	Alter Session (EXT) Delete Explain Plan Insert Select Update
Google Analytics	Alter Session (EXT) Explain Plan Select
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 (Eloqua)	Alter Session (EXT) Delete Explain Plan Insert Select Update
Oracle Sales Cloud	Alter Session (EXT) Explain Plan Select
Oracle Service Cloud	Alter Session (EXT) Delete Explain Plan Insert Select Update
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 LEVEL¹ Refer to OpenEdge SQL Statements in the OpenEdge documentation for details.
Progress Rollbase	Alter Session (EXT) Delete Explain Plan Insert Select Update
Salesforce-based data stores (Salesforce, Force.com, FinancialForce, ServiceMax, and Veeva CRM	Alter Session (EXT) Alter Table for Salesforce Create Table for Salesforce Delete Drop Table for Salesforce Explain Plan Insert Select Update
SugarCRM	Alter Session (EXT) Explain Plan Select
Sybase	Hybrid Data Pipeline supports the SQL supported by Sybase. Refer to your Sybase documentation for details on SQL syntax.

¹ 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.