Different ODBC connection types under SAP HANA Smart data access SDA

You can check the following example to create a new remote source −

CREATE REMOTE SOURCE TEST_11g
ADAPTER “odbc”
CONFIGURATION FILE ‘property_orcl.ini’
CONFIGURATION ‘DSN=oral11g_lnx’
WITH CREDENTIAL TYPE ‘PASSWORD’
USING ‘user=username;password=password′;

In above SQL statement, <adapter_name> can be one of − ASEODBC, IQODBC,TDODBC, HIVEODBC,ODBC. Obviously, ASEODBC is for Sybase ASE as data source, IQODBC is for Sybase IQ, TDODBC is for Teradata Database, HIVEODBC is for Hadoop.

Anil SAP Gupta

Updated on: 22-Jun-2020

441 Views

Kickstart Your Career

Get certified by completing the course

Get Started