BB0011 – Business Central Meta5 WTDD

0
13

Hello and welcome to our latest blog post here on BIDA Brains.

I am pleased you have come back to see our latest blog post.

Thank you.

This blog post is technical.

It is really only intended for advanced Business Central developers.

The Meta5 software has a feature called the Workstation Tools Data Dictionary (WTDD).

This dictionary is used to support the ability of Meta5 to generate SQL.

It is not intended to be used to query large operational systems.

It is intended to be used to query dimensional data warehouses.

We have upgraded the version of the WTDD we created for Business Central 21 to 23.

We have brought across the more than 5,000 joins we defined for Navision.

You can download an Excel workbook with the joins in it from the button below.

Download Workbook

This workbook will be handy for anyone trying to write SQL to query the tables in Business Central.

What we have done is download the joins in both directions so there are more than 10,000 rows in the joins worksheet.

This means that every join is defined from the first table in the workbook.

You can see what tables a table is joined to just by filtering on the first table column in the workbook.

Of course, actually inside the WTDD the join is only defined once because the join works in both directions.

We have included a workbook to list the tables that have not had joins defined yet.

We will be working on these definitions in coming months.

If you want to document joins between tables and send them to us to add to this workbook?

Your time and effort would be much appreciated.

We hope that each WTDD will be released to the public so that the documentation and joins in Business Central are more easily available to the public.

Even if Meta5 can not be used to properly query Business Central directly, the query tool is a great way to write SQL and then update that SQL by hand.

That is what we are using this for in our work.

It has been very effective for this.

With that?

Thank you very much for your time and attention.

We really appreciate you dropping by to read our blogs.

Best Regards.

Mihai Neacsu.

Business Development Manager.

The BIDA Team.

Ask Us Anything

You are welcome to ask us any question you would like below on our contact form.

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

LEAVE A REPLY

Please enter your comment!
Please enter your name here