SQL Data Sourcing (ESM Enterprise Edition)

SQL or CSV data sourcing is easy and straightforward with the ESM Enterprise Edition. The ESM team can configure a dedicated data source for you (additional data sources available) and help you configure your firewall for secure access to our servers.

Once configured, chart data in the ESM can be automatically populated with the click of a button. The ESM uniquely allows you to separate the presentation layer from the data layer, so that business users can develop the presentation layer they would like to use, and IT can configure the data source for the visualization.

The SQL and Text drivers in the ESM support:

• Parameterized SQL queries
• One click-access for business users to update data
• Testing and preview tools for query developers
• Tab-delimited or comma-delimited text file import
• Professional data sourcing help available from Palladium