Forum Discussion
Helper IVSet up Fabric Netsuite ODBC
Hi AJAJ ,
Thanks for sharing the details and the error screenshots.
From the message it seems to be related to the ODBC connection through the gateway.
In similar cases, a few steps have helped:
>>Try updating the connection string by replacing it with dsn=... and check if that works.
>>If not, there have been situations where the issue was resolved by changing the Windows account used by the Power BI Gateway.
Solved: Re: Adding ODBC connection in Power BI service fai... - Microsoft Fabric Community
The documentation on changing the service account is here: Change the on-premises data gateway service account | Microsoft Learn.
>>Another point to confirm is that the same authentication method is being used when creating the ODBC data source and when adding it under the gateway.
>>If the issue still persists, you can try reinstalling the ODBC driver and also reinstalling the latest gateway to see if that resolves it.
Similar dicsussions:
Solved: Connecting to ODBC Via Data Gateway - Microsoft Fabric CommunitySolved: Re: ODBC Connection Error - Driver Error - Microsoft Fabric Community
Solved: Re: Personal Gateway X On Premises Gateway - Microsoft Fabric Community
Please check if these steps help, and reach out for any further assistance.
Thank you.
Super UserHi AJAJ
This is AI generated and unverified but I hope it helps:
Microsoft Fabric currently requires a gateway to connect to NetSuite via ODBC. This is because Fabric needs a secure bridge to access external data sources like NetSuite, which are typically hosted outside Azure's internal network.
🧩 Options for Connecting NetSuite to Fabric
1. ODBC via Gateway
- Fabric requires a gateway to use ODBC connections
- You’ll need to install the NetSuite ODBC driver (e.g., from CData or Oracle) on the gateway machine .
- Set up a DSN (Data Source Name) on that machine.
- Use Dataflow Gen2 or Copy Activity in ADF to pull data.
2. Using CData Connect Cloud (No VM Required)
- CData offers a cloud-to-cloud solution that bypasses the need for a VM or gateway .
- You connect Fabric to NetSuite via a Virtual SQL Server endpoint exposed by CData.
- Supports SuiteQL, Saved Searches, and OAuth/Token-based auth.
- Ideal for live data access and optimized queries.
3. REST API Integration
- You can use SuiteTalk REST APIs with ADF or Fabric pipelines.
- Requires custom logic for pagination, authentication, and schema mapping.
- REST is more flexible but less performant for large datasets unless optimized.
🛠️ Setting Up ODBC in Fabric
Here’s a high-level checklist for setting up ODBC in Microsoft Fabric:
- Install ODBC Driver (e.g., CData or Oracle NetSuite driver) on the gateway machine.
- Configure DSN with NetSuite credentials and endpoint.
- In Fabric Dataflow Gen2:
- Use the ODBC connector.
- Choose Basic or Anonymous authentication.
- Map the DSN and credentials.
- In ADF:
- Create a Self-hosted Integration Runtime.
- Use the ODBC connector with the DSN and credentials.
- Define datasets and pipelines using Copy Activity.
✅ Best Practices
- Use incremental refresh if possible, especially for wide NetSuite tables .
- Start small with your semantic model to avoid performance issues.
- Consider third-party tools like Stitch or Striim for more scalable ETL workflows.
- Use Azure Key Vault for storing credentials securely in ADF
AJAJThats smart. I was able to make progress per above recommendation and have added more screenshots on another reply of the error. Is there a way to explore more on that error or additional information.