Define DataHub Connections

to establish your first database connection in litmus excel add ins, you must configure the datahub connection, check the firewall settings, and confirm successful communication with your database before you begin you know the ipv4 address of your litmus edge device or of your external database server your firewall allows connections through port 8086, and the database supports influxdb v1 with read privileges for the database you have installed the litmus excel add ins extension see install litmus excel add ins docid\ gzdhbj1xzznddthyocuuu for details step 1 navigate to datahub connections open a new excel file with litmus excel add ins enabled see install litmus excel add ins docid\ gzdhbj1xzznddthyocuuu to learn more click on manage datahub connections the litmus datahub connections window pops up you can take the following actions from this page add a new connection see step 2 (next step) below for detailed steps learn more this add in only supports connections using influxdb v1 you can access the influxdb documentation through this link note skip verification when the advanced threat protection dialog box appears important when trying to define a query, if no connections are defined, a message will appear indicating that no data sources are available step 2 add a new connection click on add to create a new datahub connection enter the following details litmus datahub server ipv4 enter the following the api for influxdb v1 only supports ipv4 addresses to access our internal tsdata database, use the ipv4 address of your edge device for this guide, we use our internal tsdata database litmus datahub port default is 8086 (change if using an external database) see manage the timeseries db docid\ evsb9ijcgk0g8t qwwyms for details litmus datahub database default is tsdata (change if using an external database) see manage the timeseries db docid\ evsb9ijcgk0g8t qwwyms for details litmus datahub user enter the user's name credentials for tsdata database see add database users docid\ c3c y 3k5fh t b1nchn for more details litmus datahub password enter the user's password credentials for tsdata database see add database users docid\ c3c y 3k5fh t b1nchn for more details timeout in seconds the time the connection will wait before reporting an error connection name a unique name to identify your connection if everything is configured correctly, you will see the message " litmus datahub & db reachable " in green at the bottom click save to store the connection the connection will now appear in the litmus datahub connections list your first database connection is now set up and ready for use in litmus datahub configure firewall settings ensure that the specified port is open and not blocked by firewall rules to prevent connection issues if using litmus edge v3 16 5 or later , you must configure firewall rules to allow traffic on port 8086 navigate to system > network > firewall and add a new rule for port 8086 see manage firewall rules docid\ p7splidisui2hj4mhdtpm for details if using an external database, configure the respective firewall settings see influxdb ports for more details troubleshooting the system will attempt to establish a connection with the database if successful, you will see a confirmation message if the connection fails, it is best to verify the ipv4 address, confirm login credentials, or ensure the database is accessible see configure the timeseries db docid 9th38ltnkfhzv3rsf7bmp for details check firewall rules see manage firewall rules docid\ p7splidisui2hj4mhdtpm for details