Syntax error Different ODBC connection types under SAP HANA Smart data access SDA

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.

Updated on: 2020-06-22T09:20:45+05:30

700 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements