Discussions
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?