Differences

This shows you the differences between two versions of the page.

--- onboarding:reportingmanager:administration_-_manage_database_profiles [2016/08/15 15:55] – scotty
+++ onboarding:reportingmanager:administration_-_manage_database_profiles [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== 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

Sidebar

Internal Errigal Collaboration Wiki

Differences

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Differences

Page Tools