Microsoft Dynamics Blog

Welcome to Armanino’s Microsoft Dynamics Blog, where you’ll find information on topics across Microsoft Dynamics 365 ERP and CRM, Dynamics GP, Power BI, PowerApps, Flow and more. Use these tips, tricks and insights to get the most out of your applications! Want these articles delivered straight to your inbox? Subscribe to our newsletter below.

Monday, June 18, 2018

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

Posted by Sandy Strong

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:
    Screenshot of the new Table Browser Shortcut
  3. Launch the shortcut.
  4. Select the Config tab:
    Launch the Config Tab in D365 Screenshot
  5. Click the plus (+) sign to add a new D365 URL:
    Adding a new D365 URL under Config Screenshot
  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.
    Enter table name in the Table Browser Caller Tab Screenshot
  7. This will launch a new browser tab displaying the data for the selected table:
    New Browser Tab that Displays Data for the Selected Table in D365 Screenshot
  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:
    Data View URL Screenshot

COMMENTS

comments powered by Disqus
« | »