Tableau Architecture

Provides high level view on Tableau Architecture

1. Tableau Overview Vivek Mohan

2. Tableau & its Product Tableau Software is an American computer software company headquartered in Seattle, Washington. It produces a family of interactive data visualization products focused on business intelligence. Products - Tableau Desktop 9.3.0 : http:// www.tableau.com/products/desktop Tableau Server 9.3.0: http:// www.tableau.com/products/server Tableau Reader 9.3.0: http:// www.tableau.com/products/reader Open visualizations built in Tableau Desktop for free with Tableau Reader. Tableau Online (cloud based): http:// www.tableau.com/products/cloud-bi Scalable SaaS pricing and operations. Reliable, secure, and always up to date. Tableau-managed infrastructure. Works with Tableau Mobile to take data everywhere. Tableau Public (cloud based): https://public.tableau.com/s / Open data and explore it with Tableau Desktop Public Edition . Save and store your visualizations on your Tableau Public profile. 1GB is free. Personalize your profile and connect with other authors. Share your visualizations with the world via social media. Or embed them on a site or blog. The published vizzes are always live and interactive . Tableau Vizable (mobile app): https://vizable.tableau.com /

3. Overall Architecture

4. Overall Architecture

5. Terminology

6. Terminology

7. Gateway

8. Application Server

9. VizQL Server

10. Data Server

11. Backgrounder

12. Data Engine

13. Repository

14. Search

15. Licensing

16. Communication Flow

17. Summary

18. Licensing Consideration

19. Single Node Architecture

20. 3-Node Architecture

21. HIGH Availability

22. Network Considerations

23. Failover

24. 5 Node Architecture

25. Load

26. Performance and Scalability

27. Server Topology – Scenario 1

28. Server Topology – Scenario 2

29. Performance Guideline Every server environment is unique, and there are many variables that can impact performance . Variables affecting performance include: Hardware details, such as disk speed, memory, and processor cores The number of servers in your deployment Network traffic Usage factors such as workbook complexity, concurrent user activity, and data caching Tableau Server configuration settings, such as how many of each server process you’re running Data considerations—such as data volume, database type, and database configuration. https:// onlinehelp.tableau.com/current/server/en-us/perf.htm http:// kb.tableau.com/articles/knowledgebase/optimizing-tableau-server-performance?lang=en-us

30. Server Installation and Administration https:// onlinehelp.tableau.com/current/server/en-us/admin.htm http:// downloads.tableau.com/quickstart/server-guides/en-us/server_admin90.pdf Planning and Architecting Tableau Server: https ://www.youtube.com/watch?v=CpyrCryHr8c Tableau Server Installation: https://www.youtube.com/watch?v=59LJyXbNd2A Tableau Server Administration: https://www.youtube.com/watch?v=34WGBP221aw

31. Tabadmin & Tabcmd Tabadmin You can perform certain administrative tasks and change Tableau Server configuration settings using the tabadmin command line tool. It installs with Tableau Server by default https:// onlinehelp.tableau.com/current/server/en-us/reconfig_tabadmin.htm http://bnreddybi.blogspot.in/2015/08/configure-with-tabadmin-set-options.html Tabcmd The tabcmd utility is one of the two command line tools that installs with Tableau Server (the other is tabadmin ). The commands provided through tabcmd can help you automate common tasks, such as publishing workbooks in batches and administering users and groups. The tabcmd utility installs in the Tableau Server bin folder (C:\Program Files\Tableau Server\9.3\bin), but you can install and run tabcmd on another machine as well. https://onlinehelp.tableau.com/current/server/en-us/help.htm#tabcmd.htm%3FTocPath%3DCommand%2520Line%2520Utilities%7Ctabcmd%7C_____

32. Optimizing Queries – Two Step Process https:// www.youtube.com/watch?v=ZIlxe1UEJo8

33. Optimizing Queries – Principles

34. Useful Links Tableau Server Installation: https:// www.youtube.com/watch?v=59LJyXbNd2A Tableau Server Administration: https:// www.youtube.com/watch?v=34WGBP221aw Tableau Architecture Part 1- https:// www.youtube.com/watch?v=v8_iLBdGlm4 Tableau Architecture Part 2- https:// www.youtube.com/watch?v=tLlETQJjFVg Planning and Architecting Tableau Server: https:// www.youtube.com/watch?v=CpyrCryHr8c Server Log Files: http:// onlinehelp.tableau.com/current/server/en-us/logs_loc.htm Server Processes: http:// onlinehelp.tableau.com/current/server/en-us/processes.htm Performance: http://onlinehelp.tableau.com/current/server/en-us/help.htm#perf_guidelines.htm%3FTocPath%3DAdministrator%2520Guide%7CPerformance%7C_____ 1