Microsoft Dynamics Gp version 10.0 advanced such new technologies as eConnect in and this seems to be general trend to walk away from proprietary tools, such as Microsoft Dexterity to Microsoft definite platforms, such as .Net, Com+ and Ms Sql Server Stored Procedures, as you know eConnect core contains encrypted stored procs. Historically Great Plains Im was based on Ole technology, where Gp workstation was used as Ole server and business logic validation was done in Gp forms, where Ole mechanism was entering fields values. Let's take a look at new and primary features ready in Im version 10.0, it is in our idea in transition to be rewritten wholly in eConnect, but at this time it is ready with both primary and eConnect connectors:
1. Econnect connector. For Gp consultants, you should be aware that eConnect connector requires definite company, if you remember how Ole connector works - it recognizes the company, from where you call Integration owner and so you do not need to specify the business in integration settings. eConnect requires the business target to be specified. eConnect integration carrying out should be higher comparing to primary connector, as eConnect doesn't use slow Ole technology and imitates business logic (or in other words it replicates Dexterity functionality) in Sql stored procedures (which are performed on the server). Typical Gp integrations involve Sales Order Processing module (this includes eCommerce scenarios) as well as buy Order Processing module (where you merge Edi vendor invoices, for example) and at this time, Gp Im 10.0 eConnect connector enables these integrations, which is very optimistic note
2 Post Server Rack
2. Im upgrade. Typical scenarios are when you are upgrading skipping two versions, let's say from Gp Im 7.5 to 10.0. In this scenario you need to do two steps upgrade - first to Gp Im 9.0 and then to 10.0
3. Vba programming for Integration Manager. This technology may seem outdated as Vba was favorite in late 1990th to automate Ms Excel and Ms way type of scenarios. any way Vba and Modifier modules are still ready with Microsoft Dynamics Gp buy or upgrade. Vba scripting is event driven one, so you should divulge the options to alter Im business logic on pre and post integration, pre and post document. This record format is short and we can not give you sample Vba scripts here, any way if you have amelioration allocation and would like to get advanced technical and programming help, we would be happy to help you
4. Gp Im advanced techniques. Translation technology. Each field is ready for translation logic. You can load Excel translation table to Im directly. Translation logic allows you to map external item amount id to your internal one, or in range department example it allows you to translate vendor it to buyer id, as range business is reversed one, where sales means collection
5. Im in cross platform integrations, here we need to stress Odbc acceptable and advanced integrations. Microsoft Sql Server 2000 and 2005 related server building allows you to deploy either direct Sql adopt statement or Openrowset one. Now is you are coming from Oracle and Oracle Ebusiness Suite world, similar integration idea is ready from Oracle Edi. If you are on Linux Red Hut and Php and MySql, please think Odbc bridge or motion to Java technology. If you Php is sitting on Ms Windows platform you can deploy direct call to Ms Sql Server 2005 or 2000
6. Gp data conversion and Integration Manager. heritage data massage, conversion, is ready and Im usage is very helpful. Microsoft Dynamics Gp offers Im installation or first migration license, which is itsybitsy to the amount of days
7. The most favorite Integration Tables in Great Plains: Sop10100, Sop10200, Rm00101, Rm00102
8. Integration owner and Great Plains Dexterity connections: Dex_Row_Id is one of the most favorite questions among the developers community. If you do direct Sql insert statement feed into Gp tables, Dex_Row_Id is outoincremental and so you don't need to populate it
9. Gp and Ms Crm connector. It is outside of Gp Im, so please do not be confused. Ms Crm association business is pretty much taken over by Scribe Software, so please check with these folks first. Also, Sap business One is very favorite small business Erp and Mrp (Manufacturing module and extensions) platform, where you can have Microsoft Crm to be integrated. From Microsoft Dynamics Crm side you can use Sql views and stored procedures to store exported data in the convention database, and from Sb1 side you use Sap B1 Sdk to schedule Sb1 integrated objects: Sales Orders or Sales Invoices
10. Xml Web service Approach. As Xml is in essence text, it is the platform independent data (or text files) stream. To open Web service to Unix client, from Gp side you typically involve C3 or Vb.Net developer
11. Im end remarks. Great Plains Integration owner is both end user and developer amiable tool. If you are Vba or Microsoft.Net programmer you should be able to build sound integration on Im platform. eConnect will more likely be the main Im transformation technology, so if you are deploying Im integrating techniques, you should effect eConnect news
Microsoft Great Plains Integration employer 10.0 Technical Notes
No comments:
Post a Comment