Tip: How to See Database Tables in D365 for Finance and Operations―Without VSTS

In AX2012 and prior, users could just go into the Application Object Tree (AOT) to see database tables, but the AOT is not available in D365. So the reason this tip is really cool is that up until this point, we all thought it was necessary to have Visual Studio Team Services (VSTS) installed in order to see D365 database tables. This requires a license for each user, so it is an additional expense. However, by installing a Chrome extension, it is possible to view and even edit table data without VSTS.

Here are some quick steps:

1. Go to: https://chrome.google.com/webstore/detail/table-browser-caller-for/nahbldacmaibopfiiaoboloegpobpccn  and install it.
2. This adds a Table Browser Caller shortcut.
3. Launch the shortcut.
4. Select the Config tab.
5. Click the plus (+) sign to add a new D365 URL.
6. Back on the Table Browser Caller tab, enter the table name for which you want to view data and then click the lookup/magnifying glass icon.  Alternatively, if you don't know the table name, you can click Table List and select a table that way.
7. This will launch a new browser tab displaying the data for the selected table.
8. At this point, the data is view-only.  However, if you change "true" to "false" in the URL, the data is then editable... except in a production environment.

Here the tracking number shows the status of the order lifecycle with real-time information on the delivery, where it can pull in the delivery status from the logistics provider. Pretty cool!