Connecting to SQL Server
The SQL Server connector allows users to visualize data stored in SQL Server databases.
The Zoomdata Server supports SQL Server 2012 (11.0.2100) and later versions. To configure the connector, perform the following steps:
Specify the name of your source and add a description (if desired). Click
On the Connection page, define your connection source. You can select an existing connection, if available, or create a new one. To create a new connection, select the Input new credentials option button and specify the connection name and JDBC URL.
The JDBC URL for SQL Server database being connected, must be: jdbc:sqlserver//MYSQLSERVERHOST:PORT
Specify the user name and password if your database requires authentication. Click Validate . The validated connection is saved. Click Next to continue.
On the Tables page, select the schema and data table to use for your charts. If you want to add a custom SQL query to retrieve the data, click Custom SQL .
- Toggle the caching options (SparkIt and Caching) as needed (by default, SparkIt is disabled; access the article How Zoomdata Caches the Data for more information). Click Next to continue.
On the Fields page, you can create unique label names for the available fields in your data source. These labels will be displayed in the charts. Create unique label names, as needed, for each Label field. If necessary, change the Type and Default options, select the checkboxes in the Distinct Count column. Configure Filter Display settings for the required fields. Click Next .When you create a data source, the specific number of distinct values for the attribute fields are saved in Zoomdata depending on the data sample from your data data set. You can filter the data on your chart by these values. However, if you want to use all distinct values in the filter (that is from whole data source), click the Refresh button in the Statistics column.
- On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
page, you can:
Learn more about how to customize a chart .
- Edit Global Default Settings
- Select the Standard and, if available, Custom chart styles to be used with the data source
- Set default parameters (group-bys, colors, sorting, etc.) for each chart style
- Click Finish to save your changes.