Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
Important Update: NetSuite SuiteQL Schema Changes
Action Required: Recent NetSuite update affects customers using NetSuite SuiteQL schema. SuiteTalk schema users are not impacted.
Date Entered: 06/30/2025 Last Updated: 06/27/2025
Action Required: This update affects customers using NetSuite SuiteQL schema. SuiteTalk schema users are not impacted.
Summary
We are notifying CData customers of critical changes to NetSuite SuiteQL Schema due to NetSuite's migration from netsuite.com to netsuite2.com. Multiple objects have been deprecated, potentially affecting your data connectivity operations.
- Impact Level: High
- Affected Schema: SuiteQL only
- Unaffected Schema: SuiteTalk
What We Have Observed
NetSuite is transitioning from netsuite.com to netsuite2.com, resulting in significant changes to the SuiteQL schema. During this migration, NetSuite has deprecated numerous objects, causing instability for applications using SuiteQL.
Known Error Messages
If your NetSuite instance has been migrated, you may encounter the following errors when querying affected objects using CData Drivers/Connectors:
- ERROR: Unable to retrieve columns for table [TABLENAME].
- ERROR: [INVALID_PARAMETER] Invalid search query. Detailed unprocessed description follows. Search error occurred: Invalid or unsupported search. Bad Request.
Who Is Affected
You ARE affected if:
- You use SuiteQL schema
- You see any of the error messages listed above
- Your NetSuite instance has migrated to netsuite2.com
You are NOT affected if:
- You use SuiteTalk schema exclusively
- You haven't experienced any of the listed errors
Actions That Can Be Taken
- When migrating from Netsuite.com to Netsuite2.com, Netsuite recommends considering the differences in role-based access, differences in record & field names & availability of record & field types. Refer to Oracle NetSuite's documentation: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_164258362224.html#subsect_162885561735
- Some objects have alternative ways to query. Examples include:
- Invoice can be queried via: SELECT * FROM Transactions WHERE RecordType='Invoice' (note: potentially less performant)
- TimeEntry table data is available via the TimeBill table
- Switch to SuiteTalk Schema (not recommended):
- Unaffected by the migration
- Documentation: CData JDBC Driver for NetSuite - SuiteTalk Data Model
- Note: SuiteTalk (SOAP) APIs are legacy. Oracle NetSuite does not recommend them for new integrations.
- Need support on object migration?
- Email: [email protected]
- Include your product version and error messages
Affected CData Products
CData Drivers
- CData ODBC Driver for NetSuite
- CData JDBC Driver for NetSuite
- CData ADO.NET Provider for NetSuite
- CData Python Connector for NetSuite
- CData Power BI Connector for NetSuite
- CData Tableau Connector for NetSuite
- CData Excel Add-in for NetSuite
- CData SSIS Components for NetSuite
- CData PowerShell Cmdlets for NetSuite
- CData MCP Server for NetSuite
Other CData Products
- CData Sync - When using NetSuite Connector with SuiteQL schema
- CData Connect Cloud - When using NetSuite Connector with SuiteQL schema
Note: Only implementations using SuiteQL schema are affected. SuiteTalk schema remains fully functional.
We appreciate your feedback. If you have any questions, comments, or suggestions about this entry, please contact our support team at [email protected].
