Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to Connect with ODBC
I have followed all the steps in the documentation to set up SuiteAnalytics connect. I can verify that the driver and configuration is correct by going to the 'System DNS' tab in the ODBC Data Source.
Now what? The documentation completely falls off here. I use MySQL and I was thinking of setting up a new location and connecting through SSH. But that does not work. I guess that makes sense because those are to connect to a MySQL server, which NetSuite is not.
I imagine running some sort of script is going to be necessary. I have experience running PHP and Perl scripts to connect to a database using ODBC. Is that what I am going to need to do to successfully run queries off of NetSuite?
0