SAP HANA pivot table reports

SAP HANA (cloud/on-premise/hybrid) can be used as a live SQL data source via official .NET client library. SeekTable is the perfect self-service BI interface for querying a SAP HANA in a controlled and manageable way, making it accessible to non-IT users with easy to use Excel-like reports builder.

SAP HANA connection setup

1. Click the "Connect to Database" to open a new data cube configuration form.
2. Choose Data Source Type: SQL-compatible database (this opens SQL Settings section).
3. Choose Database Connector: SAP HANA
4. Connection String example:

   Server=hanaServer:30015;UID=JSmith;Password=secret;

   Server	Specifies the SAP HANA server address or addresses host:port[, host:port]. If your system contains a failover standby node, then you can specify it as an additional optional address.
   UID	Specifies the user name.
   Password	Specifies the user password.
   DatabaseName	Specifies the name of the database to connect to (SAP HANA Platform only).

   Note: this is an incomplete list of supported SAP HANA connection string properties. For more options see SAP HANA Provider for ADO.NET Connection Properties.