Adding a database location
To add a database location to the server, the server license should include the add-on CLC Bioinformatics Database.
Before adding a database location, you need to set up the database itself. This is described in Database setup.
To set up a database location on the CLC Server,
- Open a web browser and navigate to the web administrative interface.
- Go to the Admin tab and open the Main configuration section.
- Under the Database locations heading, click the Add New Database Location button (figure 3.2). Enter the required information about host, port and type of database. A connection string is generated from this. A custom connection string can be entered instead. The user name and password refers to the user role on your Database Management System (DBMS), see Database set-up.
Figure 3.2: Add new database location.There are two versions of Oracle in the drop down list of database types. One is the traditional one, which uses the SID style (e.g.
jdbc:oracle:thin:@[HOST][:PORT]:SID). The other uses the thin-style service name (e.g.jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE). - Click the Save Configuration button to save the configuration.
The added database location should now appear in the Navigation Area in the left hand side of the window.