Configuration of Netsuite provided odbc connector

Hi @petsche 

Have you setup one of the below drivers in the portal? If so can you please share a screenshot of the settings

Have you tried adding the data source to your ODX instance?

Try to select all tables and then edit your data source and select advanced settings. 

Can you please share a screenshot of these advanced settings? Also, which TimeXtender version are you using?

Hi christian,

i'm using timextender 20.10.31.64. 

The problem is not how to configure the connector with datasource, I cannot see  the Netsuite odbc-connector as a provider (see image). I see only the ADO odbc data Provider … not the one i got from Netsuite themselves.

so i cannot confiugre it…I first have to load the Netsuite odbc provider  and that is the problem…

Peter

Christian,

no, the performance issue we have is in the ADO odbc connector due to the limit in records loaded per request , Netsuite advised us to use their odbc connector !!!

so i cannot use the ADO-odbc connector 

PEter

Hi @petsche 

We only have the ADO ODBC connector, we do not have another ODBC connector. The alternative would be to use the CData Netsuite provider. Please see the following Microsoft documentation for more information on the ODBC connector

https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/data-providers

Please see the this guide for more info on how to setup the ODBC connector mentioned above.

Christian, 

okayz, where can i download de odbc drivers connector files , when i choose this ado odbc connect and try to configure with using the odbc-admin, i do not see the netsuite drivers ???

see screen :

Peter

Hi Peter,

Can you please send me a link to the driver you installed?

I installed this one

which I can then see under the System DSN tab

Hi Christian, 

i have installed the version you mentioned, can connect to Netsuite  now, but when synchronizing it errors with :

Error retrieving a table (unknown):
System.ArgumentException: Column 'TABLE_SCHEMA' does not belong to table Views.
   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at DataSourceEngine.ADO.ADOSourceEngine.GenerateObjectList(DbConnection connection)

i am using schema SUITEQL: 

i presume i have tochange in the datasource at advanced settings something: now i have:

please advice 

PEter

Hi Peter

Please try to follow the section "Create a ODX ODBC Data source" in this guide. Let me know if you have any issues

HI Christian,

have got it working, however after installing/configuring the odbc connector, other connectors (for example cdata ado.net provider for salesforece 2022) fails on Service request failed: System.BadImageFormatException: Could not load file or assembly 'icudt42.dll' or one of its dependencies. The module was expected to contain an assembly manifest.
File name: 'icudt42.dll' ---> System.BadImageFormatException: Could not load file or assembly 'icudt42.dll' or one of its dependencies. The module was expected to contain an assembly manifest.
File name: 'icudt42.dll'

after uninstalling the netsuite odbc connector , the failed salesforce connector works again, without changing anything. So it is clear that the cdata odbc connector causes the problem. 

Is there a specific location where the netsuite odbc connector needs to be installed , cq. dll registered or paths ? 

have already set the installed path into system environmet paths but no result 

Peter

hi cristian,

managed to resolve the problem… needed to be installed in windows/system dir.

can now access tables 

thank you for the support

Peter

Glad that it’s resolved! Can you please help us by marking a best answer above?

Hi Peter

The CData providers are stored in a specific folder.

Try to remove this folder and add it again, rerun the ODX Service Configuration program to point at a folder to store them in. Then install them once more and see if the error continues.