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
Content of property_orcl.ini file in SAP HANA Smart Data Access
When you create a new remote data source, SAP HANA Smart data access parse the respective property configuration file. With the use of config file- features, function mappings, data type mappings, and other properties will be linked together with the data source. This decides the communication between the SAP HANA and the data source.You can see part of the content of property_orcl.ini shown below −
Read MoreDifferent ODBC connection types under SAP HANA Smart data access SDA
You can check the following example to create a new remote source −CREATE REMOTE SOURCE TEST_11g ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral11g_lnx’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In above SQL statement, can be one of − ASEODBC, IQODBC,TDODBC, HIVEODBC,ODBC. Obviously, ASEODBC is for Sybase ASE as data source, IQODBC is for Sybase IQ, TDODBC is for Teradata Database, HIVEODBC is for Hadoop.
Read MoreConnecting to MSSQL, MaxDB using SAP HANA Smart Data Access
In SAP HANA SPS07, following data sources are supported under Smart data access −Sybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12cWhen 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.
Read MoreResetting a customized Perspective in SAP HANA Studio
Yes, if you customize a perspective, and you want to reset it, you can select Reset PerspectiveHere you have an option that allows you to perform following options on a Perspective −Customize PerspectiveSave PerspectiveReset PerspectiveClose PerspectiveClose All Perspective
Read MoreStarting SAP HANA Studio with immediate system logon
Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h Host name-n Instance number-u User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux OShdbstudio -h hana -n 03 –u HANAADMINhdbstudio -h hana -n 03 -u "&hana"Mac OSopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u HANAADMINopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u "&hana"Once you run above from command line, this will open HANA Studio. If you are prompted to enter password ...
Read MoreWhy we can't use arrow operator in gets and puts?
You can't read user input in an un-initialized pointer. Instead, have a variable of the struct data type and assign its address to pointer before accessing its inner elements by → operatorexample#include struct example{ char name[20]; }; main(){ struct example *ptr; struct example e; puts("enter name"); gets(e.name); ptr=&e; puts(ptr->name); }OutputTypical result of above codeenter name Disha You entered Disha
Read MoreExporting list of all SAP HANA systems in XML file
Yes, it is possible to export a list of your SAP HANA systems from the SAP HANA studio as an XML file and then it can be imported to another instance of the SAP HANA studio or use it as a system archive to which other users can link.This can be performed by following below steps −From the main menu, select File Export... .Expand the SAP HANA folder and choose Landscape.Choose Next.Select the systems you want to export and enter a target file location.Choose Finish
Read MoreSingle Sign-on configuration in SAP HANA system
SSO can be configured on below authentication methods −SAMLKerberosX.509 client certificates for HTTP access from HANA XS engineSAP Logon/Assertion tickets
Read MoreSearching a SAP HANA system in HANA Studio System view
When you are managing a large number of systems using HANA Studio, this can be used to find a specific system more quickly.To use find system option, the following steps should be performed −From the Systems view toolbar, choose the Find System (Find System) button.2. Enter a search string −You can also use “*” or “?” wildcards.It will display matching systemsSelect the system you were searching for.You can select several systems in the search results by pressing the CTRL key while selecting. You can use this, for example, to mark duplicate systems.Choose whether you want to open the selected system ...
Read MoreManaging password policy in SAP HANA system
The last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that define the system security policy and user management activities −SecurityUserRolesSecurity tab is used to manage Password Policy in HANA system −
Read More