With use of SAP HANA SPS06 Smart Data Access, you can only perform SELECT operation on virtual tables moved using new remote data source.

Following remote data sources are supported under SAP HANA SPS06 Smart Data Access −Sybase ASESAP Sybase IQ 15.4 ESD 3 and Version 16.0Apache Hadoop Version 2.3Teradata Database Version 13.0 or higher

Smart Data Access under Provisioning tab allows you to access and analyze the data stored in other database systems without replicating the data into HANA database. Data replication process is always time consuming and requires memory storage. Smart Data Access allows you to create virtual tables which are linked to remote system tables and data can be directly accessed in SAP HANA system with these virtual tables.In New Remote System wizard, you have to enter the source and you can see the list of Adapters which are supported under Smart Data Access.

CONFIGURATION FILE ‘property_orcl.ini’ It is only required for Adapter ODBC for Oracle data sources. Below shows SQL query to create an Oracle Remote Source 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 ... Read More

Select the system that you want to access as Remote Data Source and enter the authentication details. You have to enter the Connection Properties and Credentials for remote system.On right hand side, you have option to Test the Connection or you can also run to create the data source.

Below is the list of Adapters which are supported under Smart Data Access in SAP HANA −This comes while creating a new Remote Data Source.

In below table, you can see the list of remote data sources that are supported under SAP HANA Smart Data Access for SPS06 and SPS07 and the operations supported −SAP HANA VersionsSPS06SPS07 or higherSupported Data Sources under Smart Data AccessSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache Hadoop Version 2.3 Teradata Database Version 13.0 or higherSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache Hadoop Version 2.3 Teradata Database Version 13.0 or higher Oracle database 12c MSSQL version 11 for SQL Server 2012 IBM DB2Operations SupportedSelectSelect, Insert, Update and Delete

In SAP HANA SPS07, it has been extended to MSSQL server and Oracle database and write operation was permitted to perform on remote data sources.Following remote systems are allowed under Smart Data Access with Write operation in SAP HANA SPS07 −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12c

Smart Data Access under Provisioning tab allows you to access and analyze the data stored in other database systems without replicating the data into HANA database. Data replication process is always time consuming and requires memory storage. Smart Data Access allows you to create virtual tables which are linked to remote system tables and data can be directly accessed in SAP HANA system with these virtual tables.You can manipulate these virtual tables and run SQL statements- SELECT, INSERT and UPDATE and even Join is permissible between virtual and local tables. When a JOIN is applied on virtual tables, SAP HANA ... Read More