Administration - Manage Database Profiles

Author: Colm Carew

Always remember to be careful and take note of what datasource you are connecting to.

In every report in the Reporting Manager that connects to the database, connects using a database profile. This is accomplished by the following line of code :

def db = SqlConnectionManager.instance.retrieveSql('databaseProfileName')

The above code will look for a database profile titled databaseProfileName in the Reporting Manager.

Database profiles can be accessed in the Reporting Manager by clicked the Manage Database Profile Button

Clicking this will bring up a popup similar to :

From this you can create/edit/delete database profiles.

Name: The desired name of the database profile
Connection URL : This specific where the database is
Username : This specifies the user to connect to the database as
Password : Password for this user
Driver : What driver to use when connecting - it will be com.mysql.jdbc.Driver in most cases as we use MySQL as our database

Set up a new database profile connecting to a database you can connect to. Use this connection to create a report such as the one used in the Table Report assessment