Databases for Research - dashboard.dartmouth.edu

Databases for Research - PostgreSQL, Maria DB, MySQL, SQL Server

Log in to Dartmouth's network, either on the campus network or VPN via Global Connect (see https://services.dartmouth.edu/TDClient/1806/Portal/KB/ArticleDet?ID=66806).

Navigate a browser to https://dashboard.dartmouth.edu/.

Uploaded Image (Thumbnail)

 

In the upper right corner, click "LOGIN".

 

Log in with your Dartmouth NetID.

In the upper left, click the three lines (pancake stack) and choose "Project" (https://dashboard.dartmouth.edu/project/).

Uploaded Image (Thumbnail)

 

Click "Create Project".

Uploaded Image (Thumbnail)

 


Fill out the form to create a Free-tier project, or for larger databases, choose 'Enable billing'.

Uploaded Image (Thumbnail)

 

Select your new project from the top bar.

 

Click the "CREATE" button to create your project.

Click the three lines in the upper left (pancake stack) and Choose "Database".

Click "Instances".

Uploaded Image (Thumbnail)

 

Click "Create Instance".

Uploaded Image (Thumbnail)

 

 

Fill out the form to create a database.

Uploaded Image (Thumbnail)

 

 

It may take several minutes for the database to be created.

 

Once created, the database will be listed on the "Instances" page, https://dashboard.dartmouth.edu/database/instances/ and the "Status" column will be "READY".

To the right of the database "Name" field, place a check mark in the box, and then in the upper right, click "CONNECT".

Uploaded Image (Thumbnail)

 

A box will pop up with connection information.

 

This information can be used in a database manager, such as DBeaver, or in code to connect to the database.

Here is a snapshot of a connection from a database manager (DBeaver) to a database.

Uploaded Image (Thumbnail)

 

From the database manager, SQL tools can be used to create tables, and import and export tools are available. Right-click any table schema and choose "Import" to open up the import wizard tools.  To make data import easier, save files in comma-separated format (CSV), and use UTF-8 encoding if possible. 

 

For MySQL or MariaDB databases, there is web-based database administration tool available known as PHPMyAdmin:  https://pma.dartmouth.edu
(see https://services.dartmouth.edu/TDClient/1806/Portal/KB/ArticleDet?ID=154150)

See https://dashboard.dartmouth.edu/database/ > Other Resources > Web access to MySQL/MariaDB Database (PHPMyAdmin)

Uploaded Image (Thumbnail)

Filemaker Pro Databases: https://services.dartmouth.edu/TDClient/1806/Portal/KB/ArticleDet?ID=146742 (Securing a FileMaker database)

 

Print Article

Details

Article ID: 150826
Created
Tue 4/4/23 10:43 AM
Modified
Sun 3/10/24 10:38 PM

Related Articles (2)

This article explains how to install FileMaker Pro through the Dartmouth Software Centers on Mac and Windows computers.