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.

General Rule:
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.

ETL+ Extract, Transform and Load (ETL) window.
Source panel on the left, ETL SQL Statement panel to the right.

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:

 

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.

Comments

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

Related Pages