Connect to Netsuite API vs. ODBC

[michaelsh]

Hello friends,

Did someone managed to get data from Netsuite via API (SuiteTalk)?

Or any other way. (I prefer not to buy 3-d party connectors such as CData)

Please share your experiences/best practicies.

Thank you

Michael

[Aryna]

Hi @michaelsh , I developed multiple Netsuite reports in Power BI using custom connector. Here is more info: https://vidi-corp.com/cases/netsuite-sales-organisation-analysis/

[karaoan]

You can also connect from Power BI to Netsuite using Acterys: Planning, Consolidation For Power BI & Excel  Acterys automatically creates editable, Azure/MS SQL tables, optimized for analysis with the required Netsuite tables. It also adds comprehensive planning and write-back optios with 8 Power BI custom visuals: Acterys Planning & Analytics For Power BI & Excel (microsoft.com)

[v-yingjl]

Hi @michaelsh ,

If you want not use the third-party connector to connect to Netsuite, you can try the ODBC driver, refer this blog:

https://blog.ennvee.com/blog/connecting-netsuite-to-power-bi

Or you can refer this official document:

https://www.netsuite.com/portal/developers/resources/suitetalk-documentation.shtml

Best Regards,
Yingjie Li

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

[michaelsh]

@v-yingjl 

Your first link is actually for third-party CData connector.

I guess I wasn't clear enough with my question.

I appreciate the links but I have already Googled them.

I would like to hear peoples' first-hand experience with API / ODBC - tables/calls they use, limitations, bugs, performance etc.

Thank you

[amitchandak]

@michaelsh , See if these old solutions can help

https://community.powerbi.com/t5/Desktop/Netsuite-connectivity-with-Power-BI/td-p/172781

https://datachant.com/2017/02/03/connect-netsuite-to-power-bi/

[michaelsh]

No @amitchandak ,

I have seen these posts . They are old (2017) and don't help much - these are complex ways to connect to data.

There is new REST API:

https://www.netsuite.com/blog/netsuite-expands-integration-capabilities-with-new-rest-web-services

I am looking for advice / best practicies from people that have done this.

Please help