Datalore 2025.6 Help

Connect to a database by importing connection details

Create a database connection by providing connection details in XML format.

Before you begin

Make sure your database instance is configured to accept incoming connections from the following IP address:

63.33.83.29

Step 1. Configure a database connection

  1. Copy the XML with database connection details to the clipboard.

  2. Open the New database connection dialog. The step depends on whether you want to add a new database connection in workspace resources or in a notebook.

    1. In the sidebar on the Home page, select the workspace where you want to create a database connection.

    2. In the workspace resources, select Document Data and switch to the Databases tab.

      'Databases' tab

    3. Click Plus icon New database connection at the top right.

    1. In the sidebar, select Attach (Attached data).

    2. Switch to the Databases tab. You will see the list of all database connections available from the respective workspace.

    3. Click Plus New database.

      The Attached data section in a notebook with the Databases tab open

  3. In the New database connection dialog, switch to the Import XML tab.

    New database connection dialog

    The tab looks like this:

    Import XML tab

  4. Click the Import from clipboard button. This will process the provided data and open the connection dialog for the respective database type with all the fields pre-filled.

  5. Provide the missing details, for example, the password.

    Database connection dialog after importing XML

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

  7. Once successfully tested, click the Create and close button.

Step 2. Attach the connection to a notebook

  1. Open the notebook you want to attach the connection to.

  2. If the notebook is not running, start it by clicking Run | Start machine.

  3. In the sidebar, select Attached data and switch to the Databases tab.

  4. Enable the toggle in your database connection.

  1. If the notebook is not running, start it by clicking Run | Start machine.

  2. In the sidebar, select Attached data and switch to the Databases tab.

  3. Enable the toggle in your database connection.

    Results

    • If OAuth authentication was used for this connection, report users and notebook collaborators may be required to provide their credentials to access the database.

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

    • Learn how to manage and delete database connections in a workspace and in a notebook.

    Keywords

    database, database connection, attach data, data sources, import connection details, connection details in XML, import XML

    17 November 2025
    Connect to a database using URLManage database connections in a workspace