Hello !! Does anyone know if SuiteAnalytics Connect ODBC driver also provides access to table SavedSearches and stored procedure CreateSavedSearchSchema , just like these 3rd party vendors provide - https://www.cdata.com/kb/articles/netsuite-saved-searches.rst, http://cdn.cdata.com/help/DNC/odbc/pg_sp-createsavedsearchschema.htm, https://docs.tibco.com/pub/tdv/8.2.0/doc/html/AdapterHelp/index.html#page/AdapterHelp%2Fword-frame_netsuite.33.071.html%23  . I couldn't find that from the ODBC connection though.

ODBC connector from NS is not saved search based

I'm curious on the functionallity of the ODBC driver, what tables do you have access to? Couldn't you just create the SavedSearch in the tool, say excel or Power BI, by replicating the datamodel?

Yeah, you can - but they are straight tables and there's a few different versions of the connector, and it's hard

most people would use this to update excel reports real time, would you happen to know if there's a view of the schema / tables avaialble through the ODBC?

@Synx there are a couple system tables (

oa_tables

,

oa_columns

,

oa_fkeys

etc.) you can use in ODBC to query the schema. https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4407755805.html (and of course the Connect Browser)

Challenge with SavedSearches is that, with NetSuite ODBC connector - although you have access to base tables, but you always have to replicate the logic (tables, fields, filter conditions etc) of a SavedSearch from ODBC using SuiteQL every time you create a new Saved Search. These 3rd party ODBC vendors automatically creates the schema definition of a saved search for you via a stored procedure, which is very beneficial since you just have to pass the name/internal-id/recordtype of the saved search and that saved search is then exposed as a view to be do direct query from. Further to add - there are oa_proc and oa_proccolumns tables present via odbc connect schema, but not supported.