Page History

...

1. Start Tableau.
2. Select Data and then click Connect to Data Source.
3. Double click New Connection.
4. Choose MySQL Database.
5. In the Enter a Server name field, type the name of the server that is hosting the DataStore that you want to connect to.
6. Enter the port on which the DataStore is listening in the Port field (the default port for the DataStore is 3308).
7. In the Username and Password fields, enter reports and reports.
8. Click the Test Connection button.

   A message will appear confirming if Tableau was able to connect to the DataStore, as shown below:

   

9. Select the uptime database from the dropdown menu.

10. Select the Custom SQL option and enter the following statement in the text area:

    Code Block
    language sql
    select e.display_name, avg(p.cpu_usr + p.cpu_sys + p.cpu_wio),

    DATE(s.sample_time)

    from performance_sample s,

    performance_aggregate p, entity

    e

    e  where s.id = p.sample_

    id

    id  and e.entity_id = s.uptimehost_

    id

    id  and s.sample_time > "2010-11-17"  and s.sample_time < DATE_ADD("2010-11-17", INTERVAL 7 DAY)  group by DATE(s.sample_time), e.display_

    name

    name  order by DATE(s.sample_time), e.display_name

    The above example will report on the CPU workload average for all systems over the 7-day period from 2010-11-17 to 2010-11-24.

11. Click OK when finished.

...