topic Re: NetSuite ODBC truncation in Dataflow

NetSuite ODBC truncation

ebjim — Wed, 13 Mar 2024 16:09:00 GMT

I am importing from NetSuite into a Dataflow gen2 via ODBC and got this error even before I could complete the Get data wziard:

Am I correct in saying that there is no way to resolve this in Fabric?

Re: NetSuite ODBC truncation

Anonymous — Wed, 13 Mar 2024 18:22:04 GMT

Hi ebjim

Thanks for using Fabric Community.

Did you check this document on ODBC connections?

https://learn.microsoft.com/en-us/fabric/data-factory/connector-odbc

Are all the pre-requisites met?

Please check the supported types here

https://learn.microsoft.com/en-us/power-query/connectors/odbc#prerequisites

Hope this helps. If the issue still persists please do let me know.

Re: NetSuite ODBC truncation

ebjim — Wed, 13 Mar 2024 19:02:22 GMT

Yes, on both questions. I successfully imported other NetSuite tables.

Re: NetSuite ODBC truncation

Anonymous — Wed, 13 Mar 2024 19:06:21 GMT

Hi ebjim

Thanks for the details. So which tables are you facing the issue with?

Do these tables have huge amount of data?

Re: NetSuite ODBC truncation

Anonymous — Wed, 13 Mar 2024 19:16:50 GMT

Hi ebjim

As the issue is with only some tables, I would request you to contact NetSuite support. They might have updated information on the driver's limitations or potential workarounds.

Hope this helps.

Re: NetSuite ODBC truncation

jerr — Tue, 09 Jul 2024 18:02:15 GMT

How are you able to load directly netsuite data in Fabric, via a VM where the ODBC is installed? We would like to skip the VM part with the NetSuite driver, is that possible?

Re: NetSuite ODBC truncation

Jerr31 — Fri, 12 Jul 2024 05:45:31 GMT

Have you already tried on of the sollution on these pages?