NetSuite provides SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) for external reporting and data analysis. Below are some key tips to ensure a smooth and efficient ODBC connection.
Since SuiteAnalytics Connect runs on a read-only replicated database, optimizing queries is important.
✅ Use Saved Searches for Large Data Sets
- NetSuite’s ODBC database is not real-time. For large datasets, use Saved Searches to reduce load.
✅ Use Table Indexes
- Querying indexed fields (
internalid,recordtype,datecreated) improves speed.
✅ Limit Data Retrieval
Instead of:
SELECT * FROM transactions;
Use:
SELECT internalid, tranid, amount, datecreated
FROM transactions
WHERE datecreated >= {ts '2024-01-01 00:00:00'};
✅ Avoid Using Wildcards (%) in WHERE Clauses
Instead of:
SELECT * FROM customer WHERE name LIKE '%John%';
Use:
SELECT * FROM customer WHERE name LIKE 'John%';
This reduces the number of scanned records.