-
NS2 SuiteQL query fails instantly when removing filters — not a timeout
I'm putting the final touches on migrating queries from the "NetSuite.com" data source to "NetSuite2.com", and hitting a weird error where the query fails instantly when removing specific filters but not altering the query in any other way. It doesn't try to run and timeout, it errors instantly. If either specific filter…
-
NSC | NetSuite2.com: Show Transaction Full Status Instead of Letters
By default, the transaction table shows the status field as internal IDs in the form of letters. However, they are not descriptive, and users would constantly need to check their equivalent if used as-is. The query below shows how users can retrieve the status field of transactions that show their complete text. SELECT id…
-
Suite Analytics JDBC timestamp NullPointerException or Failed to retrieve data
I've connected to Netsuite via Suite Analytics JDBC connection in a Databricks cluster. I'm seeing a NullPointerException because of the lastmodifieddate column in my netsuite classification table (ie. if I do Select * from classification I see the NullPointerException and I've narrowed it down to seeing this issue because…
-
New to NetSuite | How to Setup a JDBC Connection with DBVisualizer using SuiteAnalytics Connect
In New to NetSuite | Pre-requisites to Setup SuiteAnalytics Connect, we showed how to setup the pre-requisite steps to use SuiteAnalytics Connect in your NetSuite Account. This article will guide you how you can establish a JDBC Connection between NetSuite and DB Visualizer. Solution Download the JDBC Driver Login into…
-
NSC | NetSuite2.com: Unable to Access Location-Related Tables
Some users find that their ODBC connection does not have state, province, and country tables listed and encounter the error: Base table: state not found. To resolve this, the permission named “Set Up Company” must be added to the integration role being used. This can be done by following these steps: Go to Setup >…
-
AWS Glue Connector and connection
I'm trying to create a Data Lake / Data warehouse and having a copy of the data into AWS redshift where to link a BI tool to match data from other sources. has someone tried already to connect via AWS Glue? i would like to connect via JDBC using TBA instead of user and password. i don't like REST output since is more…
-
New to NetSuite | Pre-requisites to Setup SuiteAnalytics Connect
According to SuiteAnswers 38970 SuiteAnalytics Connect, the SuiteAnalytics Connect Service lets you archive, analyze, and report on NetSuite data. You can use a third-party tool or a custom-built application on any device that uses Windows, Linux, or OS X operating system. If your company enables the Connect Service,…
-
SuiteAnalytics Connect - ODBC/JDBC - Audit Trail
I'm looking to see if there is an audit trail of all SQL queries executed via ODBC / JDBC? I am looking to get the query ran and the name of the user who ran it and the date/time. Note I am not looking for an audit of saved searches run.
-
Is there a guideline from NetSuite to connect to Talend Studio?
are there any guidelines from netsuite to connect netsuite to talend studio for integrations
-
How to resolved an Error When Running Filtered Queries via SuiteAnalytics Connect?
Recently connected to NetSuite2.com using DataGrip and when running queries filtered: select * from transaction where year(trandate) = 2023; I receive an error saying: [S1000][400] [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# lgvvjh4m14hfllw3sn8z5[400] Any…