.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
On this page
Description
Data Source Profiles allow the Confluence Administrator to extend Data Sources by providing additional configuration parameters for use by SQL macros. Like Data Sources, Data Source Profiles are referenced by the SQL, SQL-query, and SQL-file Macros using the dataSource parameter.
Note: you must have at least one Data Source in order to begin using this application within Confluence.
Add Data Source Profiles
To add new or extend an existing Data Source Profile:
- 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. Start with an absolute file reference Usually better to start with an absolute reference to make sure it is working. Relative references are more maintainable, but can be problematic especially on Windows. After it is working, you can experiment with relative references. |
| 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 limit | The maximum number of rows that will be processed and displayed by SQL macros. This prevents queries that result in a large number of rows from using excessive resources. Individual queries can use the limit parameter to override this value. The following options are available for selection:
|
| Limit query time | queryTimeout | No |
View Data Source Profiles
To view, add, or modify a Data Source Profile:
- 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.
- You will see a list of Data Source Profiles and their connection status.
Security
Data sources are shared resources. Some of these resources may need to be secured for use only by specific users or groups. This can be accomplished by using Macro Security for Confluence and configuring access to the macro and perhaps to individual profiles.
Parameters
Copy and paste the configuration into your data source profile configurationQuick Configurations
- Change the name to something meaningful for your organization
- Modify the url to your database server
- Modify the database name (from test to the name of database you want to query)
- Modify the user and password to be match the user credentials defined for the the database server
To test: create a page and use Insert -> Markup to add the following wiki markup : {sql-query:dataSource=example} select 1 {sql-query}
dataSource not found
All 5 db parameters are required when defining db access directly. Otherwise you will likely get a dataSource not found message.
Using the lib location
Often, using the lib location (example: dbJar=lib/ojdbc6.jar) is best especially if you already have or later intend to define an application server based data source. The following is for a standalone installation.
