====== 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

{{:onboarding:reportingmanager:dbprofile.png|}}

Clicking this will bring up a popup similar to :

{{:onboarding:reportingmanager:dbprofilelist.png|}}

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

===== Assessment =====


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