cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jnajamy
New Member

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 to effectivley create desired reports. Unfortuantly, I am coming up short on educational materials. I have come across NetSuite's schema browser, but it does not help since I lack general knowledge on how it works.

 

Does anyone know of any materials I can review to learn NetSuite's Schema so that I may build reports using Power BI?

 

5 REPLIES 5
mmgnln
Helper II
Helper II

@jnajamy I'm also interested in learning more about the system tables...can you please give an example?

 

Thanks!

v-xicai
Community Support
Community Support

Hi @jnajamy  ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

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

@jnajamy  Thanks for sharing!

Can you please specify several system tables you've mentioned?

The ones that have relationships etc..

 

Also, when you publish Power BI to the service - where do you install the Gateway?

Thanks

Michael

v-xicai
Community Support
Community Support

Hi @jnajamy ,

 

About how to connect NetSuite to the Power BI Desktop, you can refer to the document: https://www.cdata.com/kb/tech/netsuite-odbc-power-bi.rst.

 

You can also refer to the links to learn more about NetSuite:

https://zappysys.com/blog/read-netsuite-data-power-bi/,

http://netsuite.topowerbi.com/,

https://www.stitchdata.com/integrations/netsuite/powerbi/.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.