Case Study: Transport for NSW achieves code-free REST API delivery in under an hour with Etlworks

Transport for NSW builds code-free REST API in under an hour with Etlworks

Transport for NSW, a government agency, needed to create a REST API to aggregate data from a locally hosted SQL Server database, Google Analytics, Facebook, and third-party web services for Tableau visualizations. Traditional methods were too time-consuming and resource-intensive, so they turned to Etlworks for a solution.

Using Etlworks' no-code platform, the agency built a fully functional REST API in less than an hour. This solution integrated all their data sources and transformed the information into JSONs for Tableau. The project resulted in massive time savings, allowed new data sources to be added in minutes, and provided significant cost efficiency by eliminating manual coding.

Transport for NSW