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- <adapter_name> can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.

In above statement, <connection_info_string> 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.

John SAP

Published on 05-Feb-2018 19:56:23

• Related Questions & Answers
• Creating new Remote Source using SDA in SAP HANA
• Creating virtual tables from remote source in SAP HANA
• Information required adding a new remote data source in SAP HANA SDA
• Using DSN name while using a remote source in SAP HANA
• Creating a Standard user in SAP HANA system using SQL
• Updating configuration property file in SAP HANA Remote source
• Creating a new table in SAP HANA
• Creating a Delivery unit in SAP HANA using HANA Studio
• Information required while creating a new Delivery Unit in SAP HANA
• Sort data in SQL using Dynamic SQL in SAP HANA
• Opening SQL editor using SAP HANA Studio
• Creating a Delivery unit in SAP HANA using HANA Application Lifecycle Management
• Creating a table using SAP HANA Studio UI option
• Creating a Restricted user in SAP HANA
• Converting BLOB to Char in SAP HANA using SQL