Forum Discussion
Netsuite connector for Fabric
Hi Rocky1001,
Currently, Microsoft Fabric does not offer a native connector for NetSuite. Commonly used approaches include:
CData Sync -- OneLake (Parquet/Delta):
This is a cost-effective solution compared to fully managed ELT, supporting incremental replication and flexible scheduling. However, it requires some operational management as you will be running the service.Fivetran -- OneLake (Delta):
This fully managed option delivers data directly into OneLake with minimal setup. Most objects support incremental loads, though some tables may need full refreshes periodically. It is the lowest-maintenance approach but comes at a higher cost.DIY solutions (SuiteAnalytics ODBC/JDBC or REST/SuiteQL APIs):
These can be integrated through Fabric pipelines or notebooks, but you will need to develop and maintain your own incremental logic, as well as manage authentication, pagination, and throttling.For smaller data volumes, CData Sync into OneLake offers a good balance between cost and effort. If budget allows and a fully managed solution is preferred, Fivetran → OneLake is the most straightforward option.
Thank you.
Community SupportHi Rocky1001,
Currently, Microsoft Fabric does not offer a native connector for NetSuite. Commonly used approaches include:
CData Sync -- OneLake (Parquet/Delta):
This is a cost-effective solution compared to fully managed ELT, supporting incremental replication and flexible scheduling. However, it requires some operational management as you will be running the service.
Fivetran -- OneLake (Delta):
This fully managed option delivers data directly into OneLake with minimal setup. Most objects support incremental loads, though some tables may need full refreshes periodically. It is the lowest-maintenance approach but comes at a higher cost.
DIY solutions (SuiteAnalytics ODBC/JDBC or REST/SuiteQL APIs):
These can be integrated through Fabric pipelines or notebooks, but you will need to develop and maintain your own incremental logic, as well as manage authentication, pagination, and throttling.
For smaller data volumes, CData Sync into OneLake offers a good balance between cost and effort. If budget allows and a fully managed solution is preferred, Fivetran → OneLake is the most straightforward option.
Thank you.
Community SupportHi Rocky1001,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.
- v-sgandrathi
Hi Rocky1001,
May I ask if you have gotten this issue resolved? If you have further queries please reach out to Microsoft Fabric Community forum.
Thank you.
- v-sgandrathi
Hi Rocky1001,
Just looping back one last time to check if everything's good on your end. Let me know if you need any final support happy to assist if anything’s still open.
Thank you.