OptiBizPro - Database Access

Enable Database Access

Go to Site Dashboard > Actions > Access site Database.

If you haven't previously used this feature, click on Enable Access after selecting the type of access you need. Now you'll see credentials to connect your database.

Connect to the Database

Analytics or Business Intelligence tool

Copy the credentials shown to your analytics tool. We only allow TLS connections. If you're having issues while connecting, ensure that the analytics tool is using SSL/TLS and our certificate chain.pem for *.optibizpro.com (Signed by Let's Encrypt).

MariaDB/MySQL command line client

Copy the command to your console and paste the password when prompted. You will need to install mariadb-client or mysql-client on your machine. If you have read-write access to your database, any changes made to your database will be permanent.

FAQ

Cannot connect to database from PowerBI

If connecting with PowerBI doesn't work, you might be using MySQL Connector. We use MariaDB for our databases. Please use the MariaDB connector with PowerBI for the same. You can find docs for the same here.

Error when running query

Sometimes you may get errors such as "lost connection to server during query". In such cases, the application with which you're connecting to the database may not be showing the exact error MySQL server is throwing. If you run into any errors when running queries, it's best to try the same query over the MySQL client in the command line. With the error thrown there, you'll be able to tell what exactly went wrong, and if anything is needed from our end, you can take a screenshot of the same and raise a support ticket with it.