Notes for the update of the Moore data records

This set of notes is for setting up Studio 3T for mongo and the Moore date update task

Set up mongo db with Studio 3T

Direct Connection Settings

The direct connection settings uses the SSH key

1. Open Studio 3T
2. Click on the connections button. A dialog box appears with the Connection Manager
3. Click on the “New connection: button
4. Connection Settings
5. Using Cohereone as an example, fill out these values
• Server tab
• Server: localhost
• Port: 27017
• SSH tab
• SSH Address: cohereone.bettrdata.io
• SSH User name: ec2-user
• Private Key: /home/bettrdatarob/.ssh/id_rsa

My private key is not protected by a passphrase: checked

Port Forward Method

You will need to set a port forward to an instance

Example

ssh -L 27018:localhost:27017 moore-dev

NOTE

Be careful that you know which server it is being port forwarded to. You could end up making changes on the incorrect data!

Connection Settings

This changes the settings a bit

• Server tab
• Server: localhost
• Port: 27018
• SSH tab
• No changes from default