Rating
Dynamism
Dynamism
Great Plains Partner Newsflash: Dynamics GP Large Scale Ongoing Integration
Microsoft Dynamics GP or former Great Plains Dynamics and eEnterprise should be a good fit for large organization, where you may need in high volume EDI integration to Great Plains from your Electronic Document Interchange order placement channel. If you have very strong internal IT team with Microsoft Visual Studio .Net C# or VB programmers with good SQL scripting background, you can decide to program integration in Dynamics GP eConnect SDK. In this small publication we are describing bullet proof method of deploying Dynamics GP Integration Manager module:
1. Integration Source. In simple ad-hoc integrations you typically work with tab or comma delimited text files. In the case of large volume integration you typically have to deploy more advanced ODBC compliant connection. In Dynamics GP Integration Manager this is Advanced ODBC. Please, follow these steps: create new integration, name it and right click on Sources, add source, select Advanced ODBC and Define New Advanced ODBC, select ODBC Data Source (this is what you have already defined in your computer registry, Oracle Sales for example to get connected to your Oracle Custom Sales Order Processing database and application), in the SQL Statement edit area type in something like this: Select * from SalesOrders. In this case we assume that SalesOrders is either Oracle table or Oracle View. With Advanced ODBC Dynamics GP data source you can do pretty much what SQL is about: union, group by, sum, where, join, you name it. We recommend you to create SQL linked server construction in your Microsoft SQL Server 2005 or 2000, where you create heterogeneous query to Oracle, mySQL, Ingress, DB2 database, and enjoy the flexibility of Microsoft SQL Server Stored Procedure
2. Integration Destination. Here for Dynamics GP 10.0 you have two options: Microsoft Dynamics GP and Microsoft Dynamics GP eConnnect. There is the difference between the two. Microsoft Dynamics GP is built upon OLE Server and as such it deploys your Great Plains user workstation to push data into Dynamics GP. As you can imagine OLE server is ancient technology and it is deploying the whole stack of layers to get final call (on Great Plains Dexterity level). eConnect is new and cool thing (based on direct encrypted SQL stored procedures). When you select either one of the destination adapters, then you are in normal realm of Dynamics GP modules: SOP (typically targeted in eCommerce applications), POP, GL, Payroll, etc. Please, be aware that eConnect adapter requires company database name (in comparison to OLE adapter, where company name is taken from your user login context)
3. Destination Mapping. Here you can further customize integration logic by applying VBA scripts and translations. Follow this methodic: for the chosen field, change rule to Use Script, then on the left side click on the expansion button to the script value (default No) and in Script Editor demonstrate your VBA scripting skills. For Dynamics GP VBA scripting instructions, please open Great Plains Integration Manager Guide. In IM help -> Index, the using scripts or VBScripts objects. Another good advise: C:Program Files (x86)Microsoft DynamicsIntegration Manager 10helpdocumentation and open IMUserGuide.pdf book. Here you will have a lot of fun on practicing VBA scripts for Dynamics GP objects as well as doing Translation for object names in IM
About the Author
Andrew Karasev, Alba Spectrum LLC. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577. Web portal: http://www.pegasplanet.com We are Microsoft Dynamics GP technology partner, ERP and software integrator, who serves you USA, Canada, Mexico and Latin America nationwide. Local service is available in Chicago, San Diego, Los Angeles, Houston. We have customer in the following business metros: Phoenix, New York, Boston, Milwaukee, Buffalo, Rhino, San Jose, Miami, Atlanta, Minneapolis, San Francisco, Detroit, Montreal, Las Vegas, Oceania, Colombia, Caribbean, Poland, UK, New Zealand, Australia
Compiling Dynamic Languages
|
|
Dynamism $8.99 … |
|
|
Dynamism $9.00 All products are BRAND NEW and factory sealed. Fast shipping and 100% Satisfaction Guaranteed…. |
|
|
Dynamism EP $4.95 … |
|
|
Maximum Performance Success in America Seven Steps to Mental Fitness $9.97 Why do some people out perform others by two, three, even ten times? In this exciting program, Brian Tracy teaches you the specific methods and techniques for peak performance practiced by all high achieving men and women. This program is based on the practical experiences and behaviors of thousands of the top people in every field. You learn how to develop a blueprint for success and achieveme… |
|
|
Caviar Ampouled Serum Super Concentrate. Suitable for Galvanic, Microcurrent, Micro Neeldling $29.00 Caviar Complex is a skin-care concentration based on a special extract derived from Zoo-Plankton Artemia Saline. It is highly effective in treating damaged, stressed, dry skin and hair with an outstanding protection before and after UV irradiation. Caviar Extract implements a real potential of energy, life and dynamism for the cutaneous cells. Caviar Complex. For the natural restoration of the ski… |
|
|
Panier Des Sens Liquid Marseille Soap Soothing Provencal $19.50 This Provence extract contains lemon, artemisiaand cypress essential oils. This organic liquid soap is inspired by an irresistible journey in Provence. It gently cleanses the skin and helps to preserve its natural balance. The citrus essential oils quicken body dynamism with their fruity and sunny scents . They help to reduce tiredness by waking up the epidermis. The cypress essential oil brings p… |
|
|
Boss Orange Sunset by Hugo Boss Vial (sample) .06 oz $1.50 Boss Orange Sunset by Hugo Boss was launched in 2010 for the vivacious and the flirty beauties. Embracing the beauty of the sunset and the dynamism of the citrus splurge this fragrance is for the zealous women. The advertising face of this attention-grabbing aroma is Sienna Miller. The top notes of the fragrance open to the energizing accords of bergamot and mandarin orange. The white floral heart… |
|
|
Dynamism Weimaraner – 24W x 16H – Peel and Stick Wall Decal by Wallmonkeys $33.99 WallMonkeys wall graphics are printed on the highest quality re-positionable, self-adhesive fabric paper. Each order is printed in-house and on-demand. WallMonkeys uses premium materials & state-of-the-art production technologies. Our white fabric material is superior to vinyl decals. You can literally see and feel the difference. Our wall graphics apply in minutes and won’t damage your paint or l… |
|
|
Business Leaders 2 – 24H x 17W – Peel and Stick Wall Decal by Wallmonkeys $33.99 WallMonkeys wall graphics are printed on the highest quality re-positionable, self-adhesive fabric paper. Each order is printed in-house and on-demand. WallMonkeys uses premium materials & state-of-the-art production technologies. Our white fabric material is superior to vinyl decals. You can literally see and feel the difference. Our wall graphics apply in minutes and won’t damage your paint or l… |
|
|
Photovoltaic Panels – 24W x 16H – Peel and Stick Wall Decal by Wallmonkeys $33.99 WallMonkeys wall graphics are printed on the highest quality re-positionable, self-adhesive fabric paper. Each order is printed in-house and on-demand. WallMonkeys uses premium materials & state-of-the-art production technologies. Our white fabric material is superior to vinyl decals. You can literally see and feel the difference. Our wall graphics apply in minutes and won’t damage your paint or l… |
Have A Question?
Are you looking for something but can not find it, or have a question for us? We would love to help you. Just fill out the form below and we will get back to you as soon as possible.
