does netsuite really hide columns from customers?

• stan

  SSC Eights!

  Points: 963

  More actions

  October 17, 2024 at 2:14 pm

  #4469598

  Hi we built a gateway from sql server to netsuite using an oracle competitor's odbc driver.

  once it was standing we noticed 111 columns missing in the linked server views for i believe just "salesinvoiced", customers and items alone.   we have nsaw but its on a different netsuite instance and i believe out of scope of this question.  as far as i know most or all of the missing columns are standard not custom and i can query them on netsuite using suite ql.  according to the very first rep we spoke to at oracle, if you can query a field in suite ql on netsuite, you can get it thru an odbc driver.

  I've heard a few things thus far that dont add up so im asking the community if the've had a similar experience..

  1. you have to ask the competitor (from oracle)
  2. yes we've recreated the same problem (from oracle)
  3. if you buy suite ql analytics connector, which then allows install on your sql server of our odbc driver, you can add a role called data warehouse integrator that can see all fields (from oracle)
  4. data warehouse integrator is an nsaw thing (this came from one of our own guys)

  one thing that strikes me is that #3 may be illegal (monopoly kind of thing) if it actually blocks (indirectly) the competitor products from seeing a huge percentage of fields.

   

  • This topic was modified 15 hours, 4 minutes ago by  stan.