How to add a custom query in a data connection

book

Article ID: KB0078237

calendar_today

Updated On:

Products	Versions
Spotfire Analyst	All versions

Description

This article describes how to add your own custom query in a data connection

Issue/Introduction

When creating a data connection in TIBCO Spotfire, it is possible to add your own custom query next to adding data tables in the data connection. This is done by clicking the button "Custom Query" in window "Views in Connection".

Environment

Windows

Resolution

Using TIBCO Spotfire Analyst version 7.14 and lower:

Open your Analyst client.
Go to File - Add data tables.
Click the "Add" button, go to the section "Connection to" and add your preferred data connection.
Logon to your data source.
In the "Views in Connection" window, click the "Custom query" button.
Add your query.
Click the "Verify" button to verify the query is correct.
Click OK.

Using TIBCO Spotfire Analyst version 10.0 and higher:

Open your Analyst client.
Go to the Files and data flyout, click "Connect to" and mark your preferred data connection.
Click the "New connection" button and logon your data source.
In the "Views in Connection" window, click the "Custom query" button.
Add your query.
Click the "Verify" button to verify the query is correct.
Click OK.

User-added image

Note: Custom queries must be trusted by a user belonging to the group "Custom Query Author" in order to work in the web clients. For more information on this, please refer to the page Writing Custom Queries in the Spotfire Analyst User's Guide

Note: For information on how to edit existing custom queries, please see the following article:
https://support.tibco.com/s/article/How-to-edit-an-existing-custom-query-in-a-data-connection