When using the SkyVia Netsuite connection, I can see various tables when setting up a replication job. However these are not the same tables that I see in my SQL tool using the same connection credentials.
Screenshot of my issue:
My client tool:
I am using the same connection information. You can see using the NetSuite connection that I can see tables that I don’t see in the SQL client tool. Why is this?
We are working with NetSuite with NetSuite API. NetSuite API documentation does not list such object as Items: http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_2/schema/record/inboundshipment.html
The second screen with your client tool displays various objects. But we don't know where this list of objects is taken from and how it is formed by your client tool. Please also tell us, which ODBC driver you use for access to NetSuite.
i am using 64-bit Netsuite ODBC drivers from the Suite Analytics Connect Driver Download section from the Netsuite website.
Items object is available in the Connect Browser: http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_2/odbc/record/item.html
Connect Browser provides the schema for the ODBC connectors, while Schema Browser provides the schema for the SOAP-based Web Services API. Skyvia doesn't work via ODBC connector. Skyvia works via NetSuite API and use schema that is provided by Schema Browser. That's why you do not see Items object in Skyvia, but can see in your tool.
