Connector
To configure the connector, from the Project Explorer select Connect, Connectors.
Click Add
Select Database (time series), Historical values (wide)
Click OK
Primary Database
This defines a connection to the database where the report data is located. A browse button […] is provided to define. If there are issues connecting to the database, please refer to the section in the Database Connectors document on the specific database.
Settings
 |
Tables/Views Tab
The Tables/Views tab displays a list of tables and views from the database which should be considered for the connector. The initial list is generated automatically after the connection to the database is established by listing every table and view in the database that has a column with a DateTime type.
Each row consists of the following settings:
Table
The name of the table or view in the database.
Friendly Name
The name that the table or view will be displayed as when items are browsed for the connector.
By default, this is the same name as the table or view in the database but can be changed to something more descriptive and user friendly.
Date Column
The name of the column in the table or view that contains the timestamp to use when requesting data.
Note that the specified column must either be a valid date/time type reference or a CAST statement so that it is treated as a timestamp (e.g., CAST(mycolumn AS datetime).
Additional tables and views can be added to the list. Tables and views can be deleted from the list by selecting the row indicator column on the left and pressing the Delete key.
When the connector is saved the first time, catalogs are created for every table/view listed here. If the connector is modified and tables/views are added or removed from the list, the subsequent catalog is added or removed from the project but catalogs for existing tables and views are not modified in any way. This means that if a column is added to an existing table or view, it must be added to the catalog manually.
The Reset option resets the list of tables and views by running the same detection as it did when the connection to the database was first established. Please note that this will delete every existing catalog for the connector in the project. These catalogs will get regenerated when the connector is saved but any modifications made to any catalog will be lost.
Settings Tab
The Settings tab provides the settings used to query data from the database. For more information see Settings in the Historical values (wide) section of this document.