ODBC NetSuite Connection to Power BI: How to learn NetSuite Schema

Hello, I am new to Power BI and NetSuite. I am able to connect Power BI to NetSuite via an odbc connection, but I have come to relize that there needs to be an understaning of NetSuite's schema t...

Need Help

Tutorial Requests

Anonymous

Not applicable

6 years ago

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