Send data from SQL server to InfluxDB via Apache Nifi's PutInfluxDB processor
The issue your experiencing is because you're attempting to write to InfluxDB 2.x and the PutInfluxDB processor included with NiFi is only compatible with InfluxDB 1.x.
InfluxData has NiFi plugins available to support InfluxDB 2.x: https://github.com/influxdata/nifi-influxdb-bundle
After installing the plugins, the processor you'll want to use is called PutInfluxDatabaseRecord_2
.
To install the plugin, simply download the nar file for your version of NiFi (I believe it's 1.13.x in your case) and copy the file to the lib
folder of your NiFi deployment:
e.g. $ cp ~/Downloads/nifi-influx-database-nar-1.13.0.nar $NIFI_HOME/lib
When you restart NiFi, the PutInfluxDatabaseRecord_2
processor will be available. This processor requires a StandardInfluxDatabaseService_2
controller service which is where you will configure access to InfluxDB via an InfluxDB API Token.
Learn more about creating API Tokens here: https://docs.influxdata.com/influxdb/cloud/security/tokens/create-token/