Hi, I have a client who wants to use Excel and OD...
# suiteanalytics
z
Hi, I have a client who wants to use Excel and ODBC. I have no experience with ODBC and simple question is > can I use standard SuiteQL SQL in Excel? Same tables, fields, joins … My idea is preparing SQL in NetSuite (Tim Dietrich tool or similar) and then send to the client
e
They'll need a SuiteAnalytics Connect license so you can connect via ODBC. But once you're connected you can use the same queries as you would with SuiteQL.
👍 1
🙌 1
z
they have SA Connect licence. My job is creating a reports. I quickly reviewed SA guides and need a confirmation that I understood correctly about Power Query syntax is the same as SuiteQL