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