Case Study: Transport for NSW Creates REST API for Tableau with Etlworks

Government Agency Saves Time and Money by Building Code-Free REST API for Tableau Using Etlworks.

Introduction

Local government agency Transport for NSW needed to create a REST API to aggregate data from a locally hosted SQL Server database, Google Analytics, Facebook, and third-party web services, providing enriched JSONs for Tableau visualizations. Traditional methods were too time-consuming and resource-intensive. With Etlworks, they built a working API in less than an hour and now add new data sources in minutes.

The Challenge

The agency faced several obstacles:

• Aggregating data from diverse sources like SQL Server, Google Analytics, Facebook, and web services.

• Transforming the data into a JSON format suitable for Tableau, without extensive coding.

• Implementing a solution that allowed for quick addition of new data sources to adapt to evolving requirements.

• Finding a cost-effective and time-efficient approach that met the agency’s constraints.

Existing tools required extensive manual coding, making the process impractical and time-consuming.

Why Etlworks

Etlworks stood out as the perfect choice due to its no-code approach, ease of use, and powerful REST API capabilities. The platform enabled the agency to integrate multiple data sources and create a fully functional API quickly, with the flexibility to scale and adapt as needed.

The Solution

Using Etlworks, the agency developed a REST API that:

Connected to Diverse Sources: Integrated a locally hosted SQL Server database, Google Analytics, Facebook, and third-party web services seamlessly.

Enriched Data for Tableau: Transformed raw data into JSONs ready for Tableau visualizations.

No-Code Simplicity: The entire process was completed using Etlworks’ intuitive drag-and-drop interface, eliminating the need for coding.

Rapid Deployment: Delivered a fully functional API in less than an hour.

Future-Proof Design: Made it possible to add new data sources in a matter of minutes by leveraging Etlworks’ flexible configuration options.

Results

Time Savings: The API was created and deployed in under an hour, dramatically reducing development time.

Ongoing Efficiency: New data sources can now be added to the API in just minutes, without requiring reconfiguration of the pipeline.

Cost Efficiency: By avoiding manual coding and lengthy development cycles, the agency saved significant resources.

Ease of Maintenance: The no-code setup made the API easy to modify and scale as needs evolved.

Customer Quote

“With Etlworks, we built a highly efficient REST API that seamlessly aggregates data from a locally hosted SQL Server database, Google Analytics, Facebook, and third-party web services, enriches it, and delivers JSONs directly to our Tableau instance. The entire process was completely code-free and took less than an hour to complete. Now, we can add new data sources in minutes, saving us substantial time and effort.”

Key Takeaways

Code-Free Simplicity: Etlworks made building a REST API fast and effortless with its no-code platform.

Seamless Data Integration: Unified data from SQL Server, Google Analytics, Facebook, and web services into a single API.

Rapid Deployment: A working API was live in less than an hour, with the flexibility to add new data sources in minutes.

Ready to tackle your most complex data challenges? Discover how Etlworks can transform your data integration workflows. Start your free trial today or request a demo.