Page History
Once one or more Data Sources are connected you can view their properties, rename them or close them.
- Data Source Properties
- Renaming a Data Source
- Editing a Data Source's Query
- Editing a Data Source's Connection
- Replacing a Data Source's Connection
- Closing a Data Source
...
In the Data pane you can right-click on it and select Properties to view its details.
Data Source Properties will display the following:
- Type - The vendor (as listed in its Server Properties for the connection).
- Server Version - The Server Version as reported back from the Server.
- Host - The location of the server as set in the Server Properties Location Server Host Field.
- Connection - The name and location of the connection file (.conn).
- Database - The name of the connected database for the connection.
- Schema - The schema being used, if any.
- Username - The username for the connection's authentication, if any.
- Query - The query executed to generate the Grid or Pivot Grid results used to launch Visual Analytics, either from the Query Analyzer Window or Query Builder. A Refresh within Visual Analytics does not update it with any changes made in the query since Visual Analytics was spawned from it. Use [Edit Query]... to alter it.
- Max Results - The Max Results value taken from the Query Analyzer's Max Results field in its toolbar. This value determines the maximum number of results retrieved by the query and if blank has no limitations.
Info |
---|
If you've executed a cross database query within the Query Analyzer, and used that Query Result to launch Visual Analytics, the Data Source properties will only display the Database of the Query Analyzer's Database dropdown from within the Query Analyzer toolbar. You can view the [Data Source Property's] Query to determine what databases were used in the query itself. |
Renaming a Data Source
...
- Selecting Data > (choose a Data Source) > Rename...
- Right-clicking on a Data Source and selecting Rename... in the context menu
Info |
---|
Renaming a Data Source only changes its name in the Data Pane, it does not alter the underlying connection. It's easy to verify this by viewing [Data Source properties] and looking at the Connection value. |
...
The process of Refreshing a Data Source does not update the query used to refresh data. To edit the query used in a Data Source, right-click on the data source and select [Edit Query...]
A dialog appears that allows you to edit the query. The [Insert Parameter] button allows you to use a preexisting Parameter from your visualization, or create a new one.
Click [Preview Results] to see the data this query will generate.
Once you see the data you need, click [Save] so that this query is used any time your view is Refreshed.
...
To remove a Data Source and clear all of its fields from all decks, right-click and select [Close].
You will receive a dialog explaining that all open worksheets using the Data Source will be cleared. Click [Yes] to continue.
Info |
---|
If you [Close] a Data Source using an Extract, only the Data Source is removed while the Extract itself is not deleted. |
...