Creating a new remote source in SAP HANA using SQL

You can also create a remote source using SQL statement as below −

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

In this SQL statement- can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.

In above statement, is used to specify the connection information for data source where you need to mention the DSN name for your ODBC remote source system. You have to create a System DSN/User DSN to access the data source using ODBC connection.

To open SQL console, right click on Remote Source → Open SQL Console.