Data source profiles - 8.x

Owned by Randall Ward
Last updated: Mar 02, 2020 by Smita Nair
3 min read

On this page

Description

This information is primarily for the Confluence or SQL for Confluence administrator.

Data source profiles allow the administrator to provide additional configuration for use by SQL macros. See Release notes 5.2 for details on the new capabilities this provides. Data source profiles can be stand-ins for data sources referenced by macros using the dataSource parameter. They are treat the same. This includes how you configure Macro Security for Confluence. Think of data source profiles as just additional data sources for use.

How to implement role based security for SQL queries provides an example use case.

Definition

Each data source profile is identified by a unique name. This name is case specific, just like application server defined data sources. The value field is a | (bar) separated list of parameter expressions of the form name=value. This is just like wiki markup macro parameters and are case insensitive.

Screen shot

  • Go to Manage Apps in Confluence administration.
  • Find the SQL for Confluence app in the list.
  • Click Configure.

Parameters

Quick configurations

  1. Copy and paste the configuration into your data source profile configuration.

  2. Change the name to something meaningful for your organization.
  3. Modify the URL to your database server.
  4. Modify the database name (from test to the name of database you want to query).
  5. Modify the user and password to match the user credentials defined for the the database server.

  6. 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 database parameters are required when defining database access directly. Otherwise, you likely get a dataSource not found message.

Using the lib location

Often, using the lib location (for 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:

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.