<< Click to Display Table of Contents >> Navigation:  Data Source Management > Database - MySQL, Oracle, SQL Server, PostgreSQL

 

Database connection works with database query only. You can create different queries within one connection. A good practice is to create a query which contains the fields and level of data you need. A general query joining too many tables could have a big performance impact when the dashboard or report runs.

 

Following is an example of MySQL database connection. Similar parameters are used in other database connections like Oracle, SQL Server and PostgresSQL.