)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Migrating Excel ODBC queries from legacy ERP to NetSuite format is complex due to different data models, field naming convention changes, and SQL syntax variations. Converting queries one-by-one often introduces errors and loses custom business logic built over years.
Here’s a migration approach that’s often easier than converting existing ODBC queries, plus how to reduce migration time by 60-70% compared to SQL query translation.
Rebuild reports faster with Coefficient ‘s visual migration approach
Instead of translating SQL queries from legacy ERP to NetSuite format, users can rebuild reports using visual tools that eliminate syntax conversion errors. This approach focuses on business requirements rather than technical implementation details.
The key advantage is faster implementation through visual selection, better optimization with NetSuite-native approaches, and maintainable solutions that team members can modify without SQL knowledge.
How to make it work
Step 1. Document existing report requirements, not SQL code.
List what data each Excel report needs, identify the business purpose, note required fields and filters, and document refresh frequency requirements. Avoid getting stuck on technical implementation details.
Step 2. Rebuild using NetSuite Records & Lists.
Select equivalent NetSuite data using visual field selection, apply filters with point-and-click interface, and leverage saved searches for complex logic instead of translating SQL syntax.
Step 3. Preserve Excel formulas and calculations.
Import base NetSuite data and maintain existing Excel SUMIF, VLOOKUP, and pivot table logic. Use Excel’s familiar functions instead of converting complex SQL aggregations.
Step 4. Set up automated refresh scheduling.
Replace VBA macro automation with cloud-based scheduling. Set appropriate refresh timing and test parallel with legacy system before decommissioning old queries.
Faster migration with better long-term maintenance
This approach typically reduces migration time significantly while creating more maintainable solutions than converted SQL queries. You get automated refresh scheduling, better error handling, and consistent performance without ODBC overhead. Start your migration with visual tools that eliminate SQL conversion complexity.
