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.

v2023.07

The SQL statements and syntax used in the Extract SQL Statement panel must work with the SQL syntax supported by the ETL+ Source Driver used to connect to the associated Source Object.

Proper Usage of SQL in the Extract SQL Statement

 

SQL Syntax to Use with Various Source Drivers and Source Systems

Source Driver

SQL Syntax to Use

Source Driver

SQL Syntax to Use

Text File (.csv)

https://dataself.atlassian.net/wiki/spaces/DS/pages/2092498975

MS Excel

https://support.microsoft.com/en-us/office/date-and-time-functions-reference-fd1b5961-c1ae-4677-be58-074152f97b81

MS Access

 

MS SQL Server

Date and time data types and functions (Transact-SQL)

https://dataself.atlassian.net/wiki/spaces/DS/pages/1945174054 – this site

Sage 100 – ODBC Providex driver

Sage 100 PxPlus Reference Manual / Providex – Guide to finding SQL documentation in this reference manual.

  • – Link to the reference manual itself

  • – problems with dates

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.

Comments in SQL

-- 1 as [someTable] comments out 1 line /* comments out everything until closing delimiter more comments more comments */