Page Comparison

...

Option 1: Modify and provide the connection string details with the Data source name as None.

Option 2: Modify and choose a configured local data source.

...

1. Log in as a user with the Confluence administrator's Global Permission.

2. Navigate to Manage apps > SQL for Confluence Configuration > View and modify data source profiles.

3. The page displays a list of data source profiles and their connection status. The application server defined data source profile rows are highlighted and show UNSUPPORTED. The Connection status shows Failed.

4. <Screenshot>

5. To modify the application server defined data source (global data source) profile, click Edit to the right of the data source profile.<Screenshot>

   Image Added

6. The Edit Profile window opens. To convert the application server defined data source profile to a connection string profile, you have two options:

• Option 1: Provide the connection string details with the Data source name as None.

  Image Added

• Option 2: Choose the data source already configured with the connection string details of the database. <screenshots>

  Image Added

8. Once you reconfigure the data source profile to the connection string profile, the warning message disappears in the SQL macro editor. Also, the corresponding row gets unhighlighted in the View and modify data source profiles page.<We can include gifs for the above scenario>

...

SQL for Confluence 11.x app updates in Confluence 8.x

The SQL for Confluence app version 11.x supports only data source profiles using a direct JDBC connection in Confluence 8.x.

• The application server defined data source (global data source) profile is not supported in Confluence 8.x and you may see warning messages in View and modify data source profiles page, confluence page rendering SQL macro with global data source profile and SQL macro editor.

  Image Added

  Image Added

  Image Added

...