Forum Discussion
ODBC NetSuite Connection to Power BI: How to learn NetSuite Schema
Sorry for the late response. Yes, I became a master of our NetSuite Schema without the help of third parties. Connecting to NetSuite via an ODBC is the easy part. It only requires having SuiteAnalytics and the ability to download the driver. Once connected, it is easy to get lost in the data depending on the customization within you system.
I have discovered a few things which made it easier to understand. The first thing is that there is system tables you could query on to retrieve table relationships, column names, and other stuff. That was really helpful, but I didn't figure it out until painfully piecing the data together manually.
Also, NetSuite has a schema browser which allows you to looks up various tables and see the tables keys and etc. It is not the greatest, especially when you system is more custom. Although, it can get you in the right direction.
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/schema/record/account.html
Hi,
Great work, are you also able to map/reverse engineer this for source NetSuite2.com as ODBC source?
Many thanks,
Jeroen