- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
Create Relational Connection in SAP HANA in 8 Steps
Relational Connection in SAP HANA
A relational connection is an indirect way of connecting to the SAP HANA database. The reporting tools that cannot connect directly to the SAP HANA database, consumes data from the data foundations present in the data universes.
Therefore, the data universes are connected to the SAP HANA database via relational connections.
These connections establish using JDBC/ODBC connection drivers. Reporting tools like Web Intelligence and Dashboard Designer use a relational connection to connect to SAP HANA.
Once a reporting tool is connected to the SAP HANA database via a relational connection, it is saved in the repository for further use. The user can then use data from SAP HANA to create the data foundation for your universe layer.
How to Create Relational Connection in SAP HANA
In this section, we will learn how to create or establish a relational connection in SAP HANA. Here, we are making a connection through the Information Design Tool (IDT).
You can start creating a relational connection with the SAP HANA database after creating a new project in IDT.
The steps to create a relational connection are given below:
Step 1: Information Design Tool
Open the Information Design Tool’s main page. Right-click on the project name under Local Projects tab.
Select New and then select Relational Connection.
Step 2: Resource Name
Enter the name of the connection in Resource Name option and click Next. For instance, we have entered the name SAP_HANA. You can also add a description of the connection in the Description box given.
Step 3: Database Middleware Driver Selection
Next, we will select the SAP HANA database driver. In the “Database Middleware Driver Selection” dialog, select the SAP option.
Then, expand the SAP HANA database 1.0 driver list.
Select JDBC driver as the connection driver. Click Next.
Step 4: Parameters for SAP HANA database 1.0 Connection
Enter the SAP HANA database user information; Authentication Mode, User Name, Password, and Server (host:port) details. Also, you can select from a list of Authentication Modes.
You can also test the connection by clicking on Test Connection. A message will prompt confirming the successful connection if the connection is correct.
Click on Next> to continue.
Step 5: Database Specific Parameters
Next, we will have to enter database specific parameters such as Connection Pool Mode, Pool Timeout, Array Fetch Size, Array Bind Size, Login Timeout, JDBC Driver properties, etc. Click Finish after entering all the details.
The Array Fetch Size number decides how many lines will be fetched from the database in each trip until the full data set is fetched.
If you need faster data retrieval from the database, set the array fetch size to 1000 (maximum value). But do make sure that the client tool has enough memory. The default value is 10.
Step 6: Connection Configuration & Details
The connection is successfully created. You can check the connection configurations in the tab present on the screen. The connection parameter screen will also have a General section and a Login Parameter section.
You will have the following information regarding the newly created relational connection.
- Authentication Mode
- User Name
- Connection Pool Mode
- Pool Timeout
- Array Fetch Size
- Array Bind Size
- Login Timeout
- JDBC Driver Properties
Step 7: Publish in BO Repository
Now, for the users to use this connection from universe designers, we need to publish this connection in the BO repository and create a shortcut.
To publish the connection we just created, right-click on the connection name. The new connection is shown under your project name in the Local Projects tab. Then select Publish Connection to a Repository option.
Step 8: .cnx File to Prohibit Users
This will publish a secured repository connection under the project tab with .cns extension. Along with this, a .cnx file will also be created which is a local unsecured connection prohibiting the users to publish anything in the repository.
Apply now for Advanced SAP Course