NetSuite Schema

  • 87Views
  • Last Post 20 March 2018
0
votes
miles yoshioka posted this 09 March 2018

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?

 

 

Order By: Standard | Newest | Votes
0
votes
Simon Bubnov posted this 14 March 2018

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.

0
votes
miles yoshioka posted this 16 March 2018

i am using 64-bit Netsuite ODBC drivers from  the Suite Analytics Connect Driver Download section from the Netsuite website.

0
votes
Mariia Zaharova posted this 20 March 2018

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. 

Close