Hi - I am looking to start using Tableau to build dashboards. Can you let me know how you setup the Data Connection? I tried MySQL with our orionmonitor web location as the server but no luck. Thanks!
Greetings, mformica!
The type of Tableau connection depends on the database that you're using for Web Help Desk.
For example, we are running MS SQL Server...so I chose Microsoft SQL Server in the "To a Server" connection type.
I hope this helps!
Very Respectfully,
Eric Lee
mformica,
Glad you got it! I find SQL to be more robust, so I go the Custom SQL Query route to specifically define the requirements of the report.
That being said, some of the bread and butter tables will still be:
If you use a lot of custom fields, you'll also find TICKET_CUSTOM_FIELD invaluable!
Good luck!
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.