- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
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
Connecting to MSSQL, MaxDB using SAP HANA Smart Data Access
In SAP HANA SPS07, following data sources are supported under Smart data access −
- Sybase ASE
- SAP Sybase IQ
- Teradata 13.0 or higher
- Apache Hadoop 2.3
- MSSQL 11
- Oracle 12c
When you click on the Adapter name while creating a new remote data source, you can see a list of all supported databases.
You can also see in the above snapshot that all databases use the ODBC connection for a remote data sources.
- Related Articles
- Using Smart Data Access SDA in SAP HANA
- Limitations of using SAP HANA Smart Data Access
- System Authorization to use SAP HANA Smart Data Access
- Connection used in SAP HANA Smart Data Access
- Using SAP HANA SPS06 vs SPS07 with Smart Data Access SDA
- Object privilege required to use SAP HANA Smart Data Access
- Remote system allowed in SAP HANA Smart Data Access
- Adapters supported under Smart Data Access in SAP HANA
- Content of property_orcl.ini file in SAP HANA Smart Data Access
- Updated features in SAP HANA SPS07 for Smart Data Access
- Different ODBC connection types under SAP HANA Smart data access SDA
- SQL statement to add a table as Virtual table in SAP HANA Smart Data Access
- Connecting to SAP HANA using odbc_connect() on PHP
- Connecting to SAP HANA server on Cloud using PHP
- Performing different SAP logon check while connecting to HANA

Advertisements