-
NPSB & Suite Analytics
We use Suite Analytics to run custom queries and replicate some Netsuite data into our data warehouse that we need to merge with other data sources. Our finance team wants us to get some data out of NPSB into the same data warehouse as we have real-time marketing spend there. Is there a way to have NPSB sync data back into…
-
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…
-
Entity Relationship Diagram for NetSuite2.com Schema
Hi Team, We have a data lake in our company, so we are syncing the data to Datalake using Oracle ODBC/JDBC Connector. So our Datalake team needs to understand the Tables, fields, and their relationships between the tables. So it would be great if we had ERDs for the schemas. Thank You,
-
netsuite2.com transaction linktype does not have fulfilment request
Hi all As we are migrating our query from netsuite.com to netsuite2.com, we realised that in netsuite.com we are able to get the fulfillment request in the transaction_links table But in netsuite2.com, the link_type FftRqFt no longer exist in PreviousTransactionLink, PreviousTransactionLineLink, NextTransactionLink or…
-
SuiteAnalytic Connect - ODBC connection using TBA
How can we connect to SuiteAnalytics Connect ODBC using token-based authentication?
-
Missing Transaction Accounting Lines in JDBC and SuiteQL SuiteLet
Hello, Edit and update: It looks like the cutoff date is somewhere in March 24/25, 2023, which is when the 2023.1 release of Netsuite came out. Is that possibly related? I am facing a strange issue querying Transaction Accounting Lines through both the SuiteQL suitelet and through the JDBC driver. I am using the latest…
-
SuiteAnalytics Connect
Hi, How can I see which account is still using the netsuite.com data source for SuiteAnalytics Connect ? I get notifications that one of my account is still using netsuite.com instead of netsuite2.com, but I can't find which one… Regards Sebastien
-
Cannot assign Data Warehouse Integrator role to a user
I'm trying to update a connection between Fivetran and NetSuite to utilize the newer netsuite2 data source. Every guide that I've found suggests assigning the Data Warehouse Integrator (DWI) role to a user. They also say that this standard role shows up when enabling SuiteAnalytics Connect. My SuiteAnalytics Connect is…
-
SuiteAnalytic Connector - Do not have permission to use SuiteAnalytics
Hi everyone, I'm trying to test the connection to SuiteAnalytic connector. However, I got the issue about the permission. Some information: Error log when I tried connect with JDBC on Data Grid. Enabled SuiteAnalytic feature. 1st tried: Granted directly permission to duong.le@… account. Still get the same the above error…
-
connect to NetSuite via ODBC using MYSQL
How can we connect to NetSuite via ODBC using MYSQL similar to WATCH: How to Connect SuiteAnalytics Connect via ODBC using Microsoft Excel