MariaDb
MariaDB connection helps you connect to a MariaDB database and run queries directly from Infoveave.
Adding a MariaDB Connection
To create a new MariaDB connection:
- Go to the Database section.
- Select MariaDB from the available connectors.
- Fill in the required connection details in the New MariaDB Connection form.
Connection Parameters
When setting up a MariaDB connection, you need to provide the following details:
Field | Description |
---|---|
Name | A unique name to identify your connection. |
Port | Port number for MariaDB (default is 3306 ). |
Server | The MariaDB server endpoint. |
Username | Your MariaDB username. |
Password | The corresponding password for the username. |
Database | The MariaDB database you want to connect to. |
Schema | The schema inside the database to be used (optional). |
Steps to Validate and Save
- After filling in the details, click Validate to verify the connection.
- If validation succeeds, click Save to store the connection.
- You can now use MariaDB as a datasource in your Infoveave workspace.
Example Use Case
With a MariaDB connection configured, you can:
- Run queries on structured data stored in MariaDB.
- Use MariaDB SQL to manage and analyze transactional or analytical datasets.
- Integrate MariaDB data into Infoveave Infoboards for dashboards, reports, and insights.