Write to SAP HANA

To write data to SAP HANA with Flux:

1. Import the sql package.

2. Pipe-forward data into sql.to() and provide the following parameters:

   • driverName: hdb
   • dataSourceName: See data source name
   • table: Table to write to
   • batchSize: Number of parameters or columns that can be queued within each call to Exec (default is 10000)

import "sql"
  
data
    |> sql.to(
        driverName: "hdb",
        dataSourceName: "hdb://username:password@myserver:30015",
        table: "SCHEMA.TABLE",
    )

SAP HANA data source name

The hdb driver uses the following DSN syntaxes (also known as a connection string):

hdb://<user>:<password>@<host>:<port>?<connection-property>=<value>&<connection-property>=<value>&...
hdb://<user>:<password>@<host>:<port>?DATABASENAME=<tenant-db-name>
hdb://?KEY=<keyname>

Flux to SAP HANA data type conversion

sql.to() converts Flux data types to SAP HANA data types.

* The SAP HANA TIMESTAMP data type does not store time zone information and SAP strongly discourages storing data in the local time zone. For more information, see Timestamps in SAP HANA.