Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Java Memory Model
Java memory model is divided between Thread Stacks (One for each thread) and a heap area.Thread Stack: It is a thread specific memory area and contains local variables, methods call information etc. JVM stacks could be of fixed size or variable size. If computation in a thread exceeds its stack size limit then JVM throws StackOverflowError and exits.HeapIt contains all the objects created during application lifecycle. The heap is created when the virtual machine starts up. Garbage collector reclaims heap storage for objects and objects are never explicitly deallocated. The JVM is not using any automatic storage management system, and ...
Read MoreInformation required adding a new remote data source in SAP HANA SDA
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.
Read MoreCreating 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 ...
Read MoreUsing configuration file orcl.ini to add Oracle data source in SAP HANA
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
Read MoreRemote data sources supported under SAP HANA SPS06 SDA
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
Read MoreRemote data sources supported under SAP HANA SPS07 SDA
Following remote data sources are supported under SAP HANA SPS07 Smart Data Access −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12c
Read MoreSystem Authorization to use SAP HANA Smart Data Access
You need to add SAP HANA system authorization CREATE REMOTE SOURCE to create a remote source. If the remote source is not created with the SAP user but with a different database user instead, then this database user must assign the corresponding object authorizations to the SAP user (CREATE VIRTUAL TABLE and DROP).Navigate to user profile in Security tab and go to System privilege.
Read MoreUpdated features in SAP HANA SPS07 for Smart Data Access
Following are major changes are done in SAP HANA SPS07 for Smart Data Access −In later version SPS07, it supports SAP Oracle Database 12c, SAP Sybase Event Stream Processor (ESP) 5.1 SP04 and MSSQL server 2012 version 11 as data sources.In SPS07, it is possible to perform insert/update/deletion for remote databases with some limitations.In SPS06, it was not possible to use BLOB and CLOB data types with virtual tables. In SPS07, SDA now supports BLOBs and CLOBs as column data type of virtual table.SDA has a new feature which will help to check whether SDA installation is done successfully or ...
Read MoreSecurity folder in SAP HANA Studio
Last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that defines the system security policy and user management activities −SecurityUserRolesIn Security tab, you can also define Password Policy of HANA system.In Users tab, you can find list of all the existing users in SAP HANA system. You can also create a new User or a restricted user in SAP HANA.In Roles tab, you can see all the existing roles in SAP HANA system.
Read MoreSearching a user in SAP HANA system using HANA Studio
Users tab defines the list of existing users in HANA system and you can also create a new user, new restricted user or find a user in HANA system.In above pic, you can use Find User to filter a particular user from existing list.
Read More