Connecting to a Database using MetamorphoSys.
This tutorial assumes that you have already created a database,
and loaded a subset of UMLS data into that database.
Please refer to the documentation and our other tutorials
explaining how to accomplish the above steps.
To begin configuring your database connection,
load MetamorphoSys tool by running one of the provided run scripts.
For example, on a Windows PC you would need to execute the run.bat file.
This will open the MetamorphoSys interface.
First, click on the “Browse my subset” button to open the RRF Browser window.
The dialog box will advise you to open an existing valid subset by selecting
Open Subset from the File menu.
Click OK to close the dialog box and select the Open Subset sub-menu to open the
“Chose Subset to Browse” window.
In this example, we will use an Oracle database instance of a dataset.
Therefore, select the Oracle tab and click into the Source box.
This opens a “Database Connection Parameters” window.
Our database connection uses the Transparent Network Substrate, or TNS, protocol.
Hence, I will select the “Use TNS Service” check box,
enter the path to the tnsnames.ora file,
enter the TNS name, and click OK.
The valid source name now appears in the Source box.
Click OK to switch back to the RRF Browser.
Enter the user name and password when prompted.
Now you can browse your UMLS subset.
This completes our tutorial.
Use the Help link in the right upper corner to access RRF Browser documentation
and other useful information.
Thank you for watching!