By default, the Connector Manager uses a Java-based H2 database to store its configuration and other data. However, there may be a need to optimize performance by using an external database.
When requesting a database for use from your DBA, a size estimate can be obtained using the guidelines found here:
The schema declarations can be found in the appropriate Java properties file:
Please take into consideration the following steps as guidelines on setting up your Connector Manager to use an external database.
- Install a database server.
- The currently supported external database types are Oracle Database and Microsoft SQL Server.
- Create a blank database “
dbname”with no tables to be used by the Connector Manager.
- There is no schema template to import nor are there any queries to run. The database schema is created by the connector.
- Create a user
unamewith full access to the database
- Install the Connector Manager.
- Configure the connector to connect to the database
dbname. Modify the file
# Microsoft SQL Server JDBC DataSource configuration.
- Edit these three properties to provide the connection information. Escape any special characters. For example, if the user name is "
domain\user", type in "
The password needs to be encrypted and encoded.
# SpiConstants.DatabaseType constants.
- Uncomment the following line and set the appropriate value.
- Obtain the proper JDBC driver from the database vendor: Microsoft or Oracle. Google does not have the right to distribute the driver. Copy the single appropriate JDBC driver JAR into directory:
- Register the Connector Manager in the GSA Admin Console (if not already registered).
- Start (or restart) the Connector Manager service.