Datalore 2024.4 Help

Microsoft SQL Server

This procedure explains how to configure a Microsoft SQL Server/Microsoft SQL Server (jTds) database connection. It is assumed that you are working on the General tab of the New Microsoft SQL Server connection dialog and need to provide connection details relevant for this particular database type.

Configure a Microsoft SQL Server connection

  1. Open the New Microsoft SQL Server connection dialog. Select the tab for one of the two options:

    • From the editor, to attach the new database to a specific notebook

    • From the Home page, to add a database connection to a workspace

    • Go to Main menu | Tools | Attached data or click the Attached data icon on the left-hand sidebar.

    • Click New connection and select New database connection.

    • In the New database connection dialog, select Microsoft SQL Server.

    • On the Home page, select the workspace where you want to create the connection.

      Selecting a workspace
    • Select Databases from the menu under the workspace name.

    • Click the Add connection button in the upper right corner. The New database connection dialog will open.

    • In the New database connection dialog, select Microsoft SQL Server.

  2. On the General tab, select the connection type.

    • default: to connect by specifying the Host, Port, and Database.

    • URL only: to connect by providing the URL of a pre-built connection.

  3. Proceed based on the selected connection type:

    1. In the Host field, type your server address.

    2. In the Port field, type the port. The default port is 1433.

    3. In the Instance, type the instance you want to connect to.

    4. Under Authentication, select an authentication method:

      • User & Password: to use your login and password

      • No auth: to connect without authentication required

      • Domain credentials: to connect using Windows domain authentication (for Microsoft SQL Server (jTds) only)

    5. In the User and Password fields, specify your credentials if required by the selected authentication method.

    6. In the Database field, type the database name to which you want to connect.

    1. Under Authentication, select an authentication method:

      • User & Password: to use your login and password

      • No auth: to connect without authentication required

      • Domain credentials: to connect using Windows domain authentication (for Microsoft SQL Server (jTds) only)

    2. In the User and Password fields, specify your credentials if required by the selected authentication method.

    3. (If Domain credentials is selected) In the Domain field, specify the domain.

    4. In the URL field, provide the URL of the pre-built connection you want to establish.

    5. (If Domain credentials is selected) In the Domain field, specify the domain.

  4. Click the Test connection button at the bottom of the dialog.

  5. Once the connection is successfully tested, click the Save and close button.

Results

  • If created for a specific notebook, the new connection will be automatically added to the workspace. You can later attach this database to any other notebook from this workspace.

  • If created for a workspace, this connection is added to the workspace databases and can be attached to any notebook from this workspace.

  • To retrieve and process data from the connected database, use Query data with SQL cells.

Last modified: 21 March 2024