You can translate the question and the replies:

Data source connection change history

Hi Team, Denodo 6.0 | JDBC Data Sources 1. If data source URI is changed, in which file is this information logged ? 2. Can this file be read in Denodo, and possibly to trigger an alert when data source connection is updated. 3. Does the file has history of data source uri updates. Please tell. Thanks.
user
11-11-2019 06:44:42 -0500

1 Answer

Hi, When a user modifies in any manner a data source effectively it is issuing an *ALTER DATA SOURCE* request. The category in charge of this logs is *com.denodo.vdp.requests* and when logged these are written in the *<DENODOHOME>/logs/vdp/vdp-requests.log* file. By default this category is set to log from ERROR level and the request issued are on INFO level so the vdp-request.log file will not show these logs unless configured to do so. In order to keep track of these actions I would configure the *com.denodo.vdp.requests* category to log INFO level messages. You can find information on how to do log the request you are looking for in the article [Configuring the Logging Engines](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/appendix/configuring_the_logging_engine/configuring_the_logging_engine). This log file can be brought to Denodo by setting it as a data source using the [Log Custom Wrapper](https://community.denodo.com/docs/html/document/denodoconnects/6.0/Denodo%20Log%20Custom%20Wrapper%20-%20User%20Manual). Then I would create a base view to extract each log. After this, if I want to configure alerts I would either configure an [SMTPAppender on the Log4j file or an SNMP trap](https://community.denodo.com/kb/view/document/Configuring%20alerts%20in%20Denodo?category=Operation) on the [Denodo Diagnostic & Monitoring Tool](https://community.denodo.com/docs/html/browse/6.0/vdp/dmt/index). Hope this helps!
Denodo Team
11-11-2019 18:18:21 -0500
You must sign in to add an answer. If you do not have an account, you can register here