Connect to a database
Use Datalore's New database connection dialog to create and manage database connections.
- Connect to a database
You have several options for adding a database connection to a notebook or a workspace.
Configure a database connection
You use the New database connection dialog, where you select a database type and provide relevant details.
Connect to a database using URL
For a new database connection, you provide relevant details by from a pre-built URL.
Connect to a database by importing connection details
For a new database connection, you provide relevant details in XML format.
- Attaching database connections from the workspace
Attach a database connection from the workspace
The procedure explains how to attach a database connection from a workspace to one of its notebooks.
- Managing database connections attached to a notebook
Manage database connections in a notebook
The procedures explain how to manage database connections that you have attached to a notebook. This is done in the editor when working on this particular notebook.
- Managing database connections as workspace resources
Manage database connections in a workspace
The procedures explain how to manage database connections on the level of workspace resources. You perform the steps in a selected workspace from the Home page.
Connect to an SQLite database
Datalore supports connecting to SQLite databases that you add as files. Refer to this procedure for more details about uploading files.
Query databases
Regardless of the type of a connected database, you query it using SQL cells.