ETL+ Extract SQL Statement Panel

SQL statements in the Extract SQL Statement panel of ETL+ Extract, Transform and Load (ETL) window must work with the SQL syntax supported by the ETL+ source driver used to connect to the Source Object.

Proper Usage of SQL in the Extract SQL Statement

• Use T-SQL syntax for MS SQL Server data sources.

• For other source drivers refer to the source driver table below for the appropriate SQL variant. For instance, Use MySQL’s dialect of SQL for MySQL sources.

• Use ANSI Standard SQL if unsure. In case of issues, be sure to check the source’s documentation and syntax since most of them have variations from the regular ANSI Standard.

• Examples of SQL in Extract SQL Statement: Sage 100 ProvideX Examples for ETL+, Sage 100 Providex SQL Syntax

SQL Syntax to Use with Various Source Drivers and Source Systems

Miscellaneous SQL Syntax Tips

CONVERT vs. CAST

SELECT
    [column1],
    1  AS  [column2],
    CONVERT(varchar(30), GETDATE() ) AS [column3]
    
FROM
     [sourceTableName]

The CONVERT function is specific to T-SQL and is not part of the ANSI standard. Use CAST for non SQL Server data sources. ETL+ Extract SQL Statement: CONVERT()

Comments in SQL

-- 1 as [someTable]                   comments out 1 line

/*  comments out everything until closing delimiter
more comments
more comments */

• -- (Comment) (Transact-SQL) - SQL Server

• Slash Star (Block Comment) (Transact-SQL) - SQL Server
  

Related Pages

• https://dataself.atlassian.net/wiki/spaces/DS/pages/1928134673

• Sage 100 ProvideX Examples for ETL+

v2023.07 ✅