You can translate the question and the replies:

Outgoing Connections from Denodo

Hello experts, We have been told that there are several million connections open from Denodo to an FTP datasource/baseview. Where can we view these connections in Denodo? The getsessions() seems to display just the incoming connections/queries. Please advise. Many thanks.
user
11-10-2022 12:47:13 -0400
code

1 Answer

Hello, I understand that you have a FTP datasource and its baseview in Denodo. You have been informed that there are several million active connections open from Denodo to this database and you would like to view these active connections in Denodo. Denodo provides following two ways to access this information : 1. Using the Denodo Monitor : It’s the tool integrated in the Denodo Platform to log information about the Denod Servers (VDP, ITPilot, Scheduler). You can refer to the following documents : [Denodo Monitor](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/denodo_monitor) to know in detail about this tool, [Configuring the Denodo Monitor](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/configuring_the_denodo_monitor#configuring-the-denodo-monitor) and [Launching the Denodo Monitor](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/launching_the_denodo_monitor#launching-the-denodo-monitor) to understand how to set it up and start it to access information. *For example, once the VDP server is configured for monitoring in the Denodo Monitor, you can go to its dashboard’s **Data Sources** tab and view the information about the active connections for specific data sources.* 1. Using the Java Management Extensions(JMX) standard : It provides information about the Denodo Virtual DataPort(VDP) server like active and inactive connections, information about the access to cache and its configuration, access to each data source etc. You can refer to the following documents : [Monitoring with JMX Agent](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/monitoring_the_virtual_dataport_server/monitoring_with_a_java_management_extensions_jmx_agent/monitoring_with_a_java_management_extensions_jmx_agent#monitoring-with-a-java-management-extensions-jmx-agent) to know more about this monitoring method and how to set it up, [Using Java TM Visual VM](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/monitoring_the_virtual_dataport_server/monitoring_with_a_java_management_extensions_jmx_agent/using_javatm_visualvm) to know how to set it up and [Information on Data Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/monitoring_the_virtual_dataport_server/monitoring_with_a_java_management_extensions_jmx_agent/information_on_data_sources) to know about MBeans related to data sources. *For example, once VisualVM is installed and JMX connection is established with the Denodo VDP server, you will navigate to the c**om.denodo.vdb.management.mbeans > DataSourceManagementInfo**. Double click the data source you want the information about and you will see all the required information about the pool of connections, number of requests to that specific data source and last ping invocation.* Hope this helps!
Denodo Team
12-10-2022 13:55:14 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here