Forum Discussion
Kudo KingpinConnect to Netsuite API vs. ODBC
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
6 Replies
v-yingjlCommunity Support
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
michaelshYour 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
Super User
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
- 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)
ArynaPost Partisan
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/
