In order to improve performance of data loading from Netsuite , we were advised to use Netsuite ODBC provided connetor and use Suiteanalytics. I have download the odbc connector provided by Netsuite, and installed it on the Timextender VM, i get an succesful connection in connecting to NS, using ODBC-test connection. However i cannot acess the odbc driver in Timextender ODX, so how do i do that.
Keeping in mind that the Netsuite CData connector uses Rest-calls with limits 1000 records.. so that is not feasable.
thank you in advance
Peter
Page 1 / 1
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
Hi @petsche
Please try to use the ADO ODBC Data Provider.
Ensure that the ODBC driver has been setup in the ODBC Data Source Administrator
Then, copy the details from the administrator into the DSN and Driver fields, and test the connection.
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
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 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.
