- Get a Compute Canada account
- Opt into the Niagara & Mist service
- Upload an SSH key to CCDB
- Request WoS or CIPO database access from SciNet
These steps only need to be completed once to gain access, and should normally only take a few days at most to be approved.
Please visit the Compute Canada Database (CCDB) website and apply for an account (takes a day or two to approve).
Note: Students and postdocs need to be sponsored by their supervisor, who would need to already have a Compute Canada account (or create one first). In case this is not feasible, you can ask to be sponsored by a librarian at the Map & Data Library. To make these arrangements, please contact the Map & Data Library for assistance.
After the Compute Canada account is approved, you should opt in to the Niagara & Mist service on the CCDB website (or use this direct link). The opt-in will be approved manually after one or two days, which will give you access to the Niagara supercomputer and other SciNet systems, as long as the SSH key has been uploaded to the CCDB website (see next step).
Next, locate the Manage SSH Keys option on you account page on the CCDB website (or use this direct link) and upload your public SSH key. Instructions on creating SSH key pairs from the SciNet Wiki can help you with this process. This wiki also contains pages with more information on creating SSH key pairs specifically on a Windows machine, or on Mac or Linux machines. The Map & Data Library also provides a quick start tutorial for creating SSH key pairs on a Mac, if you need more help.
Finally, please send an email to SciNet's support team and let them know you would like access to the UofT-WoS database or the UofT-CIPO database. Please use your University of Toronto email address so that staff can easily identify your account. After that is approved, you will be able to connect an SQL client to these databases on the SciNet database server node (idb1)
- The Web of Science database is called 'wos'
- The Canadian Intellectual Patent Office (CIPO) database is called 'cipo'
Please note that if you already have access to WoS, CIPO access will be enabled by default. This does not apply in reverse - if you already have access to CIPO, you will still need to make a separate request for access to WoS. This is due to the different licenses that apply to these collections.
If working with object-relational databases, SQL, and high performance computing environments are new to you, tutorials for both WoS and CIPO are available to help you get started:
- WoS tutorial for Windows users or tutorial for Mac users
- CIPO tutorial for Windows users or tutorial for Mac users
If you have any question, feel free to contact us.