Why not to touch AX DB directly

I’ve been asked to reiterate some arguments against direct access to AX business data. (As you all know, the recommended approach is always going through AOS, such us calling web services.) Here are some of the arguments: You would bypass all business logic. It often means that you would have to re-implement some AX logic …

Continue reading ‘Why not to touch AX DB directly’ »

Connection to external database

You sometimes need to connect from Dynamics AX to another database and read or write data there. The usual approach uses OdbcConnection class, as described on MSDN in How to: Connect to an External Database from X++ Code [AX 2012]. Although it definitely is a possible solution (I used it already in AX 3.0), it …

Continue reading ‘Connection to external database’ »

Included columns in Dynamics AX 2012

Included columns is a feature of SQL Server (since version 2005) related to indices.Thanks to it you can attach additional fields to an index that are not used for searching (so they don’t have to be maintained so expensively) but that can be used by database server to return data. If all columns being returned …

Continue reading ‘Included columns in Dynamics AX 2012’ »

Included columns v Dynamics AX 2012

Included columns* je schopnost SQL Serveru (od verze 2005) týkající se indexů. Díky ní můžete připojit k indexu další sloupce, které nejsou používány pro vyhledávání (takže se nemusí tak nákladně udržovat), ale které může databáze použít pro vrácení dat. Pokud jsou všechny sloupce vracené dotazem zahrnuty v indexu, databázový server může rovnout vrátit data a …

Continue reading ‘Included columns v Dynamics AX 2012’ »