Open topic with navigation
Adding RDBMS connections
The Surround SCM Server database and mainline databases are stored in RDBMS-based databases. The server and mainline database tables are stored in the same RDBMS database by default. If you decide to move the server database or mainlines to a different RDBMS database, you must first create an RDBMS connection.
1. Choose Tools > Administration > Server Options.
The Server Options dialog box opens.
2. Select RDBMS Connections from the General Server Options category.
3. Click Add to add a new RDBMS connection.
The Add Connection dialog box opens.
4. Select a Connection Type.
The fields displayed depend on the selected connection type.
5. Optionally enter the PostgreSQL Connection Information.
- Enter a Database Name to connect to.
- Enter the Host Name.
- Enter the Port number.
- Enter the database Username and Password.
- Enter the Minimum number of connections to specify the smallest number of connections that will be stored in the database connection pool. When the Surround SCM Server starts, it automatically creates the specified number of database connections. Increasing this number can improve performance because the server will not need to create a database connection later. If you increase this number, you may need to purchase additional licenses from the database vendor.
- The Maximum number of connections specifies the largest number of connections that will be allowed in the database connection pool. The default number of connections is 999. You should only change this number if you have a large number of mainlines and are using too many backend database connections.
6. Optionally enter the ODBC Connection Information.
- Enter a Data Source Name. Only ODBC System Data Source Name types are supported.
- Enter the connection Username and Password. If you are using Windows NT authentication, the username and password of the user who logged in to the computer running the Surround SCM Server application is used automatically.
- Enter the Minimum number of connections to specify the smallest number of connections that will be stored in the database connection pool. When the Surround SCM Server starts, it automatically creates the specified number of database connections. Increasing this number can improve performance because the server will not need to create a database connection later. If you increase this number, you may need to purchase additional licenses from the database vendor.
- The Maximum number of connections specifies the largest number of connections that will be allowed in the database connection pool. The default number of connections is 999. You should only change this number if you have a large number of mainlines and are running out of backend database connections.
7. Optionally enter the Oracle Connection Information.
- Enter the Service Name to indicate the database instance to connect to.
- Enter the Host Name.
- Enter the Port number.
- Enter the database Username and Password.
- Enter the Minimum number of connections to specify the smallest number of connections that will be stored in the database connection pool. When the Surround SCM Server starts, it automatically creates the specified number of database connections. Increasing this number can improve performance because the server will not need to create a database connection later. If you increase this number, you may need to purchase additional licenses from the database vendor.
- The Maximum number of connections specifies the largest number of connections that will be allowed in the database connection pool. The default number of connections is 999. You should only change this number if you have a large number of mainlines and are using too many backend database connections.
8. Click Test to validate the connection.
The Test Connection dialog box opens and displays the results. If the test connection fails, you can copy and paste the text into an email or text file and send it to your DBA for help.
9. Click Close to close the Test Connection dialog box.
You return to the Add Connection dialog box.
10. Click OK to add the connection.