Background:

Netsol, a leader in asset finance software for car financing and leasing, faced a challenge. Their clients, often lacking strong SQL expertise, relied on technical teams to generate reports and data queries. This created bottlenecks and slowed down access to crucial business insights. Netsol sought a solution to empower their everyday users to independently retrieve data using natural language, eliminating the need for complex SQL queries.

Our Solution:

We developed a custom Text-to-SQL framework seamlessly integrated with Netsol’s legacy ASCENT system. This user-friendly interface allows non-technical users to formulate data queries in plain English. The system translates these queries into optimized SQL, retrieves the relevant information from the ASCENT database, and presents the results in a clear and concise format.

Key Benefits:

  • Increased User Autonomy: Non-technical users can now fetch data independently, reducing reliance on IT teams and speeding up workflows.
  • Improved Efficiency: Streamlined data retrieval eliminates the need for writing complex SQL queries, saving time and resources.
  • Enhanced Business Insights: Faster access to data empowers users to make informed decisions based on real-time information.
  • Simplified Reporting: Users can easily generate reports without technical barriers, improving operational transparency.
  • Reduced Training Burden: The intuitive interface eliminates the need for extensive SQL training for everyday users.
  • Seamless Integration: The Text-to-SQL framework seamlessly integrates with existing ASCENT infrastructure, minimizing disruption and maximizing ROI.

Technical Details:

  • Tokenize and Encode text query and database schema items such as table and column names, and their foreign-key relationships using an off-the-shelf T5 tokenizer and a pretrained RoBERTa model.
  • Train a Schema Item Classifier for the selection of relevant tables and columns
  • Generate the SQL Query skeleton and fill in the column and table names using a T5 decoder.

Outcome:

The Text-to-SQL framework empowered Netsol’s users to unlock the power of their data independently. This resulted in increased efficiency, improved access to business insights, and a more empowered user base. This successful project demonstrates our expertise in developing innovative AI/ML solutions that bridge the gap between technical capabilities and real-world business needs.