•  Introduction to ODBC Connector
  •  ODBC Connector assets
•  Connections for ODBC
  •  Prerequisites
    •  Configure the ODBC driver
    •  Prepare for Kerberos authentication
  •  Connect to ODBC
    •  Before you begin
    •  Connection details
    •  Related links
  •  Rules and guidelines for an ODBC connection
  •  Use the serverless runtime environment
•  Synchronization tasks with ODBC Connector
  •  ODBC sources in synchronization tasks
    •  Rules and guidelines for ODBC sources
  •  ODBC targets in synchronization tasks
  •  Rules and guidelines for data filters
•  Mappings and mapping tasks with ODBC Connector
  •  ODBC sources in mappings
    •  Key range partitioning
  •  ODBC targets in mappings
    •  Configuring an update override for the target
  •  ODBC lookups in mappings
  •  Calling a stored procedure
    •  Rules and guidelines for calling a stored procedure
  •  ODBC mapping example
  •  Rules and guidelines for ODBC objects
•  SQL ELT optimization
  •  SQL ELT optimization types
    •  Source SQL ELT optimization
    •  Full SQL ELT optimization
  •  Working with databases
  •  SQL ELT optimization transformations
  •  SQL ELT optimization functions
  •  SQL ELT optimization variables
  •  Configuring SQL ELT optimization
  •  Cross-schema SQL ELT optimization
  •  Cross-database SQL ELT optimization
  •  Verify the SQL ELT query in the session log
  •  Rules and guidelines for SQL ELT optimization
•  Data type reference
  •  ODBC data types and transformation data types
  •  Troubleshoot

Introduction to ODBC Connector

Troubleshoot

REL_ODBC_CONN

REL_ODBC_CONN-CONN_NAME

REL_ODBC_CONN-CONN_DESC

REL_ODBC_CONN-CONN_TYPE

REL_ODBC_CONN-AGENTGROUPID

REL_ODBC_CONN-ODBCSUBTYPE

REL_ODBC_CONN-AUTHENTICATIONTYPE

REL_ODBC_CONN-KERBEROSPROPERTIES

REL_ODBC_CONN-USERNAME

REL_ODBC_CONN-PASSWORD

REL_ODBC_CONN-DATABASE

REL_ODBC_CONN-SCHEMA

REL_ODBC_CONN-CODEPAGE

REL_ODBC_CONN-ODBCDRIVERMANAGER

REL_ODBC_CONN-CONNECTIONENVIRONMENTSQL