Creating a connection to SQL Server in DataLens On-premises

To create an SQL Server connection:

  1. Go to the workbook page or create a new one.

  2. In the top-right corner, click Create → Connection.

  3. Select MS SQL Server as the connection type.

  4. Specify the connection parameters for the external MS SQL Server database:

    • Host name: Specify the path to a master host or a SQL Server master host IP address. You can specify multiple hosts in a comma-separated list. If you fail to connect to the first host, DataLens will select the next one from the list.

    • Port: Specify the SQL Server connection port. The default port is 1433.

    • Path to database: Specify the database name.

    • Username: Specify a username for the SQL Server connection.

    • Password: Enter the password for the specified user.

    • Cache TTL in seconds: Specify cache TTL or leave the default value. The recommended value is 300 seconds (5 minutes).

    • Raw SQL level: Enables you to use an ad-hoc SQL query to generate a dataset.

  5. Optionally, test the connection by clicking Check connection.

  6. Click Create connection.

  7. Select a workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.

  8. Enter a name for the connection and click Create.

Additional settings

You can limit data export from charts by enabling the Disable data export option under Advanced connection settings. Thus, for charts based on the respective connection, the export data option will not be available in their menu. However, you will still be able to copy chart data and take screenshots.

Previous
Creating a Greenplum® connection
Next
Creating an Oracle Database connection