corelibraries-devexpress-dot-dataaccess-dot-connectionparameters-484589d9.md
Stores SAP HANA connection parameters.
Namespace : DevExpress.DataAccess.ConnectionParameters
Assembly : DevExpress.DataAccess.v25.2.dll
NuGet Package : DevExpress.DataAccess
public class HanaConnectionParameters :
SqlServerConnectionParametersBase,
IConnectionPagePort
Public Class HanaConnectionParameters
Inherits SqlServerConnectionParametersBase
Implements IConnectionPagePort
HanaConnectionParameters contains connection parameters required to establish a SAP HANA database server connection:
ServerNameGets or sets the name of the SAP HANA database server to which the connection should be established.PortNumberSpecifies the port number to connect to SAP HANA databases.UserNameGets or sets the user name used to authenticate to the SAP HANA database server.PasswordGets or sets the password used to authenticate to the SAP HANA database server.DatabaseNameGets or sets the name of the tenant database that contains the required data. If you do not specify DatabaseName, the system database is used instead.
The following code snippet shows how to supply a Report with data from the SAP HANA database:
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
using DevExpress.XtraReports.UI;
using System.Windows.Forms;
public partial class Form1 : Form {
public Form1() {
InitializeComponent();
// Configures connection parameters.
HanaConnectionParameters hanaParams = new HanaConnectionParameters();
hanaParams.ServerName = "hxehost";
hanaParams.PortNumber = 39015;
hanaParams.UserName = "SYSTEM";
hanaParams.Password = "17Me7P7n4";
// Creates a data source with the specified connection settings.
SqlDataSource sqlDataSource = new SqlDataSource("Data Source 1", hanaParams);
// Retrieves data from the data source.
SelectQuery selectQuery = SelectQueryFluentBuilder
.AddTable("Northwind.Order Details")
.SelectColumns("UnitPrice", "OrderID", "Quantity")
.Build("Query 1");
sqlDataSource.Queries.Add(selectQuery);
sqlDataSource.Fill();
// Creates a report and binds it to data.
XtraReport report = new XtraReport();
report.DataSource = new SqlDataSource(hanaParams);
}
}
Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
Imports DevExpress.XtraReports.UI
Imports System.Windows.Forms
Partial Public Class Form1
Inherits Form
Public Sub New()
InitializeComponent()
' Configures connection parameters.
Dim hanaParams As New HanaConnectionParameters()
hanaParams.ServerName = "hxehost"
hanaParams.PortNumber = 39015
hanaParams.UserName = "SYSTEM"
hanaParams.Password = "17Me7P7n4"
' Creates a data source with the specified connection settings.
Dim sqlDataSource As New SqlDataSource("Data Source 1", hanaParams)
' Retrieves data from the data source.
Dim selectQuery As SelectQuery = SelectQueryFluentBuilder.AddTable("Northwind.Order Details").SelectColumns("UnitPrice", "OrderID", "Quantity").Build("Query 1")
sqlDataSource.Queries.Add(selectQuery)
sqlDataSource.Fill()
' Creates a report and binds it to data.
Dim report As New XtraReport()
report.DataSource = New SqlDataSource(hanaParams)
End Sub
End Class
Refer to the following help topics for more information on how to configure connection parameters for the SAP HANA database in the UI and code:
Object DataConnectionParametersBase SqlServerConnectionParametersBase HanaConnectionParameters
See Also