I'd like to convert a saved search into an ODBC/SQ...
# suiteanalyticsm
martin.hambalek
10/31/2017, 3:55 PMI'd like to convert a saved search into an ODBC/SQL report, but I'm not a developer. Is there a tool or service that can generate the SQL? I realize the ODBC data model/tables/fields are different than the ones used in saved searches. I'd like to get the logic built for me.
s
Sam-I-Am
10/31/2017, 4:19 PMyou can do that with suiteconnect and ODBC connector
Sam-I-Am
10/31/2017, 4:19 PMalso check out the following https://www.tacticalconnect.com/
m
martin.hambalek
10/31/2017, 4:29 PMI've talked to them previously. They want several $000. I've used the ODBC connector before so I want to go the inexpensive route.
s
Sam-I-Am
10/31/2017, 4:39 PMSesame software also have data warehouse for Netsuite
m
martin.hambalek
11/02/2017, 4:04 PMI found that there's an enhancement for what I want to do: 110729: SuiteAnalytics > Convert a saved search into an ODBC query