Add a JDBC data source for dashboards

Specify the JDBC data source to be used within data feeds.

Prerequisite

Procedure

  1. Click Application launcher Application launcher > Administration Administration. The Administration opens with the Configuration Configuration view.

  2. Click Dashboards.

  3. Click Connections.

  4. Select JDBC data source from the list.

  5. Click Add Add. The Add property dialog opens.

  6. Enter the name of the JDBC data source.

  7. Select the JDBC driver.

  8. Enter the URL of the JDBC driver.

  9. Enter the user name of the user who can access the data.

  10. Enter the password of the user who can access the data.

  11. Enter the initial size.

  12. Enter the maximum active time.

  13. Enter the maximum wait time.

  14. Enter the maximum idle time.

  15. Enable the pool prepared statement, if required.

  16. Enter the validation query.

  17. Enter the validation timeout.

  18. Enter the number of eviction runs.

  19. Enter the number of tests per run.

  20. Enter the maximum evictable idle time.

  21. Click Save.

This JDBC data source can be used for your data feeds.