OK so we can add a connection in the Gateway settings but how do we specify what to name the database that Ignition will create and store the data in? It looks like it created a DB called test on my “learning” machine but I already have a DB called test on my production server.
Specifying DB name depends on which DB driver you are using. Start here:
https://docs.inductiveautomation.com/display/DOC79/Connecting+to+Databases
There are additional links on that page for specific DB drivers. Using MySQL as an example. the Connect URL includes the DB name like this:
jdbc:mysql://localhost:3306/test
The portion after the last slash (“test”) is the DB name. If you want a different DB, create it, and change the Connect URL accordingly.
Ignition won’t create a database for you. It will create tables within a DB automatically for many situations, but you have to create the DB, user credentials, whatever, with that database’s tools, before a connection will work.
3 Likes