Datalore 2024.5 Help

Connect to a database by importing connection details

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

Procedure

  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 to workspace resources or attach it to a notebook.

    1. On the Home page, select the workspace to which you want to add a database connection.

    2. From the left-hand menu of the selected workspace, select Data and switch to the Databases tab. This will open the list of all workspace database connections.

    3. On the Databases tab, click the Add button in the upper right corner.

      Databases menu
    1. Open the Attached data tool from the left-hand sidebar.

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

    3. At the bottom of the tab, click New database.

      Creating connection from notebook
  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.

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.

  • 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.

Keywords

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

Last modified: 30 October 2024