ETL+ ETL Extract SQL Statement Panel
Using SQL with ETL+. Refers to SQL statements in the ETL SQL Statement panel of ETL+ Extract, Transform and Load (ETL) window.
The SQL syntax used in the ETL SQL Statement panel depends on the SQL used to connect to the Source Object.
The SQL statements and syntax used in the ETL SQL Statement panel must work with the SQL syntax used to connect to the associated Source Object.
All columns must be columns from the source tables named in the FROM clause.
The SQL syntax used in the ETL SQL Statement panel is the dialect of SQL used by the Source Object. For instance, a source object that connects with MySQL will run MySQL’s dialect of SQL in the ETL SQL Statement panel.
ANSI Standard SQL
ANSI Standard SQL is (mostly) %100 Supported by ETL+ with some known exceptions.
Exceptions to ANSI Standard SQL Support:
Providex Joins See Sage 100 Providex SQL Syntax
SQL Syntax Supported
Assign a Literal Value to a Column
SELECT [column1], 1 AS [column2], CONVERT(varchar(30), GETDATE() ) AS [column3] FROM [sourceTableName]
Assigns the value 1 to the column named “
column2" in the associated target table.
-- 1 as [someTable] comments out 1 line /* comments out everything until closing delimiter more comments more comments */