The external database can be used for customized reporting. For custom reports, you
can access the SMS database directly or replicate the SMS to your external server.
If you require data that the SMS reports do not routinely provide, you can set up
an SMS External Database with a reporting tool of your choice.
The SMS supports the following database options:
- External access - direct access to the database.
- External replication - remote replication of the database, which provides a copy of the database that can be edited, backed up, or used for offloading report functions. Data that you access remotely is read-only and cannot be changed.
External access
- Set up the access service to allow an external database tool to access data on the SMS. Do this before you configure the external application.
- Reboot the SMS to enable or disable this service.
External replication
- Set up the replication service to allow an external database server to replicate data from the SMS.
- Reboot the SMS to enable or disable this service.