Missing rows in the Accounting Period table in SuiteAnalytics Connect

Transitioning to a new data source One of the data sources that I use in my data models is from Netsuite ERP. To access the data I am using SQL Server Integration Services with an ODBC driver going through the SuiteAnalytics Connect service. Netsuite has deprecated the current data source that I am using - … Continue reading Missing rows in the Accounting Period table in SuiteAnalytics Connect

Connecting DBeaver to Netsuite SuiteAnalytics Connect using JDBC

An issue with DBeaver and the Netsuite Suite Analytics Connect ODBC Driver When using DBeaver to connect to Netsuite SuiteAnalytics Connect using the ODBC drivers some columns may return blank or NULL. If you are just starting to investigate the schema this may lead to a lot of confusion and thinking that you do not … Continue reading Connecting DBeaver to Netsuite SuiteAnalytics Connect using JDBC

How the Static Data Model can help with Netsuite SuiteAnalytics Connect

Static Data Model The Static Data Model can make working with the Netsuite SuiteAnalytics Connect new data source more informative. Regardless if you are just starting to use SuiteAnalytics for the first time or you are tasked with transitioning an existing project to the analytics data source. It is beneficial by allowing you to see … Continue reading How the Static Data Model can help with Netsuite SuiteAnalytics Connect