Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I have 10 years experience with Dynamics AX and my role is a mixture of functional and technical skills.
I worked with AX3.0, AX4.0, AX 5.0 , AX6.0 ( R1,R2,R3)
I always thought that to be a complete functional consultant you would need to understand the "code" behing the scene .
As a matter of fact from a technical side I am able to
- read and understand( where possible) the X++ code ( by using AX debugger tool) or AOT
- able to run massive updates via AX jobs or simple classes
as end user I would provide the AX project to the consultancy company and they would deploy it in Live. Would that work on a D365 on cloud setup?
- able to develop SSRS reports using SQL Server Data tool and Visual Studio.
Reports executed in a replicated database
- use of AOT and study relationship and properties of tables and classes
- monitor SQL live production instance and monitor/improve perfomance
I have no experience whatsover with the D365 on cloud and it seems that Microsoft intent is to provide us ( as customer) a Dynamics AX service vanilla which means
- No access to SQL live produciton
how can we monitor AX performance and understand bottlenecks derived from AX processes OR SQL processes?
- No access to AOT ?
not quite sure if I will have this permissions
- No able to write jobs
working also as support analyist, massive updates is a core request from the business, I don't like tools such Excel or others for massive updates , jobs are the right tool as you can understand exactly what you are going to execute and you can test it using AX dubber.
- no able to debug code?
would I be able to use AX debugger? For my it is the main tool to understand AX logic,Test AX customizations and troubleshoot AX errors.
- No able to develop reports with data in real time via SQL
would we be able to replicate ALL AX datas in a replicated database in real time and build SSRS reports from there or build our BI Cubes?
A lot of doubts.. as you can see.
Yes, infact lot of questions.. let's try to clear them one by one ..may not be able to clear all of them but try to digest the information in smaller chunks.
You best resource from Microsoft:
If you have access to Visual studio you can still read code (I will avoid why read code as i found myself useful at times, others may have different opinion). AOT is still accessible via Visual Studio.
Jobs are replaced by runnable class.. but given the deployment architecture, it's not easy as it used to be in AX2009.. you need to jump lot of hoops to run any kind of jobs in production environment.
SQL access - You have in lower environment, not in production. So you should try to move away from using SQL for anything. You can still access data for reporting using "Excel" (very rich capabilities now), Data Management (forget tables, this should be your new friend if you look at data and it's much simpler than tables, have very right import / export capabilities).
Reporting - can still do via SSRS but there are better tools available including but not limited to Management reporter (financial reporting), Power Bi, BYOD (export data and then access data via sql) and others mechanism that are now coming...
Debugging can still be done,not in production.. request database to lower environment and then if you have VS studio access then you can still troubleshoot.
Make excel your best friend :) and start to use browser more, no more desktop application. There is lot of change in technologies so it will take time. but if you start slowly and steadily, you can jump over all these basic hurdles easily.
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
Too many question in one post , try to keep those in separate post to get better replies.
With D365 you have to make a practice of using extensions instead of overlayering . You can not directly modify Microsoft object , you options are creating extensions , using COC and event handlers . To do all these you have dev machines(Local hosted or deployed through LCS) with visual studio where you can see those objects.
You can still write massive batch operations or use data management or runnable class (job) to do updates.
Deployment is something is done by Microsoft DSE team when you provide them deployable package through LCS service request.
SQL access is present on dev machines and manage environment other than production but with self service deployment which is already enforced for new customers and will be enforced to existing customers from October onwards will no longer have admin access on managed environments and some tooling will be provided on LCS for the task you do using SQL.
Debugging code is still possible on deV machines and you can connect to Database of managed environments(UAT) from dev machine , if you want to debug on most recent prod data , however debugging is slow when you connect UAT database from dev machine (Bringing data from UAT to dev is a pain process that why you have to go with option of direct connection from dev machines some times )
You can do reporting on near real time data using bring your own database (BYOD)concept and power BI. AXDW db or entity store is also available for power BI reporting but you have to develop your own measures and dimensions using perspective node.
As mentioned by Satish docs site is your best resource along with community to get documentation for various different new concepts.
There a lot of questions as I don't know where to start but your feedbacks helped me a lot .
I will now analyse them one by one and raise specific questions.
Thank you for the quick feedbacks .
Business Applications communities