Dear pro
We have Sales force automation purchased it in Microsoft partner to be integrated with AX but this integrates by database level by stored procedure.
When you review integration documentation file sent by this partner, find the following :-
- Update Dynamics AX 2012 data from (Application Name) using stored procedures.
- An example of those business rules as we will see in the order header and order details, the primary key of the order header table [SALESTable] is ([DATAAREAID],[SALESID]) while the primary key of the detail table [SalesLine] is ([DATAAREAID],[INVENTTRANSID]) , the InventTransID is something generated by AX and SB would never have a clue how it is generated.
- In the (Application Name) documentation I found the examples for stored procedures “LoadOutstandingInvoices” SP and I checked the (Application Name) database stored procedures and I found it matches the previous meaning of the stored procedure
- Our hope is that business connector would manage those extra fields and generate their values automatically.
That is mean the below integration process will not use the Dynamics Validations or data Structure and by the way that will cause a total disaster on the solution by short and long run.
The Microsoft Recommendation is very clear for any Integration process used Application Integration Framework.
kindly quickly support and advise with regard to this integration.
