SapHana.Database

This function retrieves a table of multidimensional packages from the SAP HANA database server. You can define optional parameters, known as options, to specify various settings: - Query: A native SQL...

Syntax

SapHana.Database(**server** as text, optional **options** as nullable record) as table.

About

This function retrieves a table of multidimensional packages from the SAP HANA database server. You can define optional parameters, known as options, to specify various settings: - Query: A native SQL query used to fetch data. If the query returns multiple result sets, only the first set will be returned. - Distribution: Determines the distribution method for the "Distribution" property in the connection string. Statement routing is used to determine the appropriate server node in a distributed system before executing a statement. The default distribution method is SapHanaDistribution.All. - Implementation: Specifies which SAP HANA connector implementation to use. - EnableColumnBinding: Links variables to columns in a SAP HANA result set during data retrieval. This option may enhance performance at the expense of slightly higher memory usage. The default setting is false. - ConnectionTimeout: Specifies the duration to wait before abandoning a connection attempt to the server, with a default duration of 15 se