Considerations for selecting the database for the Infrastructure Management Server
The TrueSight Infrastructure Management Server is supported with one of the two database options. You can install the embedded SAP SQL Anywhere database that comes with the product, or you can leverage an Oracle database that you provide.
SAP SQL Anywhere database selection criteria
Use the SAP SQL Anywhere database in the following situations:
- When an Oracle database license is not available
- When an Oracle DBA is not available
- When robust database availability is not required
- In small and medium environments in which Oracle is not available
If you choose the SAP SQL Anywhere option, the SAP SQL Anywhere database is installed with the TrueSight Infrastructure Management Server on the same host with the application server and web server components. The SAP SQL Anywhere database cannot be installed on a separate server.
Oracle database selection criteria
Use the Oracle database in the following situations:
- In large environments
- When an Oracle license is already available
- If you have onsite Oracle DBA expertise
- When Oracle is a standard database platform used in the environment
- When robust database availability is required
If you choose the Oracle database option you must provide an Oracle instance. The Oracle instance must be installed on a host separate from the TrueSight Infrastructure Management Server. For further information, see Considerations-and-best-practices-for-deploying-the-Oracle-database.