Home / FactoryTalk Optix / Alarms, Trending, and Data Loggers
Description
Testing InfluxDB 3.0 in FactoryTalk Optix! First sensations using this new database version who brings new functionalities like SQL query language in a time stamp database. Even a Grafana web window is inserted inside FT Optix to display statistical process analytics.
Download the sample code:
https://github.com/xavierflorensa/FactoryTalk_Optix_InfluxDB30
Contributed by Xavier Florensa – YouTube – LinkedIn – GitHub
Transcript
(00:01) Hi everyone. In this video, I will show you how to use Influx DB 3.0 with factory talk optics. Uh you have to be aware that Influx DB 3 has no graphical user interface. So I will show you how to use Influx DV explorer and then we’ll connect a graphana visualization inside a windows in optics to show uh statistical trends or historian.
(00:42) You can also use um objects edge perform this even to for this use case I have used my laptop. So first of all you have to have running instance of influx db you have to install influx dv 3.0 0 on your laptop and with this comment you can execute your Influx DB3.0 zero instance and as I said there’s no graphical jur interface here to have your database running and you have to have the influx DB explorer in docker not possible to install in windows so here we have our in db3 explorer running in this port can take a look at this for
(01:44) and you can see the different databases you have with the table. In this case, you don’t talk about buckets. In this case, you talk about table and then you can make SQL queries. This is interesting from Flax DV 3.0. Z can run the query and so on. Since we have the system running, you can run different queries.
(02:25) Okay, this there’s a lot more on this explorer, but I will explain on the next video. Then we can go to our optics application. where we have a randomly generated value from 0 to 10 with gausian distribution and here we have a a window I will explain what is this window but first of all take a look at the database here in the database we use this port this is the port where the influx DB 3.
(03:04) 0 is running in organization with 3.0 zero. You don’t use organization and the bucket here is the name of the database. You have to have a token when you install inflax db 3.0 you get this token and this is all. Then in this window I just have a graphana representation on my laptop. I will show you right now. So if we start this application here, you’re going to find a window with your uh data.
(03:58) This case is a statistical process control historian plug-in in graphana. You can refresh it have a lot of information. Let’s take a look on the graphana here. Here you can have a lot of statistical data thanks to this plugin. Very interesting. Play a little with this options. And for the connection you have to use in data source to connect to influx db 3.0.
(04:48) Now we have to use SQL query language. This is the URL where the database are running. You also use basic authentication with user and password. And that’s all. When you make safe and test, you have success. Then you can go to dashboards, build your own dashboard. And once you have it, you can just copy this URL and paste in inside of the window the URL here.
(05:43) That’s how you manage to get your graphana visual visualization in optics. And this is all I hope you enjoy it. Thank you very much.