Book a Demo

Author Topic: MS Dynamics Reverse Engineering  (Read 4102 times)

Matt@NWIS

  • EA Novice
  • *
  • Posts: 3
  • Karma: +1/-0
    • View Profile
MS Dynamics Reverse Engineering
« on: April 09, 2021, 09:11:59 pm »
Crazy thought : anyone have experience of using EA's reverse engineering on a Microsoft Dynamics CRM implementation?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: MS Dynamics Reverse Engineering
« Reply #1 on: April 10, 2021, 12:36:40 am »
We reverse engineered the databases (AX and SDAS in SQL server) and I wrote a tool to import the relations from the .erx (Erwin) export out of AX.
https://github.com/GeertBellekens/Enterprise-Architect-Toolpack/tree/master/ERXImporter

This gives us the database including relations (since there are no foreign keys on the database)

Geert

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: MS Dynamics Reverse Engineering
« Reply #2 on: April 10, 2021, 11:55:26 am »
Crazy thought : anyone have experience of using EA's reverse engineering on a Microsoft Dynamics CRM implementation?
Sorry not tried that but does sound crazy idea as I thought a standard clause in most licence agreements is you weren't allowed to reverse engineer the software. So best advice is check the licence agreement on MS Dynamics CRM and if it does have a clause about not reverse engineering the software don't do it.
Happy to help
:)

Matt@NWIS

  • EA Novice
  • *
  • Posts: 3
  • Karma: +1/-0
    • View Profile
Re: MS Dynamics Reverse Engineering
« Reply #3 on: April 12, 2021, 09:13:11 pm »
Quote
Sorry not tried that but does sound crazy idea as I thought a standard clause in most licence agreements is you weren't allowed to reverse engineer the software. So best advice is check the licence agreement on MS Dynamics CRM and if it does have a clause about not reverse engineering the software don't do it.

Ah - there's a difference though (isn't there?) between the (correctly observed) illegal reverse engineering of core product, and the reverse engineering of your own IP that has been implemented on that core product. Of course, in trying to get the latter one should avoid getting the former.

Quote
Thanks Geert

Presumably, to address Sunshine's real concern, you can be selective in what you import?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: MS Dynamics Reverse Engineering
« Reply #4 on: April 13, 2021, 01:11:16 am »
Presumably, to address Sunshine's real concern, you can be selective in what you import?
Our partner delivers a DDL with only the tables used by our application. (we don't need the table for the Russian tax on alcohol, and others like that :))
Creating a model of their SQL database is probably not against the rules (I suppose)
The ERX is created with standard tool provided by MS Dynamics for the exact purpose of getting a model of the tables and the relations (in Erwin)
Can't see how using that info to create a model in EA could violate any rules.

Geert

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: MS Dynamics Reverse Engineering
« Reply #5 on: April 13, 2021, 10:14:41 am »
Ah - there's a difference though (isn't there?) between the (correctly observed) illegal reverse engineering of core product, and the reverse engineering of your own IP that has been implemented on that core product. Of course, in trying to get the latter one should avoid getting the former.
Yes, but can you actually extract your IP without some level of reverse engineering of the core product? You are reverse engineering how the core product reads and writes in order to determine the meaning of the contents.

It would appear to be a grey area.

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: MS Dynamics Reverse Engineering
« Reply #6 on: April 14, 2021, 12:00:21 pm »
Quote
Sorry not tried that but does sound crazy idea as I thought a standard clause in most licence agreements is you weren't allowed to reverse engineer the software. So best advice is check the licence agreement on MS Dynamics CRM and if it does have a clause about not reverse engineering the software don't do it.

Ah - there's a difference though (isn't there?) between the (correctly observed) illegal reverse engineering of core product, and the reverse engineering of your own IP that has been implemented on that core product. Of course, in trying to get the latter one should avoid getting the former.

Quote
Thanks Geert

Presumably, to address Sunshine's real concern, you can be selective in what you import?
Now the truth of the matter is coming out with more information.  :)
How is your IP implemented in Dynamics? I recall may years back there was a way to configure Dynamics with custom tables,screens etc. however I believe there is a way to use PowerApps to customise it now.
Happy to help
:)