Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous  ,

 

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

  • Anonymous's avatar
    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

    • michaelsh's avatar
      michaelsh
      Icon for Kudo Kingpin rankKudo Kingpin
      5 years ago

      Anonymous  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

    • Jerr_31's avatar
      Jerr_31
      Regular Visitor
      3 years ago

      Hi,

       

      Great work, are you also able to map/reverse engineer this for source NetSuite2.com as ODBC source?

       

       

      Many thanks,

      Jeroen