#ICYDK: The CData Drivers (JDBC, ODBC, API Server, ADO.NET, SSIS, BizTalk, and Excel) implement standards-based SQL access to various data sources, enabling third-party tools to interoperate. You can use CData Drivers to create reports on NetSuite data, and you can also access existing reports. This article shows how to query a RESTlet in NetSuite.
SQL Access to NetSuite Saved Searches
NetSuite RESTlets are server-side scripts that interact with NetSuite data following RESTful principles. With the added support for RESTlets in the CData Drivers, users get SQL access to their NetSuite saved searches, exactly as they appear within the NetSuite UI. Users can quickly and easily see the results of saved searches, regardless of any complexities in the report, whether those are JOINs with other tables, formulas on fields, summaries, and more. The screenshot below showcases a saved search in the NetSuite UI (left) and the same results in Visual Studio Server Explorer using the CData ADO.NET Provider (right). https://goo.gl/LwPa8N
