Business Intelligence

Why I Love Self-Service BI

Self-service BI (or self-service business intelligence) has been a buzzword for a while. If you Google “self service BI,” you get 383,000,000 results. 

(Interestingly, if you Google without the dash — “self service BI” — you get 409,000,000 results. I can’t tell you the significance of this. Although Word tells me it needs a dash.) 

But you don’t Google search results to tell you that users don’t want to rely on IT to get the “data they need from the software they already have.”  

So, as a consultant, why would I want users to do more of the work?

Read more…
Dynamics NAV

NAV Object, Field, and Option Numbers in the SQL Server Database

When writing SQL queries for NAV, you can run into a problem.   

While column names are generally pretty self-explanatory, sometimes the data within those columns requires decoding.  

Those are: 1) Table Numbers, 2) Fields Numbers and 3) Option Numbers

I’ve already covered this in my posts (and presentation) on Understanding the NAV Database.

Here I’m going to repeat myself — and then give you the code you need to get these numbers into SQL.  

Read more…
Dynamics NAV

Accessing Dynamics Business Central (NAV) Cloud Data, Part 5 – Going Back to SQL Server

So far in this series, I’ve spent a lot of time showing how we can work with various ODATA web service APIs to get different sets of data from Business Central. 

And as you may recall, the purpose of this series is to describe how you can combine data from Business Central with other applications that may not be in the cloud and may not be using Power BI.  

In this post, we’re ready to talk about this specifically.

Read more…
Dynamics NAV

Accessing Dynamics Business Central (NAV) Cloud Data, Part 4 – Going Deeper into the API

So far, we’ve seen how we can extract an entire table from the cloud, in this case the Chart of Accounts. However, we often don’t want to do that (especially on tables like G/L Entries). 

Thus, we need to filter.

The complete reference for ODATA Filtering for Business Central/NAV can be found here: 

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris

Read more…
Dynamics NAV

Accessing Dynamics Business Central (NAV) Cloud Data, Part 3 – Introduction to Postman

In Part 2 of this post, I reviewed the basics of setting up a web service access key, finding your first API, and then executing the API in your browser. 

But the output we had wasn’t all that user friendly. Further, we asked for EVERY account in the system. In this case, there wasn’t a huge amount of data so it wasn’t a problem. But it’s not something you’d want to do with G/L Entries or other larger tables.

Fortunately, you can do a lot more with these ODATA Web Services than just select everything. Theoretically, you could create ever more complex strings and test them in your browser. But that’s not really efficient.  

Which brings us to a tool that’s called Postman.

Read more…
Dynamics NAV

Accessing Dynamics Business Central (NAV) Cloud Data, Part 1: Terminology and Tools

When databases became a common part of ERP systems over 20 years ago, developers would say that no matter what else happened, they would always have SQL. “Give me a connection string and I’ll get you anything you want,” was their moto.

Today, that’s not the case. With the advent of SaaS in general (and cloud-based Business Central in particular), you now need to know things like “ODATA and “APIs” — especially if you want to combine data from multiple systems in a single report or data warehouse.

I joke that the definition of SaaS is “software where companies save lots of money on infrastructure and upgrades, which they end up spending on data and reporting.” (Which is good for me, I suppose. I never liked infrastructure and always liked data.)

Read more…

Get tips and insights delivered to your inbox

Start a conversation with us

Call: 917-848-7284
Email: inquiries@redthree.com

Request a Consult