InfluxDB (2.x) Data Import


Pro This data connector is only available in Visplore Professional.

Visplore can connect to InfluxDB 2.x databases via a custom Python importer utilizing the Flux query language.


Setting up the initial InfluxDB connection

Setting up a connection to an InfluxDB database in Visplore is easy. Start Visplore and select “InfluxDB Python Importer” in the welcome dialog.

If this is the first time that this option is selected, then you’ll be asked to specify the connection settings



Configuring and filtering the import

After setting up the connection, data import window will pop up as shown below. You can configure the import parameters as you wish using the explanations provided.

After clicking ‘OK’ in the ‘Import data…’ window, depending on your data structure, ‘Asset/Variable structure definition’ window might pop-up.

1. Asset ID columns: Select the attributes to be identified as asset IDs. Visplore might have made an automatic selection for you. You can also change this assignment by clicking the ‘Change’ button. This can also be set or changed after the import is completed.

2. Variables as categories: Select the attributes to be defines as key categories for a rows to columns transformation. This can also be set or changed after the import is completed.



Setting up additional connections and selecting among them

If you have already set up a connection and want to add an additional one or chose between the existing connections, please refer to this section.

1. Click the icon in the ‘Welcome’ dialog

2. Once the ‘Select connection…’ window pops up, click the downwards pointing arrow.

3. Then, in that drop-down menu, you can select among the existing connection or opt for creating a new one.