Well here I go: - Does OBDC connections also fall ...
# suiteanalytics
a
Well here I go: - Does OBDC connections also fall in to the concurrency limits thing? - Can I effectively query Inventory status? which mean On Hand, Committed, Back Ordered for every location? - Which major limitations I can expect regarding Record Type unable to query/read? - Which price for this approximately?
l
@alien4u hope this helps - Does OBDC connections also fall in to the concurrency limits thing? Knowing NetSuite I assume this is a yes so I what I did for my client is I made sure that only one user is used per connection. - Can I effectively query Inventory status? which mean On Hand, Committed, Back Ordered for every location? Are you referring to inventory_detail record? Sorry I might not be the best person to help you with this because I did not have experience querying inventory records but see if you can use the schema for it: https://system.na3.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/odbc/record/account.html - Which major limitations I can expect regarding Record Type unable to query/read? I believe ODBC is more flexible in terms of record exposure, e.g. you can report any unexposed fields or records in ODBC to Support, any custom records are automatically exposed via ODBC. In any case, make sure you check the schema first if the record you're querying is not available. - Which price for this approximately? Not sure if this is still reliable. This was from 2007. http://www.netsuite.com/portal/press/releases/nlpr06-21-07c.shtml