Preface
Introduction to ODBC Connector
- ODBC Connector assets
Connections for ODBC
Synchronization tasks with ODBC Connector
Mappings and mapping tasks with ODBC Connector
SQL ELT optimization
Data type reference
- ODBC data types and transformation data types
- Troubleshoot

ODBC Connector

Back Next

SQL ELT optimization variables

SQL ELT optimization
variables

When you use

SQL ELT optimization

, the Secure Agent converts the expression in the transformation by determining equivalent variables in the database. If there is no equivalent variable in the database, the Secure Agent processes the transformation logic.

The following table summarizes the

SQL ELT optimization

type for the available variables for supported databases:

Variables	Amazon Redshift	DB2	Google BigQuery	Microsoft Azure SQL Data Warehouse	Netezza	PostgreSQL	Snowflake	Teradata
SESSSTARTTIME()	-	-	Full	-	-	-	-	Full
SYSDATE()	-	Full	Source, Full	Source, Full	-	-	-	Full

SQL ELT optimization

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

ODBC Connector

ODBC Connector

SQL ELT optimization variables

SQL ELT optimization variables

SQL ELT optimization
variables