You can translate the question and the replies:

Teradata as Cache Database and Configuring Monitoring Tool for Teradata

**Teradata as cache Database:** Does Denodo supports Teradata as caching database ? If yes then is it works as other RDBMS system does ? I wanted to confirm if I setup Teradata as cache database, element delegation such as function, subquery, etc, should works as how it works with other RDBMS system such like Oracle, MSSQL etc. **Denodo Monitor configratuin with Teradata:** I don't see any configuration setting for Teradata in monitor configuration parameter property nor request_notifcation or cache_notification tables creation sql for teradata. So, is it possible to configure Denodo monitor with teradata? If yes, how do I configure "monitor configuration paramter property" file for teradata? Any help will be greatly appreciated.

2 Answers

Hi, 1.Yes, VDP allows storing of cache data in Teradata 12,13,14 and 15. You must download the driver from the vendor’s website, because it is not included with Virtual DataPort. Copy the jar file(s) of the driver to <Denodo_Home>/extensions/thirdparty/lib directory and restart the VDP server. Once you do this, it will function like other RDBMS. You can read about this in the Cache Module Section of the Administration Guide. 2. I never tested it but you can configure the denodo-monitor to store the output in a JDBC database. Although the configuration for a Teradata database is not included in the properties file, you can try manually setting the parameters within by mimicking the configuration for the other databases. The sql script for Teradata is not included by default, so you will need to manually write a script in order to create the tables with the appropriate structure in the desired Teradata database. Also, you will need to copy the JDBC driver of the database to the <DENODO_MONITOR>/lib folder. You can find these instructions listed inside the .properties file under “Settings to store the output of the Virtual DataPort cache monitor in a database”. Try out the configuration and let the community know if it works for you! Hope this helps!
Denodo Team
18-08-2016 13:09:16 -0400
Hello Team, Any futher information how we had the Denodo-VDP Cache was setup on Teradata ? It would be useful to the community -- Lokesh
24-04-2017 16:56:47 -0400
You must sign in to add an answer. If you do not have an account, you can register here