SeekTable can integrate fairly easily with MS SQL Server using SQL-compatible database connector. SeekTable is great if you need to give non-technical users the ability to query data, but leave an ability to use full power of SQL behind the scene for cube's creators. Also SeekTable may be considered as a modern lightweight replacement for SSRS tabular reports.
Connection String should be a valid connection string for SqlClient driver; for example:
Data Source=hostName;Database=db;User=user;Password=password;
| Data Source or Server |
this setting specifies the name of the server and the SQL Server instance on the server. The port number can be specified after the server name (optional): ServerName\Instancename,portNumber.
Do not use ".", "(local)", "localhost" or LAN name as a server name; use only public IP address or domain name of the server. If you omit the instance name, the default instance is assumed. |
|---|---|
| Database | specifies the name of the database in the SQL Server instance. |
| User | SQL Server login account. It is recommended to create special user with read-only rights. |
| Password | The password for the SQL Server account logging on. |
Note: do not specify "Integrated Security", this option is irrelevant in SeekTable environment.