Hi Everyone,
We all have read awesome blogs from petr.solberg- The SAP Hana Reference for NetWeaver Basis Administrators and bill.ramos - The ultimate set of HANA related links from SAP. These blogs are very helpful to everyone of us.
What i observed from these blogs was "As Andy's blog title said its mainly for Basis Administrators and has very huge list of SAP Notes - some of these Notes are useful even for HANA Developers but these notes are very hard to find while Bill's blog had huge list of links that has been categorized very well but it has not been updated in a while due to which few topics are missing lot of information and many new topics are not present there."
While working with HANA and its new functionalities, i had to look for information and it used to take a lot of time to get the correct information, so i tried to create a list of SAP Notes and a list of links to the documents that i have followed and want to follow so that i don't have to go through the pain of searching this information again.
The above two blogs helped me a lot in getting this blog ready - got few SAP Notes and links from these, so i am very thankful to both Andy and Bill for their efforts.
I hope this blog will be helpful to everyone.
Last time I also wrote a blog Want to learn SAP HANA?Where to Start?Certification? but was not fully satisfied with it and thought something was missing, tried editing it but it would have made the blog too long.
So I thought of creating a new blog and adding everything in one blog but this blog became very long so i have decided to divide it into two parts.
This part of blog covers all the topics related to HANA.
Second part covers advanced topics related to HANA - HANA Reference for Developers - Links and SAP Notes(Part-2)
Deleted all obsolete SAPHANA website links and added new ones
HANA SPS8 Guides and videos are now available:
Check the below document to know What's New in HANA with links to many other documents and videos on new features:
Blog: What’s New in SAP HANA SPS 08 | SAP HANA
Before starting the blog I would like to post links from where we can download Study Materials for HANA:
Download all the HANA Guides updated to SPS7
http://help.sap.com/hana_appliance/
Technical Documents - SAP HANA - This contains all the documents related to Architecture, Modeling, Data Provisioning and XS.
http://www.saphana.com/docs/DOC-2171
OpenSAP HANA Learning Materials
http://scn.sap.com/community/developer-center/hana/blog/2013/08/14/opensap-hana-learning-materials
In-Memory Data Management Course - starting from August 26
https://openhpi.de/course/imdb2013
SAP HANA ELEARNING CATALOG
http://www.sdn.sap.com/irj/scn/elearn?rid=/webcontent/uuid/e04da73b-3a72-2e10-969a-b032c46e7509
SAP HANA Videos:
http://www.saphana.com/community/implement/hana-academy
Contents of this blog:
1. Introduction to HANA
What is SAP HANA?
http://www.saphana.com/docs/DOC-2272
Whitepaper - Technical Overview SAP HANA
http://www.saphana.com/docs/DOC-1506
SAP HANA™ for Next-Generation Business Applications and Real-Time Analytics
http://www.saphana.com/docs/DOC-1507
SAP HANA Data Sheet
http://www.saphana.com/docs/DOC-3894
OLAP & OLTP in a single database - SAP Real Time Data Platform
http://www.saphana.com/docs/DOC-2939
Efficient Transaction Processing in SAP HANA Database
http://www.saphana.com/docs/DOC-2119
The Real Reason for HANA
http://www.saphana.com/community/blogs/blog/2013/07/27/the-real-reason-for-hana
The HANA Difference – SAP HANA’s Defining Capabilities
The Top 10 SAP HANA Myths Spread by Other Vendors
Product Road Map - SAP HANA
http://www.saphana.com/docs/DOC-1636
SAP HANA Hardware Specifications & Product Availability Matrix (PAM)
http://www.saphana.com/docs/DOC-2382
Solution Brief - SAP HANA – An In-Memory Data Platform for Real-Time Business
http://www.saphana.com/docs/DOC-2857
How do I get started with HANA
http://www.saphana.com/docs/DOC-2111
System Ordering - SAP HANA
http://www.saphana.com/docs/DOC-1213
SAP HANA Do's and Don'ts
http://www.saphana.com/docs/DOC-1151
HANA Use Cases:
http://www.saphana.com/community/implement/use-cases
Customer & Startups Stories on SAP HANA
http://www.saphana.com/community/learn/customer-stories
2. HANA Studio - Look and Feel
Overview - SAP HANA Studio
http://www.saphana.com/docs/DOC-1217
SAP HANA Database - Studio Installation and Update Guide
http://www.saphana.com/docs/DOC-1808
Installing Hana Studio and Client
http://www.saphana.com/docs/DOC-2275
Download hana studio and client
https://hanadeveditionsapicl.hana.ondemand.com/hanadevedition/
How to add system in Hana Studio
http://scn.sap.com/docs/DOC-25922
3. HANA Architecture
Architecture - SAP HANA
http://www.saphana.com/docs/DOC-1219
HANA Architecture Bluebook
http://www.saphana.com/docs/DOC-3191
Massively Parallel Processing on HANA
http://www.saphana.com/community/blogs/blog/2013/04/22/massively-parallel-processing-on-hana
Introduction to High Availability for SAP HANA
http://www.saphana.com/docs/DOC-2775
SAP HANA - High-Availability Features - Webinar Replay
http://scn.sap.com/docs/DOC-40662
Backup and Recovery - SAP HANA
http://www.saphana.com/docs/DOC-1220
http://www.saphana.com/docs/DOC-3131
SAP Notes related to Backup and Recovery:
1844468 - Homogeneous system copy on SAP HANA
1703435 - Creating a copy of a running instance using snapshots
1642148 - FAQ: SAP HANA Database Backup & Recovery
1852242 - Confusion about file-based backup catalog naming
1880503 - SAP HANA studio compatibility error for recovery
1835075 - Analyze backup and recovery performance issues
1820553 - Incompatibility of data backup and DB configuration
1820529 - Unsuitable network file systems for backup and recovery
1781540 - Recovery of SAP HANA database through the Admin Console does not work
1817703 - Archiving file system-based backups
1730932 - Using backup tools with Backint for HANA
Backup/recovery API for the SAP HANA database (Backint for SAP HANA (HANA-BRINT 1.1))
http://scn.sap.com/docs/DOC-34483
"Backint for SAP HANA" Certification Available Now
1730928 - Using external software in a HANA appliance
1716418 - Data backup hangs when writing to NFS server
1705945 - Determining required restoration files
1842096 - HANA Backup & Restore Performance
1651055 - Scheduling SAP HANA Database Backups in Linux
1812057 - Reconstruction of the backup catalog with hdbbackupdiag
1816483 - Restore when log backups are missing
4. HANA Administration
SAP HANA Administration Guide
http://www.saphana.com/docs/DOC-1073
SAP HANA - Administration & Monitoring - What´s new with SPS6
http://www.saphana.com/docs/DOC-1215
Overall Installation Guide - SAP HANA 1.0
http://www.saphana.com/docs/DOC-1040
Server Installation and Update Guide - SAP In-Memory Database
http://www.saphana.com/docs/DOC-1031
Manual Update Guide - SAP HANA 1.0
http://www.saphana.com/docs/DOC-1051
Update & Patching - SAP HANA
http://www.saphana.com/docs/DOC-1212
Readiness Guide - SAP HANA
http://www.saphana.com/docs/DOC-1810
Introduction - SAP HANA in Data Centers
http://www.saphana.com/docs/DOC-2010
Scalability - SAP HANA
http://www.saphana.com/docs/DOC-2022
Upgrading SAP HANA with SUM for HANA - Webinar Replay
http://scn.sap.com/docs/DOC-41434
Whitepaper - SAP HANA Performance
http://www.saphana.com/docs/DOC-1647
SAP HANA Memory Usage Explained
http://www.saphana.com/docs/DOC-2299
For real: Performance of the same SQL comparing Hana and another RDBMS
http://www.saphana.com/docs/DOC-2321
Performance Test Report - SAP HANA
http://www.saphana.com/docs/DOC-1755
Performance in SAP HANA Databases - Webinar Presentation
http://scn.sap.com/docs/DOC-43543
Performance in SAP HANA Databases - Webinar Replay
http://scn.sap.com/docs/DOC-43713
Testing HANA
Show me the timelines, baby!:
http://scn.sap.com/community/hana-in-memory/blog/2012/12/20/show-me-the-timelines-baby
SAP Notes related to HANA Administration
1514967 - SAP HANA: Central Note
1698281 - Assess the memory consumption of a SAP HANA System
1768949 - HANA Overall Health Statistics
1787489 - SAP HANA Database: Performance Trace
1786918 - SAP HANA Database: Provide Information with hdbcons
1800175 - Performance Improvement with hybrid database
1749467 - Copying SAP HANA From a Multiple- to a Single-Host System
1789828 - HANA Studio Activation errors
1800631 - SAP HANA: Limitations for HANA-based Analytics
1809199 - SAP HANA DB: Debugging user authorization errors
1786384 - Missing secondary indexes for HANA DB
1840954 - Alerts related to HANA memory consumption
1849775 - SAP HANA XS ENGINE poor database access performance
1835200 - Stand-by Statistics Server and XS Engine do not start when Master server goes down
1780484 - HANA upgrade fails with 'ERR: Cannot open install registry'
1803291 - SAP HANA update guides
1894285 - SAP HANA appliance: Revision 62 of SAP HANA database
1891354 - SAP HANA DB: Duplicate entries in column store table
1877480 - Incorrect CODE_SIZE
1848976 - SAP HANA Platform SPS 06 Release Note
1779803 - Current Restrictions: XS / Development Perspective
1514966 - SAP HANA 1.0: Sizing SAP In-Memory Database
1545815 - SAP Release Note for SUM for SAP HANA 1.0
1867324 - SAP HANA Database: Deactivating the Script Server
1603671 - SAP HANA 1.0: Software Components and Software Download
1592925 - SAP HANA Studio service connection
1627904 - SAP HANA Information Composer: Central Note
1641210 - SAP HANA datebase: Checking for suspected problems
1598623 - SAP HANA appliance software: Central Security Note
1870605 - Privilege escalation in SAP HANA
1837331 - HOWTO HANA DB SSO Kerberos/ Active Directory
1813724 - HANA SSO/Kerberos: create keytab and validate conf
1767687 - HANA issues with Kerberos SSO, error while parsing protocol
1666976 - uniqueChecker usage description - The uniqueChecker is used to do a consistency check on column store database tables. It can identify problems related to primary keys and unique constraints.
5. Data Provisioning
Data Provisioning - SAP HANA
http://www.saphana.com/docs/DOC-1210
Data Provisioning Options - Introduction and news
http://www.saphana.com/docs/DOC-2859
Best Practices for SAP HANA Data Loads
http://www.saphana.com/community/blogs/blog/2013/04/07/best-practices-for-sap-hana-data-loads
Semantic Analysis with SAP HANA
http://www.saphana.com/docs/DOC-3326
Case Study how to collect Social Media Data with SAP HANA
http://www.saphana.com/docs/DOC-3871
Unstructured Data
http://www.saphana.com/docs/DOC-2118
SAP Notes related to Data Replication
1772131 - Data Replication into HANA: improvements
1791620 - Data Replication into SAP HANA: usability corrections
1797074 - HANA Replication: Incorrect check of navigation attributes
1771582 - Lock issues in data replication
Loading data from flat file into SAP HANA
http://scn.sap.com/docs/DOC-27960
Importing a Flat File into SAP HANA
http://www.saphana.com/docs/DOC-2362
Loading data from CSV file
http://www.saphana.com/docs/DOC-2191
Modeler Unplugged Episode 4: Flat file upload via HANA Modeler
Overview Presentation - SAP LT Replication Server for SAP HANA
http://www.saphana.com/docs/DOC-1811
SLT
http://www.saphana.com/docs/DOC-2116
http://www.saphana.com/docs/DOC-2926
SLT & Excel
Video: http://www.saphana.com/community/implement/hana-academy#working-with-data-hana-studio
Starter Blog for SAP LT Replication Server
SLT for non-SAP - Considerations
http://scn.sap.com/docs/DOC-41786
How SLT is mapping data types
http://scn.sap.com/community/replication-server/blog/2013/05/14/how-slt-is-mapping-data-types
SLT Community
http://scn.sap.com/community/replication-server
SAP Notes related to SLT:
List of all SLT Notes
http://scn.sap.com/community/replication-server/blog/2013/02/27/list-of-all-slt-notes
1605140 - SAP HANA 1.0: Central Note - SAP LT Replication Server
1882433 - Installation/Upgrade SLT - DMIS 2011 SP5
1603754 - Correction for SLT Replicator for HANA 1.0
1652039 - Archiving: Replicating archived data in SAP HANA
1880224 - Replication of archived data: TABLE_INVALID_INDEX
1663138 - HANA data replication fails due to incorrect DB triggers
1645517 - HANA Replication: Trigger creation fails, if triggers exist
1646371 - HANA replication fails for sender systems with release 4.6C
1733714 - Guide for HANA Advanced Replication Settings
1769956 - HANA LTR: Avoid locks in DB2 during data replication
1768103 - HANA LTR: NON SAP - Timestamp mapping and SYBASE replication
1749824 - Treatment of SLT triggers during transpor
1778880 - SAP LT Replication Server: Using DB6 as non-SAP source
1768805 - SAP LT Replication Server: Collective Note - non-SAP Sources
1801462 - 'Errors in setting connections' when saving an SLT configuration
1800901 - SLT: 500 Connection timed out after logging into WebDynpro via transaction LTR
1771460 - SAP LT Replication Server: Using ORACLE as non-SAP source - checkout attached pdf
1778971 - SAP LT Replication Server: Using MS SQL as non-SAP source - checkout attached pdf
1778975 - SAP LT Replication Server: Using DB2 as non-SAP source - checkout attached pdf
1778880 - SAP LT Replication Server: Using DB6 as non-SAP source - checkout attached pdf
1828028 - Creating a new configuration in transaction LTR fails with 'Error ocurred on when opening db connection'
1818180 - Unable to find certain tables in the Data Provisioning tool
1837877 - Tables are not getting replicated from SLT server to HANA
1791921 - Conversion of pool tables to transp.during migr. to SAP HANA
Installation Guide - SAP BusinessObjects Data Services XI 4.0
http://www.saphana.com/docs/DOC-1038
How To load SAP Business Suite data into SAP HANA using SAP BusinessObjects Data Services
http://www.saphana.com/docs/DOC-1354
How to invoke SAP HANA stored procedures from Data Services
http://www.saphana.com/docs/DOC-2289
SAP HANA: Data provisioning using BI 4.0 Data services
http://scn.sap.com/docs/DOC-26311
Optimizing HANA with Data Services and Information Steward
Data Services 4.2 What's New Overview
http://scn.sap.com/community/data-services/blog/2013/06/02/data-services-42-whats-new-overview
HOWTO - Create a SAP BusinessObjects Data Services Repository on SAP HANA
http://scn.sap.com/docs/DOC-42792
SAP Notes related to Data Services
1792597 - Is SAP HANA available as a database repository for SAP Data Services 4.0
1811961 - Connection to HANA test failed in Data Services Workbench
1817513 - SAP Business Objects Data Services crashes without error when HANA Data Store is accessed
SAP HANA-Direct Extractor Connection (DXC)-Overview
http://www.saphana.com/docs/DOC-3779
Using the Direct Extractor Connection (DXC)
http://www.saphana.com/docs/DOC-2420
SAP Notes related to DXC:
1583403 - Direct extractor connection to SAP HANA
1670518 - SAP HANA Direct Extractor Connection
1688750 - DataSource: Reading a property in the source system
1701750 - DataSource: Secondary Index on the PSA
1677278 - DataSource: Changing the Key Definition
1710236 - SAP HANA DXC: DataSource Restrictions
1714852 - Troubleshooting SAP HANA DXC issues
1665602 - Setup & Config: SAP HANA Direct Extractor Connection (DXC)
1583403 - Direct extractor connection to SAP HANA
1665553 - Handling issues with IMDSO activation - SAP HANA DXC
1714933 - DXC: partitioning In-Memory DSO tables
6. Modeling
SAP HANA Modeling
http://www.saphana.com/docs/DOC-3213
Modeling Basics
https://saptechedhandson.sap.com/demo.sap.com~vi~web/content/EIM161.pdf
Modeling Fundamentals
http://events.asug.com/2012AC/4211_SAP_HANA_Data_Modeling_Fundamentals_and_New_Functionality.pdf
Modeling Features - SAP HANA
http://www.saphana.com/docs/DOC-1216
SAP HANA Modeling Guide
http://www.saphana.com/docs/DOC-1074
Analytic Views - What they are and how are they used?
http://www.saphana.com/docs/DOC-1256
Implementing Calculation Views - SAP HANA Modeling
http://www.saphana.com/docs/DOC-1922
SAP HANA - Modeling Content Migration
Calc Enginer Introduction
https://websmp202.sap-ag.de/~sapidb/012003146900000463252012E/HanaCalcEngineIntroduction.pdf
HANA Calculation Engine Instantiation Process
https://service.sap.com/~sapidb/012003146900000488272012E/HanaCEInstantiationProcess.pdf
Cardinality Optimization of join by CalcEngine
https://websmp210.sap-ag.de/~sapidb/012003146900000214282013E/HANACECardinalityOptimization.pdf
Implementing Calculation Views - SAP HANA Modeling
http://www.saphana.com/docs/DOC-1922
Building Advanced Data Models with SAP HANA - Webinar Presentation
http://scn.sap.com/docs/DOC-13267
Best Practices for optimal data models in SAP HANA and analytics in SAP BusinessObjects 4.0
Best Modeling practices:
http://events.asug.com/2012AC/4219_SAP_HANA_Data_Modeling_Best_Practices_.pdf
ABC CLASSIFICATION & C4.5 DECISION TREE
http://www.saphana.com/docs/DOC-1283
SAP Notes related to Modeling:
1718854 - SAP HANA Modeler: Error when opening Analytic privilege
1791464 - Select count(*) on graphical Calculation Views
1764658 - HANA Calculation Engine Instantiation Process
1811804 - Deadlock caused by Queries on Olap Views
1825549 - Performance degradation for query on CalcView
1840663 - Workaround for Cardinality Optimization of CalcEngine
1765642 - SAP HANA Modeler - Activating Objects
1710712 - How to export and import Hana Models for support purposes
1639568 - SAP HANA studio displays system status as yellow
1822186 - Cannot use "SELECT DISTINCT" in an attribute view
1876879 - Calculated Attribute of Calculaton View missing (rev 60)
1852300 - SAP HANA: Filters on SQL CalcViews are not being pushed down
1648962 - SAP HANA: Prerequisites for Data Modeling
1739779 - Activation of procedures might fail
1753944 - Revalidation of procedures/views using R script
7. Reporting
Connecting to SAP HANA with Microsoft Excel 2007 PivotTables and ODBO
Learn Excel Functions:
Official Product Tutorials – BI for SAP HANA:
http://scn.sap.com/docs/DOC-34403
Best Practices - Creating a universe on SAP HANA
http://www.saphana.com/docs/DOC-1682
Best Practices - Creating a universe on SAP HANA
http://www.saphana.com/docs/DOC-1682
How to Realize Cross System Reporting Using SAP HANA Live Content
http://www.saphana.com/docs/DOC-3885
Setting up end to end security for SAP HANA and BI4.0
http://www.saphana.com/docs/DOC-2416
What's New Guide - SAP BusinessObjects Analysis, edition for Microsoft Office 1.3 SP6
http://www.saphana.com/docs/DOC-1684
What's New Guide - SAP BusinessObjects Business Intelligence platform 4.1
http://www.saphana.com/docs/DOC-1685
FAQ for IT - SAP BusinessObjects Explorer
http://www.saphana.com/docs/DOC-1756
Official Product Tutorials – SAP BI Suite
http://scn.sap.com/docs/DOC-7725
Connecting SAP BusinessObjects BI4.0 client tools on SAP HANA
SAP Notes related to Business Objects:
245178 - krb5.ini rules of configuration with Business Objects java AD
1811398 - How to setup BI components to login to hana via AD kerberos SSO
1779252 - How do you resolve BI 4.0 Analysis for OLAP error message "Failed to get connections for connection [...] using session locale [English]" connecting to SAP HANA?
1714374 - The JDBC connection from Crystal Reports to SAP HANA database is timed out
1714328 - The JDBC connection from Crystal Reports to SAP HANA database is refused
1714320 - The JDBC connection from Crystal Reports to SAP HANA database cannot be made successfully
SAP Lumira
http://www.saphana.com/community/learn/solutions/sap-lumira/sap-lumira-desktop
SAP Lumira Cloud FAQ
http://scn.sap.com/docs/DOC-41354
Ofiicial Product Tutorials: SAP Lumira :
http://scn.sap.com/docs/DOC-26507
SAP Notes related to Lumira
1823771 - SAP Visual Intelligence - Unable to connect to HANA due to insufficient rights
1798899 - SAP Visual Intelligence: Are HANA Variables or Input Parameters supported?
8. Security & Authorization
SAP HANA Security: An Overview
http://www.saphana.com/docs/DOC-3751
SAP HANA Security Overview
SAP HANA Security Guide
http://www.saphana.com/docs/DOC-1067
SAP HANA - Security Concept and Data Architecture
http://scn.sap.com/blogs/krojzl/2011/10/24/sap-hana--security-concept-and-data-architecture-part-1
http://scn.sap.com/blogs/krojzl/2011/10/24/sap-hana--security-concept-and-data-architecture-part-2
9. HANA Native Development
Introducing SAP HANA Extended Application Services (XS)
http://www.saphana.com/docs/DOC-3789
XS engine - SAP HANA native development
http://www.saphana.com/docs/DOC-3212
HANA Native Development
http://www.saphana.com/docs/DOC-3017
SAP HANA Extended Application Services
10. New Features in HANA SPS6
What's New in HANA SPS6
http://help.sap.com/hana/Whats_New_SAP_HANA_Platform_Release_Notes_en.pdf
New in SPS6:
http://www.saphana.com/docs/DOC-3790
New SQLScript Features in SAP HANA 1.0 SP6
http://scn.sap.com/docs/DOC-44062
SAP HANA SPS6 - Various New Developer Features
Core Data Services
http://www.saphana.com/docs/DOC-3773
Preview the SAP HANA IDE Lite on SAP HANA One
http://www.saphana.com/community/blogs/blog/2013/05/23/preview-the-sap-hana-ide-lite-on-sap-hana-one
Lifecycle Management - Introduction
http://www.saphana.com/docs/DOC-3796
How to upgrade to SAP HANA Lifecycle Management
http://scn.sap.com/people/man-ted.chan/blog/2013/07/05/sap-hana-lifecycle-management
SAP HANA Lifecycle Manager - how to launch, start and install.
SAP Notes related to HLM
1836498 - SAP HANA Lifecycle Manager
Spatial Processing powered by SAP HANA
http://www.saphana.com/community/learn/solutions/spatial-processing/
Spatial Processing with HANA FAQ
http://www.saphana.com/docs/DOC-3804
Spatial Processing
http://www36.sap.com/corporate-en/news.epx?PressID=20900
SAP Notes related to Spatial Processing
1872108 - Current Restrictions:SAP HANA Spatial processing
SAP HANA smart data access enables remote data to be accessed as if they are local tables in SAP HANA, without copying the data into SAP HANA.
Smart Data Access (Data Virtualization) with SAP HANA
HANA Curious - SPS 06 Deployment: Smart Data Access, XS Workbench and more
SAP Notes related to Smart Data Access
1868209 - SAP HANA Smart Data Access: Central Note
1868702 - SAP HANA Smart Data Access: Remote Datasource Drivers
1879294 - SAP HANA smart data access SP1
1872652 - SAP HANA Smart Data Access: Statistics for Virtual Tables
SAP River:
Introducing RDL – The River Definition Language:
http://www.saphana.com/community/blogs/blog/2012/11/15/introducing-rdl-the-river-definition-language
Introducing SAP River!!:
http://scn.sap.com/docs/DOC-47587
A first look at "River":
http://scn.sap.com/community/developer-center/hana/blog/2013/11/22/a-first-look-at-river
SAP River Tutorials:
http://scn.sap.com/docs/DOC-49281
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |