<@UHWSGDHK5> You might want to ask this in the <#C...
# general
s
@Christopher Cordova You might want to ask this in the #suiteanalytics board. I will say, though, that if the data you want to display in the dashboard can be retrieved in a few queries or a workbook, it might be worth considering a Restlet script, since you are working with JavaScript already. The benefits of the JDBC driver are best for a JVM native language, like Java, Groovy, or Scala, where you can treat Netsuite like any other standard JDBC-compliant database (except that the driver is read-only). One problem with the ODBC or JDBC drivers is that you cannot yet use token-based authentication, so you will need to send username and password credentials.
👍 2
d
To add to this - We make EXTENSIVE use of the jdbc driver interface to pull data from NS. It is somewhat limiting, but very good if you need to perform complex joins that were not possible previously (although workbook queries now support them) and when you need to extract and operate on large volumes of data. We're pulling somewhere around 25m records hourly. Echoing what Scott said, you do need to use user/password credentials which means they will expire regularly and may break your integration if you don't plan for it.
s
Thanks Dave and SCott for your valuable inputs.