SAP HANA Query Consumer

The SAP HANA Query Consumer origin reads from an SAP HANA database using the specified SQL query. For information about supported versions, see Supported Systems and VersionsSupported Systems and Versions in the Data Collector documentation.

The SQL query can read data from a single table or from a join of tables. The origin returns data as a map with column names and field values.

When you configure SAP HANA Query Consumer, you specify connection information and credentials that determine how the origin connects to the database. You configure the query mode, SQL query and related information to define the data returned by the database. You can call stored procedures from the SQL query.

You can enable SAP HANA split batch commands, which allow parallel execution of the query on partitioned tables. You can specify custom properties that your driver requires. And you can specify what the origin does when encountering an unsupported data type: convert the data to string or stop the pipeline.

By default, the origin generates JDBC record header attributes and JDBC field attributes that provide additional information about each record and field. You can configure the origin to generate SAP HANA record header attributes that provide details about the connection.

The origin can generate events for an event stream. For more information about dataflow triggers and the event framework, see Dataflow Triggers Overview.

Before you use the origin, you must install a JDBC driver.