- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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
- Creating a new table in SAP HANA
- Updating configuration property file in SAP HANA Remote source
- 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
- Creating a Delivery unit in SAP HANA using HANA Application Lifecycle Management
- Opening SQL editor using SAP HANA Studio
- Creating a table using SAP HANA Studio UI option
- Loading an individual column in SAP HANA using SQL
- Converting BLOB to Char in SAP HANA using SQL

Advertisements