Settings > System Setup > Configure SQL Access

Configure SQL Access

The SQL Access feature on an Exinda appliance provides access to the traffic monitoring database from any ODBC compliant application.

In order to use this feature, SQL access needs to be configured on the Exinda appliance, and an ODBC driver needs to be installed and configured on a client. ODBC aware applications running on the client will then be able to query the Exinda appliance's internal monitoring database.

This How to Guide explains how to configure the Exinda appliance to accept remote SQL connections, as well as setting up the ODBC driver on Windows 8 and Windows 10 clients.

See the following topics for more information:

Download the ODBC Driver

Set Remote SQL Options

Create ODBC Data Source on Windows XP

Create ODBC Data Source on Windows 7

View SQL Access data in Microsoft Excel

SQL Schema

flows Table

app_ids_and_names Table

urls Table

summary_applications Table

summary_hosts Table