When a remote source is added, you can see all the existing tables under that data source in HANA Studio. Next is to create virtual table mapping to data in the remote data sources in SAP HANA Studio. This can be done using GUI option.To add a table as a ... Read More

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 ... Read More

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 ... Read More

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 ... Read More

The remote system access communication is based on ODBC connection, and ODBC drivers for remote data sources − ASEODBC, IQODBC, and TDODBC. To create a remote data source, Right-click on Remote Sources → New Remote Source

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

All the database objects in SAP HANA system are maintained in the CATALOG folder in HANA Studio. Following are the key capabilities of SAP HANA database system −You can use a high-performance in-memory database for processing complex transactions and analytics. You can manage large database volumes in multitenant database containers.Using ... Read More

Variables are used as an explicit SQL filter directive for view consumers to filter the view data, based on attribute column values specified in variable UI prompt of a BI Client.To define a variable, you need to navigate to Semantics in a view → Go to Parameters/Variables and click on ... Read More

When you enter the Attribute name, Type, and Subtype and click on Finish, it will open three work panesScenario pane that has Data Foundation and Semantic Layer.Details Pane shows attribute of all tables added to Data Foundation and joining them.Output pane where we can add attributes from Detail pane to ... Read More

To create a new Attribute view, select the Package name under which you want to create an Attribute View. Right Click on Package → Go to New → Attribute ViewClick on Attribute View, and this will open a new Window. You need to pass Attribute View name and description. From ... Read More