Skip to main content

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

SQL
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

CODE
-- 1 as [someTable]                   comments out 1 line

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

Related Pages


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.