Connect to a database using URL
note
The procedure covers both basic cases of creating a database connection:
For a notebook
You want to create a database connection for a particular notebook you are working in right now. This will automatically attach the new connection to the notebook, which enables you to immediately retrieve and process its data in your code.
For a workspace
You have a database that you want to connect to one of your workspaces. As a workspace resource, you can later attach this connection to any notebook from the respective workspace.
In both cases, you will use Datalore's New database connection dialog, and the only difference between the two scenarios is accessing this interface.
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.
To add to workspaceTo create for notebookOn the Home page, select the workspace to which you want to add a database connection.
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.
On the Databases tab, click the Add button in the upper right corner.
In the New database connection dialog, switch to the Enter URL tab.
Provide the URL in the Connection URL text field and click the Next button.
This will open the connection dialog for the respective database type with all the fields pre-filled.
tip
You can pass additional parameters when providing the URL. For example, add
&SSL=trueto the URL string to enable SSL.
Click the Test connection button at the bottom of the dialog.
Once successfully tested, click the Create and close button.
Thanks for your feedback!