SAP HANA is a high-performance in-memory database system that can be accessed using SQL. Before attempting to establish a connection with HANA SQL, you must ensure that the server you are connecting from has the appropriate network access to reach the HANA database. This may require configuring your firewall or network settings, depending on your specific setup.
Once you have verified that the necessary access has been granted, you can proceed with providing the relevant information to establish the HANA SQL connection. This will typically include details such as the database name, host address, and port number. By completing this process accurately and comprehensively, you can establish a successful connection with HANA SQL and begin working with your data.
The table below provides an explanation and type of parameters that must be filled by the user to establish a connection with SAP HANA. It outlines the specific parameters required and their corresponding data types, which must be correctly entered to successfully establish a connection with SAP HANA.
Hana | ||
Host | Server Host | String |
Port | Server Port | Int |
Schema | Schema name | String |
UserName (Optional) | Username to connect to server | String |
Password (Optional) | Password to connect to server | String |
Inputs | Connection Inputs | List |
Outputs | Connection Outputs | List |
Once the connection with the SAP HANA SQL source has been established successfully, the "input" page is utilized to define the data or dataset. This step involves specifying the necessary details related to the data or dataset, such as its location, type, and structure. Ensuring that all the relevant information is accurately entered on the "input" page to properly define the data or dataset is crucial for the successful transfer of data to a SAP HANA SQL table.
A detailed explanation of the Object Explorer feature can be found in section 2.1 of this user manual. This feature enables tables and columns within your database to be easily navigated and selected, and then used in your SQL queries by dragging and dropping them into the input query section.
To view the results of the written query, refer to section 2.2, which covers the 'Execute Query' feature. This feature allows the user to execute the query and view the output in the result window, as described in the previous section. By combining the Object Explorer feature with the ability to execute SQL queries, users can easily navigate their databases and select tables and columns to be used in their queries.
Input | ||
Query | Query to run | String |
To transfer the data package created by the user to an SAP HANA table, an output must be defined. If the table is not already present in the database or the user wishes to make modifications like adding columns to it, then they must use SQL commands to create or modify the table. This allows the user to define the table structure, specify column names, data types and sizes, and set any constraints on the table. It is important to ensure that all the required information is accurately entered when creating or modifying a table in SAP HANA using SQL commands.
Output | ||
TableName | Name of the table | String |
CreateTable | Whether to create a new table if it does not exist | Bool |