In this document
You will learn how to set up your project database and how to link your datasets to the project.
Database manager
Each project requires a dedicated database for storing its datasets. You can create this database either during project creation or later using the Database Manager. The Database Manager also functions as a database editor, allowing you to link various datasets to the selected database. You can open it from the main menu by selecting Datasets/Database manager, clicking the 
icon in the quick navigation menu, or by clicking the “+” button above the Project datasets window.
Creating a new database
If you are starting a new project and wish to create a new database, just confirm the database creation prompt upon creating the project. An empty database will be created. Now you can start linking or importing the datasets to it.
Tip: If you do not create new database using this popup, you can create it later in the Database manager.
Creating new database in the Database manager
If you did not create the database upon starting the project, you can create it at a later stage in the Database manager. Click the ‘+’ button in the Project details window to open the database manager.
In the Database manager, proceed with the following steps:
Click the “Create DB” button to initiate the process.
In the pop-up, browse for the folder where you want to store your project database files (or create new), type its name in the File name field, and confirm.
The Name field will be auto-populated from the previous step. You can rewrite it if you still wish to change the database name. Add DB description below if required.
Create the database by clicking the “Create” button.
Your new database will appear in the database list in the Database window. Now, you can start importing your data or cloning datasets from other databases.
Linking datasets to your project
Datasets from other databases are linked to the project using the Database manager. You can link/unlink any dataset from the linked databases.
Select the database you want to link the dataset from. Available datasets will show in the “Datasets in database” window.
Select the dataset you want to link to the project.
Click the “Link to project” button to add it to the project.
Proceed this way to add as many datasets as you need from any of the available databases.
Unlinking datasets from project
If you want to unlink a dataset from a project, open the Database manager, select the dataset you want to remove from the project (Datasets in project window), and click the “Unlink from project” button to remove it from the project.
Note: Unlinked datasets are not entirely deleted; they are only unlinked from the project, but still remain in its database.
Database and dataset management tools
The Database manager lets you perform various operations/edits on your databases and datasets. You can link existing databases to the Analyst application, edit the database name or description, delete databases, or unlink datasets from your project. If you need to edit a dataset, you can use the Metadata editor.
Selected database action buttons:
Link a new database to use its dataset in your projects.
Edit the name and description of the database.
Convert the selected database to the newest Analyst format. It may not be compatible with the older Analyst versions after this step.
Unlink selected database will unlink all selected databases from the Analyst application, and you will no longer be able to use their datasets.
Unlink all invalid databases will unlink all databases that are no longer available (displayed in red text).
Optimize DB. Optimizes the database size, e.g, after a dataset removal.
Delete the database. This will permanently delete the database from your computer. Use with caution!
Remove the selected dataset from the selected database. The dataset will be permanently deleted from the database and its data will no longer be available.
Clone the selected dataset. The dataset will be cloned into another user-selected database.
Cloning datasets
You can clone any available dataset to the same or another database using the dataset clone feature. To learn more about how to use it, read the Cloning dataset guide.
Editing and repairing datasets
If a dataset contains errors or, for example, has an incomplete configuration, Analyst will highlight it visually in the Project dataset list. You can the misconfigurations in the Metadata editor. Each such dataset provides a tooltip icon to inform you about the issue. The information is also displayed at the bottom of the dataset info page.
