NetSuite Data Structure

So great. You know how to access the data.

But, as you can imagine, this data is optimized across a massive superstructure. And the underlying components support a variety of services across a wider variety of industries. So you need to infer that the structure will be complicated. But again, one bite at a time…

I will again reference the link provided in an earlier post;

refining odbc queries

Suffice it to say that some deeper analysis is required here.

With that said, here is another nugget;

Oracle NetSuite schema browser

The next step is to analyze the structure and determine where your data resides

Just don’t forget. The structure will have a hierarchy – and that may vary depending on what NetSuite version you are using.

But once you have connected to the data source, you can expand on the sql query to access only the required content.

It’s just data

I frequently run into questions from customers and users about accessing information from the various technologies that they are using. They are overwhelmed by the magnitude of the challenge that they are facing.

My response is, in every instance, without fail…

Sure there may be all sorts of structure and services around it.

It’s just data.

And, granted, it may be a bit of an effort to access it.

So, if it is a territory you are not familiar with, like the old adage of eating an elephant, you take one bite at a time. But your first bite, or step in this instance, is realize that it is just data. And, generally, solutions benefit from the ability to connect to them.

But, in the end, it is just the collected and/or aggregated information that you, or your various sources, have put there.

And there may additionally be some additional design work to make use of the data you have uncovered. Along with supplementary content that you will need to aggregate or uncover.

Case in point, I will reference the Oracle NetSuite ERP platform.

Yes, overall it is a solution. And that solution has adapted to serve many different markets. And they have additionally integrated other components to offer additional functionality.

But in the end, the underlying structure is based on the core product that hass been the bread and butter of the company that offers the solution – and who’s name is synonymous with one flavour of that type of platform. The type of platform is a Database. And the company, as identified above, is Oracle.

Accessing your data in Oracle NetSuite

So here is the first (loaded) nugget;

Use the SuiteAnalytics Connect ODBC driver to load your NetSuite data to Microsoft Excel

ODBC stands for Open Database Connectivity (ODBC). It has been around since the advent of personal computing and has gone through a number of iterations in that period. In short, it is how you access the data in Netsuite.

As to where you would use it, the possibilities are endless. A simple solution. would include excel.

Accessing ODBC content from Excel