Does anyone knows how can we see database data in netsuite instance?

If all you want is database view - then SuiteAnalytics Connect is your tool

Does it shows data inside the tables?

My best guess is that it shows "views" that are reflective of the actual tables themselves, but not the actual tables. - so you get to see the data.

Ok thanks, I will try this

It is a paid module

ooh thanks

It gives you an ODBC connector that you can write SQL queries against using another tool, such as Visual Studio

You can fire SQL queries with

N/query

module without needing that

Note that occurs within scriping - so you'd have to do more to make that functional.

You just can't see what you are firing against 🙈

once you have SuiteAnalytics Connect, yes you can run SQL queries. There are two data sources (NetSuite.com and NetSuite2.com), both showing the same data, but in a different schema, further evidence that they are likely both just a set of views over top of the actual data tables.

@Sandii without needing what?

But, you can also use REST web services and the query module in SuiteScript to run SuiteQL, which is a SQL-like query language, with certain differences and limitations

SuiteAnalytics Connect

is an extra module you have to pay for. You do not need it to write code/use the

N/query

APIs

you mean API like this? {{REST_SERVICES}}/query/v1/suiteql?limit=5

Hit up @Josh_SatoriReporting if you want a real view of your NetSuite data

ok will do. Thanks