Introduction
In today’s world, financial data doesn’t just live inside databases or spreadsheets—it streams continuously from APIs, data providers, and cloud platforms. Financial analysts, portfolio managers, and decision-makers need tools that can pull this information together quickly and visualize it in ways that support better investment decisions.
One of the most powerful ways to achieve this is by using Tableau Web Data Connectors (WDCs). A WDC acts as a bridge between Tableau and web-based data sources, such as FactSet, Bloomberg, or any API that provides financial metrics. By using a WDC, you can build dashboards that fetch real-time stock and ticker data dynamically, enabling analysts to interact with live information rather than static reports.
This article revisits the original project where we built a Tableau WDC to connect with FactSet’s API for financial analysis. It also updates the approach with modern trends (as of 2025), exploring how Tableau’s WDC 3.0 framework and current best practices make these integrations more secure, scalable, and user-friendly.
1. What is a Tableau Web Data Connector (WDC)?
At its core, a Web Data Connector is a small web application—built with HTML, CSS, and JavaScript—that lets Tableau connect to data from virtually any online source. If Tableau doesn’t provide a native connector (like SQL Server or Google Analytics), you can create a WDC that communicates with REST APIs and delivers structured data to Tableau.
Here’s how it works:
User Interaction: The user inputs a parameter—such as a stock ticker symbol.
API Call: The WDC uses JavaScript to send API requests (e.g., to FactSet).
Authentication: The API checks credentials and authorizations.
Data Return: The API responds with JSON or XML data.
Transformation: The WDC parses the raw JSON/XML and converts it into a tabular format.
Tableau Ingestion: Tableau ingests the structured data, enabling dashboards and analytics.
Originally, WDCs were introduced with Tableau 9.1. They provided analysts with the ability to pull data from almost any online source. Over time, however, Tableau refined the technology—leading to WDC 3.0, which changed the way connectors are packaged, deployed, and managed.
2. The Original Project: FactSet API + Tableau
The project’s goal was straightforward yet ambitious:
Enable analysts to visualize financial metrics and broker estimates dynamically by pulling live data from FactSet’s API into Tableau dashboards.
How We Built It (Back Then)
Step 1: Input Field
The WDC provided a user interface where analysts could type in stock tickers like AAPL or GOOG.
Step 2: JavaScript & API Calls
JavaScript code was used to capture the ticker and send multiple AJAX calls to FactSet’s API endpoints.
Step 3: Authentication
FactSet validated credentials and returned authorized data in JSON format.
Step 4: Parsing Data
The WDC parsed the JSON, cleaned it, and shaped it into a tabular form.
Step 5: Tableau Dashboards
Tableau then consumed the data and populated dashboards with:
Historical price charts
Financial statements (income, balance sheet, cash flow)
Broker estimates for buy/hold/sell recommendations
Step 6: Handling CORS Issues
We encountered cross-origin resource sharing (CORS) problems. To fix this, we routed requests through a proxy server that allowed Tableau to access FactSet securely.
This setup worked beautifully. Analysts could type in a ticker and instantly view interactive dashboards that helped them decide whether to buy, hold, or sell.
3. What’s Changed in 2025?
While the original project was built on WDC 2.0, Tableau has since evolved significantly. The most important update is WDC 3.0, which modernizes how connectors are created, deployed, and authenticated.
Key Enhancements in WDC 3.0
.taco Packaging
WDCs are no longer just HTML/JS files hosted on servers.
Instead, they are packaged into a .taco file—a self-contained, signed connector package that can be distributed securely.
This makes deployment far easier and improves governance in enterprises.
Modern Authentication
WDC 3.0 supports OAuth 2.0 and OpenID, both industry standards.
This makes it easier to integrate with secure financial APIs like FactSet, where authentication needs to be seamless and robust.
Tableau Exchange Distribution
Connectors can be published on Tableau Exchange, making them easily discoverable.
Enterprises can also create private connectors tailored for internal APIs.
Developer Toolkit
Tableau introduced the TACO Toolkit, which scaffolds new connector projects, runs local simulators, and simplifies testing.
What used to take days can now be set up in minutes.
Enhanced Browser Engine
WDCs now run inside a Chromium-based engine, which supports modern JavaScript and HTML5 features.
Developers get access to Chrome DevTools for debugging.
4. Updated Project Workflow with Modern Tools
If we were to build the FactSet WDC project today, here’s how it would look:
Step 1: Create a New WDC Project
Install the TACO Toolkit via npm.
Scaffold a new connector project.
Build an interface with HTML/CSS for ticker input.
Step 2: Integrate with FactSet API
Use JavaScript fetch or axios to call FactSet endpoints.
Implement OAuth 2.0 for secure authentication.
Use cookie persistence to avoid multiple logins during a session.
Step 3: Package the Connector
Package the project into a .taco file.
Sign it digitally for secure deployment.
Step 4: Deploy the Connector
Place .taco in Tableau Desktop’s connector directory.
Register the connector in Tableau Server or Cloud (requires administrator approval and safe listing).
Step 5: Build Dashboards
Load FactSet data into Tableau using the connector.
Create dashboards for:
Price trends and volatility
Revenue and earnings growth
Analyst ratings and sentiment
Step 6: Automate Refreshes
Use Tableau Server for scheduled extracts.
In Tableau Cloud, use Tableau Bridge to maintain live updates.
5. Real-World Use Cases
Using WDCs to connect APIs like FactSet is not limited to one-off dashboards. Enterprises are now embedding these solutions in broader workflows:
Investment Banking: Real-time M&A dashboards pulling company financials for deal evaluation.
Asset Management: Portfolio dashboards tracking risk exposure by pulling sector and macroeconomic data.
Retail Investors: Personalized dashboards offering performance comparisons against benchmarks like S&P 500.
Compliance & Risk: Dashboards that pull regulatory filings from APIs and monitor exposure.
These examples highlight how WDCs transform Tableau from a visualization tool into a financial intelligence hub.
6. Lessons Learned
From both the old and modern approaches, here are key takeaways:
ChallengeSolution
Handling CORS errors
Use proxy servers or safe-listing in WDC 3.0
Securing API connections
OAuth 2.0 integration for seamless login
Complex JSON data structures
Write parsers that flatten nested fields
Deployment complexity
Use .taco packaging for easier distribution
Refresh automation
Use Tableau Bridge for Cloud or scheduled extracts on Server
7. Future Directions
Looking ahead, financial dashboards will only grow more advanced. Some trends worth watching:
AI-Powered Analytics
Combining WDCs with AI models (e.g., sentiment analysis of earnings calls) inside Tableau.
Integration with Cloud Data Warehouses
Many firms now blend API data with Snowflake or BigQuery before bringing it into Tableau.
Self-Service for Analysts
With packaged .taco connectors, non-technical analysts can fetch data without IT support.
RegTech Compliance
WDCs are increasingly used to monitor real-time compliance data from SEC, FCA, or other regulators.
8. Additional Resources
For readers who want to dive deeper:
Tableau Web Data Connector Overview
Tableau WDC 3.0 Documentation
Conclusion
The journey from the original FactSet WDC project to today’s WDC 3.0 ecosystem shows just how far data integration has come. What started as a custom-coded solution with proxy servers and manual JavaScript has now evolved into a streamlined, secure, and enterprise-ready process.
For financial analysts, the result is clear: faster access to live data, smarter dashboards, and ultimately, better investment decisions.
If you’re building dashboards for financial data today, embracing WDC 3.0 and modern practices ensures your solution isn’t just functional—it’s future-proof.
Our mission is to help organizations unlock the full potential of their data. Over the past two decades, we’ve partnered with Fortune 500 companies and mid-sized firms alike to address complex analytics challenges and deliver measurable results. Our expertise spans across Tableau consultants, Power BI Consultants, and AI Consulting, empowering businesses to transform raw information into strategic insights that drive growth and efficiency.
Top comments (0)