welcome [tc18.tableau.com] · 2020-01-06 · tableau / customer consulting. my office photo used...
TRANSCRIPT
![Page 1: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/1.jpg)
![Page 2: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/2.jpg)
Welcome
![Page 3: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/3.jpg)
Extract API: Build sophisticated data models with the Extract API
# T C 1 8
Justin Craycraft
Senior Sales Consultant
Tableau / Customer Consulting
![Page 4: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/4.jpg)
My Office
Photo Used with permission
![Page 5: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/5.jpg)
Agenda
1) Tableau Platform
2) Data Connectivity API’s
• Web Data Connector
• Extract API
3) Extract API
• Use-cases
• Demonstration
• Concept and Code Review
• How-to get started
• Resources
![Page 6: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/6.jpg)
Tableau Platform
![Page 7: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/7.jpg)
Automation
Extensions
Embedded Analytics
Data Connectivity
Data Science
Tableau Platform
Inte
gra
tion
s
Enabling Integrations for Developers
![Page 8: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/8.jpg)
Data Connectivity APIs
![Page 9: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/9.jpg)
Web Data Connector
![Page 10: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/10.jpg)
Extract API
![Page 11: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/11.jpg)
Summary of data connectivity
Native Tableau Connectors
ODBC Connections
Extract API Web Data Connector
Use Case Live or Extracts ODBC-compliant data sources
Any data sources w/o native connectors
Web data only
Output Live or Hyper Live or Hyper Hyper only Hyper only
Language n/a SQL C, C++, Java, Python
JavaScript + HTML
Publishing & Refreshing
Tableau Server Tableau Server Managed outside Tableau Server
Tableau Server
![Page 12: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/12.jpg)
Extract API: TCH
![Page 13: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/13.jpg)
The Tableau Platform
• Analytics
• Collaboration
• Content Discovery
• Governance
• Data prep
• Data access
Hyper
Data Code
![Page 14: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/14.jpg)
• Event-driven automation
• Connect to 3rd party App data
• Net-new data model
• Publish (using REST API)
Hyper
![Page 15: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/15.jpg)
Extract API: What you need to get started
![Page 16: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/16.jpg)
What you need to get started
• Data
• Programming skillz in C, C++, Java, or Python
• Tableau API
• IDE
![Page 17: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/17.jpg)
Extract API: Demo #1
![Page 18: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/18.jpg)
Getting started with the Python Sample
1) Online Help
2) Download the API
3) Optional – Setup a Virtual Environment (Python)
4) setup.py
5) python tableauSDKSample.py --build --filename your_data.hyper
![Page 19: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/19.jpg)
Extract API Steps
1) Initialize the API
2) Define the Schema
3) Add the Data (static)
4) Save the Extract
5) Close the API
![Page 20: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/20.jpg)
Extract API: Demo #2
![Page 21: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/21.jpg)
Extract API Steps
1) Initialize the API
2) Define the Schema
3) Add the Data (dynamic)
1) Connect to CSV file
2) Add each row of data in the file to the Extract
4) Save the Extract
5) Close the API
![Page 22: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/22.jpg)
Extract API: Netflix
![Page 23: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/23.jpg)
![Page 24: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/24.jpg)
![Page 25: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/25.jpg)
![Page 26: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/26.jpg)
• Scalability
• Big data
• Isolate Compute
• Accessibility
• Allow users to request Data Extracts
• Agnostic Framework
• Easily talk to different database query engines
Tableau Data Extract
![Page 27: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/27.jpg)
Bonus: Demo #3
![Page 28: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/28.jpg)
REST API Steps to Publish Extract
1) Authenticate to REST API
2) Get the ID’s for Site & Project
3) Publish
1) If >64 MB, break apart file and send in 5 MB chunks
4) Sign Out of the REST API
![Page 29: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/29.jpg)
REST API Steps to Publish Extract
1) POST api/api-version/auth/signin
2) GET /api/api-version/sites/site-id/datasources
3) POST /api/api-version/sites/site-id/datasources?overwrite=overwrite-flag
4) POST /api/api-version/auth/signout
![Page 30: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/30.jpg)
Extract API: What’s coming?
![Page 31: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/31.jpg)
Extract API Roadmap
1) Support for Multi-Table extract in 18.3
2) Improvements to Creation Speed
3) Better support for CSV Import
![Page 32: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/32.jpg)
Extract API: How-to get started
![Page 33: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/33.jpg)
#DataDev Resources
TC18 Developer Track Contenthttp://tabsoft.co/tcdevtrack
Tableau Developer Programhttp://tableau.com/developer
Free environment for development
Early access to info and APIs
Tableau on GitHubhttp://github.com/tableau
![Page 34: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/34.jpg)
Please complete the
session survey from the
Session Details screen
in your TC18 app
![Page 36: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/36.jpg)
#DataDev Resources
TC18 Developer Track Contenthttp://tabsoft.co/tcdevtrack
Tableau Developer Programhttp://tableau.com/developer
Free environment for development
Early access to info and APIs
Tableau on GitHubhttp://github.com/tableau
![Page 37: Welcome [tc18.tableau.com] · 2020-01-06 · Tableau / Customer Consulting. My Office Photo Used with permission. Agenda 1) Tableau Platform 2) Data Connectivity API’s • Web Data](https://reader035.vdocuments.us/reader035/viewer/2022081521/5ec557a013b08355f20a9f7a/html5/thumbnails/37.jpg)
tc18.tableau.com