...
- Log in as a user with the Confluence Administrators Global Permission.
- Select Add-ons from the Administration menu (cog icon:
) at the top right of your screen. Then scroll down to Bob Swift Configuration on the left-hand nav bar and choose SQL Configuration (see: 
). - Select View and Modify Data Source Profiles (see:
) from the top navigation. - Click on the
button.
The Add Profile screen will provide you with two setup options:
- Simple - this is the most straightforward way to connect to your database.
- By connection string - use this option if you want to specify additional parameters and are comfortable constructing a database URL.
Depending on the setup type, you'll be prompted for the following information.
| Setup type | Field | Description | |||||
|---|---|---|---|---|---|---|---|
| Simple | Database type | They type of database you are connecting to. | |||||
| Simple | Hostname | This is the hostname or IP address of your database server. | |||||
| Simple | Port | This is the port used to access your database on the server it is running against. | |||||
| Simple | Database | This is the name of your database. | |||||
| Both | Driver class | The class of JDBC driver that you will use to connect to your database (e.g., com.mysql.jdbc.Driver, or org.postgresql.Driver) | |||||
| Both | Driver JAR location | The path on your Confluence server where the JDBC driver is located.
| |||||
| By connection string | Connection string | The database URL is entered in this format (SQLServer example):jdbc:sqlserver://<hostname>:<port>;database=<database>For example: | |||||
| Both | Username | This is the username of your dedicated database user. | |||||
| Both | Password | This is the password for your dedicated database user. |
Extended Parameters
Data Source Profiles allow for the configuration of extended parameter options. These profile-wide settings will be used by all SQL Macros if not overridden at the Macro-level.
Table: extended parameter options explained
| Parameter | Macro Parameter | Default | Description |
|---|---|---|---|
| Limit rows processed | limit | no rows |
View Data Source Profiles
...