Connector
To configure the connector, from the Project Explorer select Data, Connectors.
Click Add
Select Database, Microsoft SQL Server
Click OK
 |
Primary Database
This defines a connection to the database. A browse button […] is provided to define.
 |
In Database Connect, select Microsoft SQL Server on the left.
Server Name is the name of the SQL Server and instance to connect to. This can be selected from the drop-down list or manually entered. Note, if Browser service is not running for SQL Server, it may not appear in the drop-down.
Under Log on to the server, define the authentication used to connect to the Server name specified.
For Database, select the Database containing the data to report on.
Click Test Connection to validate the connection and return to the connector settings.
Settings
The Settings button opens the Settings dialog that defines characteristics of the database that are used to retrieve data.
 |
Typically, these settings are defaulted correctly for SQL Server.
If queries timeout, increase the Client Wait Time.
The delimiter and timestamp settings are typically filled in automatically for the database and can be modified for other databases.
The Date/Time Storage settings define how timestamps are stored in the database. Using this setting the timestamps are manipulated when data is retrieved so that local timestamps are submitted in and returned.
Many databases require the Date format to be YYYY-MM-DD so that no interpretation needs to occur based on the Region settings of the Windows Operating System. It is recommended to always have this option checked.