To create a MariaDB data source:
- In the Data Manager window, click Sources +.
- In the Source Types window, click START on the
tile. The MariaDB dialog box is displayed.
- Enter your Server location.
- Either enter your MariaDB port number or leave the default port number [3306] as-is.
- [Optional] Enter a user name.
- [Optional] enter a user password.
- Enable / disable Use SSL. The default is Use SSL enabled.
- Enable Verify Server Certificate.
- Click LIST DATABASES to display the databases available on the server and user data specified.
- Choose a Database.
- Add an Anodot server IP to your firewall's whitelist.
See Whitelisting Anodot Servers - Click Continue to open the Stream Query window.
Note To create a MariaDB stream query, see Creating a Stream Query from a Database
RELEVANT ARTICLES
Using Data Collectors
Data Manager
Stream Tables
Viewing Stream Summaries