After January 31 for ITAP10 users and May 31 for ITWP10/ITFP10 users, access to the Oracle databases will be revoked and all connections will be made through a Denodo connection. Because Hyperion is no longer supported by the vendor or DIT, it is not compatible with Denodo and therefore will no longer work for ad-hoc querying.
DIT supports Tableau and SAS Enterprise Guide for your ad-hoc querying needs. Denodo also comes with a built-in query editor, and tools such as DbVisualizer have been tested successfully with Denodo connections as well. Learn how to get access to Denodo through DbVisualizer through our Configure Access to Denodo article.
No, you will not need to change integration connections to the Oracle databases. Service accounts will be transferred to the new Oracle database instances.
In an effort to maintain a secure and supported database platform, it is imperative that we upgrade and patch our infrastructure. Our current infrastructure is coming up at its end of life and will be unsupported by the vendor by early summer 2022. With this in mind, we must modernize our infrastructure to allow it to not only be upgraded to the next version but to also position ourselves to have regular upgrades and patches in as automated a fashion as possible.
Unfortunately, this means that some legacy applications, such as Hyperion, will no longer work like this software, itself, is past the end of life with its vendor and is no longer being patched or supported.
Datasets that have been saved locally on your machine should remain accessible once we modernize our infrastructure. It is also expected that you will be able to view any queries written. However, you will no longer be able to execute queries against the DIT-supported Oracle databases using Hyperion.
Yes, VPN is required.
You are expected to complete the Denodo ad-hoc query request form
SAS administrators will point existing references to Oracle tables to point to Denodo, minimizing the need for users to make manual changes to their existing queries in SAS Enterprise Guide. If users have used the Folder view to build their projects, they will need to switch to using the Server view. Documentation for the Oracle-Denodo Migration for SAS Enterprise Guide
Oracle data connections in Tableau will need to be manually converted to Denodo connections in Tableau Desktop by report authors. Documentation for the Oracle-Denodo Migration for Tableau