Database Manager

General overview

Dataset manager includes tools for linking, creating, deleting databases, physical removal of dataset from database,  cloning dataset and adding/removing dataset to project. This is a summary of what you can do with this tool:

• Link database to Analyst. Click on "Link" button and insert connection parameters. 

• Edit database connection parameters click on "Edit" button and modify connection parameters. 

• Unlink database from Analyst. Click on "Unlink" button.

• Deleting database from disk. Click on " Delete DB" button. This action is non-reversible!

• Create new empty database. Click on "Create DB" button and insert basic database information.

• Filter and search datasets in db. Click on filter button and filter tool opens. You can filter datasets in database by name or by site name.  This tool is not case-sensitive.

• Remove dataset from database. Click on "Remove from DB" button and confirm. This action is non-reversible!

• Make copy of dataset. Click on "Clone" button and insert parameters necessary for the clone tool.

• Linking (unlink) dataset to project. Click on "Link to project" button ("Unlink from project" button).

Link database

Creates a new connection between Analyst and database. The database is connected to Analyst application, not to the project. If you connect a database once, you can use the database in every project.

1. Insert connection parameters. 

2.  

   1. Write the path of the database manually; an easier way is using "Browse" button and choose your database. For DB engine is supported SQLite option only. 

   2. Choose the name of the database.

   3. Write a description of the database. It is optional.

3. Test connection by clicking on "Test" button. This step is not necessary because connection testing is automatically launched during linking (step 3).

4. Click on "Link" button

Edit database connection

Edits existing connection between Analyst and database.

How to use Edit:

1. Edit connection parameters. 

2.  

   1. Edit path of database manually; an easier way is using "Browse" button and choosing your database. For DB engine is supported SQLite option only. 

   2. Edit your name of database.

   3. Write description of database. It is optional.

3. Test connection by click on "Test" button. This step is not necessary because connection testing is automatically launched during Editing (step 3). 

4. Click on "Edit" button

Create a database

If you started with a fresh installation of Analyst, your first step will be the creation of a new database and importing your datasets. The easiest way to create a new and empty Analyst database is with the option "Create DB" in Dataset/Manager. This creates a new empty database in actual Analyst format and physically save it on disk. A Database is automatically visible to Analyst application once it is created. Then your database is ready for importing datasets. 

1. Insert database parameters.

2.  

   1. Write the path of the database manually; an easier way is using "Browse" button and choosing location and file name for the new database.

   2. Choose the name of the database. The database name can be different from the file name.

   3. Write a description of the database (optional).

3. Click on "Create" button.

Link other datasets

If you have been given already existing Analyst datasets (e.g. from your colleague) you need to link them with your project. The main tool for linking datasets is Dataset/Database manager. Dataset manager allows you to browse databases, search for datasets by name and link/unlink with the project. Linking datasets consists of three simple steps:  

1. Select a database.

2. Select datasets from the list of datasets in the database (you can use the search filter and select more than one dataset.

3. Press "Link to project".

Unlinking datasets is possible from the Main window as well.

Clone dataset

"Clone" tool duplicates selected dataset with a new name to another or the same database.

How to use Clone:

1. Choose a dataset for cloning from the list of datasets before you launch Clone tool.

2. Choose the new name of the dataset and the database for storage. Optional step: If you want to create a smaller dataset (subset) than the original, you have to check "Clip by datetime" and choose the interval of the new dataset ("First date" and "Last date").

3. Click on "Clone" button

Unlinking datasets is possible from the Main window as well (right-click on dataset name).