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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Using 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 MoreDifference between JSON and XML
Both JSON and XML are the most popular data transversal resources in programming world.Due to their various important characteristics and features both of these resources are widely used globally.On the basis of their features following are the important differences JSON and XMLSr. No.KeyJSONXML1AbbreviationJSON stands for JavaScript Object Notation.On other hand XML stands for Extensible Mark-up Language.2TypeJSON format is data interchangeable.On other hand XML format is Mark-up language.3Based onJSON is derived from JavaScript language from where it puts the feature to represents the data in a way of representing objects.On other hand XML is derived from SGML and uses tag structure ...
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 MoreHow many non-access modifiers are there in Java?
Java provides some other modifiers to provide the functionalities other than the visibility. These modifiers are called Non-Access ModifiersStatic The members which are declared as static are common to all instances of a class. Static members are class level members which are stored in the class memory.Final This modifier is used to restrict the further modification of a variable or a method or a class. The value of a variable which is declared as final can’t be modified once it gets a value. A final method can not be overridden in the subclass and you can not create a subclass ...
Read MoreUse of Role tab in SAP HANA system using HANA Studio
Roles tab is used to define the existing roles in HANA system and you can also create a new role in HANA system to add to user’s profile as per requirement.To add privilege to a new role, you have to click on “+” sign.
Read More