Questions?

Do you use SQL Server for your Data Warehouse?

Is your ETL too slow?

Does your data arrive after 9am?

Are there days your ETL fails and your data does not arrive at all?

Do you want your ETL to run faster?

Do you want your ETL to be more reliable?

Does adding new data take too long and cost too much?

Do your queries run too slowly?

Would you like your queries to run MUCH faster?

Answers!

If you answered yes to two or more of these questions?

We would like to talk with you.

We are world class experts on SQL Server.

No matter how you implemented your ETL?

We can make your ETL run faster and be more reliable.

No matter how you implemented your data models?

We can make your queries run MUCH faster.

All with no more investment in hardware or software.

ETL Case Study

BIDA0052 – First Post To Business Central Forums

0
This is our first test post to the Business Central Forums

BIDA0051 – Business Central Dimensional Queries Sending Results To Excel

0
In this blog post we demonstrate how to query Business Central using a pseudo dimensional model and send the results into the Excel Power Query model. This is the future of direct query against operational systems.

BIDA0050 – Dimensional Models Over Business Central

0
In this blog post we demonstrate how to put pseudo dimensional models over the top of Business Central to solve the problems of sending ERP Data to AIs and querying ERPs to answer business questions.

BIDA0049 – Business Central Balance Sheet in Excel

0
In this blog post we demonstrate how it is possible to produce a report as complex as a balance sheet from Business Central using Meta5 and Excel.

BIDA0048 – Business Central Beginning of Time GL Balances in Excel

0
In this blog post we present an updated demonstration of our Business Central Beginning of Time General Ledger Balance Excel demonstration.

BIDA0047 – BC 2023 Excel Dictionary Demo

0
In this video we demonstrate the Business Central Wave 23 data model dictionary we have implemented in Excel.

BIDA0046 – Business Central Beginning of Time GL Balances in Excel

0
In this blog post we provide a detailed video demonstration of how to execute very complex SQL against Business Central to generate a valuable report that is very difficult (or impossible) to develop any other way.

BIDA0045 – Meta5 And Complex CTE Queries

0
In this blog post we show you the example of creating the Business Central Chart of Accounts Report using a Common Table Expression Query. This query is stored in a table and sent to Business Central via Meta5.

BIDA0044 – Meta5 As A Black Box Demo

0
In this blog post we provide a detailed demonstration of how to use Meta5 desktops as a black box.

BIDA0043 – Business Central Staging Area Evaluation Database Available

0
In this blog post we announce the availability of the Business Central Staging Area Evaluation Database.

BIDA0042 – Business Central Tables And Columns Rename Script

0
In this blog post we announce the availability of the rename script for Business Central 2023 Release Wave 2

BIDA0041 – Meta5 As A Black Box

0
In this blog post we explain the features we have developed for the idea of Meta5 as a black box.

BIDA0040 – InfoSys Finacle Version 7 Column Table Renames Available

0
In this blog post we explain our offer to Finacle Version 7 installed accounts to receive a copy of our Finacle column renaming script.

HD0015 – How Do I Add A New Data Disk Pod

0
In this How Do I blog post we show you how to add a new data disk pod.

HD0014 – How Do I Run PowerShell Commands In Meta5

0
In this How Do I Video we show you how to run a PowerShell command from inside a Meta 5 capsule.

BIDA0039 – BC365 OData Query Using Meta5

0
In this blog post we show you how you can query Business Central 365 using Meta5 and the CData BC 365 ODBC Driver.

BIDA0038 – Meta5 Navision 2018 Direct SQL Demo

0
In this blog post we show you a detailed demonstration of how Meta5 can query your Navision 2018 system using SQL statements that are stored in files. This enables you to ask the most complicated of questions from Navision directly.

HD0013 – How Do I Query Multi Level Dimensional Models

0
In this blog post we demonstrate how to query a multi-dimensional data model using Meta5.

BIDA0037 – Who Needs A Data Model Anyway?

0
In this blog post we reproduce a recent blog post by Bill Inmon, the father of data warehousing, on why you need a data model for a data warehouse.

BIDA0036 – Navision Excel Dictionary Demo

0
In this blog post we demonstrate our Navision 2018 Dictionary Workbook. This dictionary makes it easier to query Navision 2018 from Meta5.