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...
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