As more organizations transition to the cloud it becomes harder to have a clear picture of the infrastructure usage and costs. FinOps brings financial accountability to these complex infrastructure scenarios and allows data-driven spending decisions.
Denodo is in a privileged position between clients and data infrastructure to provide meaningful information about how data flows between locations and what applications / groups create cloud costs.
Since update 8.0u20230914, it is possible to specify the cloud provider and region hosting:
Data sources (JDBC, JSON, XML, delimited files and custom) on the Metadata tab.
The client sending requests to Denodo (using infrastructureProvider and infrastructureRegion JDBC Driver Parameters).
The Denodo servers:
If you configure the monitoring from the Solution Manager and the Denodo cluster is configured on automated mode this information is automatically registered.
If you configure the monitoring from the Solution Manager and the Denodo cluster is not configured on automated mode you can manually specify the provider and region of the servers (See Creating Servers )
If you are not using the Solution Manager or you start the Denodo Monitor manually you can still specify the provider and region setting the following properties on a VQL Shell:
SET 'com.denodo.vdb.infrastructureProvider.provider'='<provider>'; SET 'com.denodo.vdb.infrastructureProvider.region'='<region>';
All these information is included in the Virtual DataPort Query Data Sources Monitor along with other useful data like the data volume transferred between each data source and the Denodo severs and from the Denodo servers to the clients.
The Denodo Dashboard provides a predefined dashboard with useful information and let users generate new custom reports. These FinOps dashboard relies on the information provided by Virtual DataPort Queries Monitor and Virtual DataPort Query Data Sources Monitor. To understand these reports and generate new ones, read the Virtual DataPort Monitors; it includes the details of the information stored by these monitors.