hello, anyone have experience setting up an ODBC d...
# generalw
Will Coburn
10/21/2019, 4:23 PMhello, anyone have experience setting up an ODBC database from NetSuite for use in Access queries? I understand this is done through SuiteAnalytics, but can't figure out how to get the data to be exported from NetSuite
o
Olivier Gagnon (DXC)
10/21/2019, 4:59 PM1. You need to be the suiteanalytics module
Olivier Gagnon (DXC)
10/21/2019, 4:59 PM2. You need to create an inbound connection from your app
Olivier Gagnon (DXC)
10/21/2019, 4:59 PM3. You need tom build appropriate SQL queries
Olivier Gagnon (DXC)
10/21/2019, 4:59 PMit's not so much that Ns is exporting, that the other tool needs to import. NS is passive in this case
w
Will Coburn
10/21/2019, 6:14 PMgot it, thanks!
c
Cameron
10/21/2019, 10:01 PM@Will Coburn This should get you going. Note, I've never had any luck getting this to work with a 32-bit ODBC connection. However, you probably have 64-bit MS Office anyway. https://netsuite.custhelp.com/app/answers/detail/a_id/68320/
w
Will Coburn
10/22/2019, 1:39 PMThanks, @Cameron!
5 Views