|
|
| Software Information |
|
|
|
|
Microsoft Great Plains Integrations - Tips for Developer
In this short FAQ style article we would like to introduce you - software developer, programmer, database administrator into Microsoft Great Plains Integration tools and options Microsoft Great Plains is main Microsoft Business Solutions product for US mid-market. Historically Great Plains Software designed Great Plains Dynamics and Dynamics C/S+ as multiplatform application and the integration was possible via Great Plains Dexterity or Dexterity-based end user tools, such as Import Utility and later on via Integration Manager. When Microsoft Windows platform won the OS market (the last battle was in 1997 with PowerMac) Great Plains recommended OLE Server approach: Continuum for VB and Delphi and new Microsoft light programming technology - VBA (Visual Basic for Applications), which was integrated into Dexterity application - Great Plains Modifier (requires customization site enabler license). Since then Great Plains Dynamics/eEnterprise integration techniques use Microsoft technologies. 1. Microsoft SQL Server approach. This integration technique uses SQL stored procedures and views to pull data from your legacy or third party application and push it into Great Plains. The nice thing about MS SQL Server - it has linked server technology - you can establish the link to virtually all ODBC ir OLEDB compliant databases: Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Pervasive SQL/Btrieve, Ctree/Faircom, Microsoft Access, Foxpro to name a few. You can schedule your integration as maintenance job or DTS package. However keep in mind that Great Plains tables structure is rather complex (it has master records, summaries, historical, work, open tables) and you should probably verify your stored procedures business logic with Great Plains source code (DYNAMICS.DIC with Dexterity procedures and functions scripts - in regular DYNAMICS.DIC these are stripped out - not every MBS partner has source code subscription - so do your selection work) 2. Great Plains Dexterity integration with Great Plains process server. This is more advanced and recommended approach, however it requires advanced Dexterity programming skills and access to the source code. The idea behind is simple - you populate so-called triggering custom table and then check it from Dexterity custom application every 5 seconds or so. If the record is there - then you process it. Processing is usually Dexterity source code stored procedure call. Great Plains uses similar logic when you post the batch and see the status in Process Monitor window. If you don't have source code - you can try to do the best guess with Microsoft Great Plains Software Development Kit (SDK) 3. Great Plains Integration Manager. This is end user tool and is easy to use. However - it uses Great Plains as OLE Server and calls Great Plains forms behind the scenes. As the result - it is very slow - we recommend using integration manager when you have up to one thousand transactions per day. 4. eConnect ? it is type of Software Development Kit with samples in VB.Net. Obviously the development environment should be Visual Studio.Net. eConnect will allow you to integrate master records - such as new customers, vendors, employees, etc, plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above) eConnect is rather for ongoing integration. It was initially created for eCommerce application integration to Great Plains. Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! [email protected] About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer; [email protected]
|
|
|
|
RELATED ARTICLES
Know Linux Linux essentials: Outlook... Not Just for Email! Using Your Outlook Calendar Microsoft Outlook is one of the most widely used software programs for email, but if you're only using it for email, you're missing out on a great productivity tool! This month's column looks at a few ways you can use the Outlook calendar to make scheduling easier. Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise was introduced in 1993 as first Microsoft Windows and Macintosh based graphical accounting/ERP application for Mid-Size businesses. Considering the history of furniture retailer and custom assembly lines ? they showed up on the market about five decades ago and they have automated their business operations with Unix-based businesses in the late 1960th and earlier 1970th. You can find such furniture resale systems as Storis, which is Unidata based application, automating furniture retail outlets. Let's consider the options. How Do I Get Rid Of That Darn Spyware? Ad-Aware and Spybot are probably the two most well known antispyware solutions. However, they frequently fail to catch the more crafty spyware. Here is a list of five solutions known to get rid of the problem when all others fail. Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0 Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th ? the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6.5, 7.0 and 2000 ? we see more historical custom projects done in SQL stored procedures and front ends coded in VB in Visual Studio 6.0. This was probably wise and natural choice in that time (around 1997-2001), but if you consider Microsoft move to .Net platform and reshaping its own programming environments (ADO, OLE, VB, etc) ? you would nowadays rather be nervous relying on VB 6.0 custom front end, calling stored procs via ADO. Let's consider your options: Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. Great Plains Project accounting future is uncertain - it will not ( according to rumors in Microsoft) become the base for one of the Microsoft suites. However right now it is used by variety of businesses and has good functionality to fit general project accounting needs. Programming Language Migration Path While I was preparing some personal background information for a potential client, I was reviewing all the programming languages that I have had experience with. I list languages that I'm most experienced with on my resume. However, it occured to me that if I was to list all the languages that I've worked with, then the client would become overwhelmed with the resume and just write me off as either a total bit head or looney toons. But as I reflected on all these different environments I realized how much fun I've had being involved with the software development industry, and that a lot of that fun has to do with the learning process. I think this is what makes a good programmer. Not just the ability to write code, or come up with a very creative application, but the ability to learn. Lets admit it! If a programmer doesn't have good learning skills, then the programmer is going to have a very short career. Downloading Spyware Removers: Think Before, not After Just imagine: you are walking, say, towards your car, and all of a sudden somebody comes up to you and begins? polishing your shoes. Or even better example--a guy you've never met before opens the hood of your car, says the engine is broken and tries to persuade you to add some gadget your car desperately needs--and now! What you'd do if such a crazy thing happened? Wouldn't you readily accept the help, paid for it and thank this unknown altruist for his generosity? Why not? Lots of people are doing exactly the same on their PCs. Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation If you would like to pick something from Microsoft, or its ERP subdivision ? Microsoft Business Solutions, and in case of large public company, you should consider these three: Axapta, Navision or Great Plains. We are not talking about Solomon here, because it is recommended for project organization. You should probably be aware about specific product life cycle (or is it new or mature one on the market), database platform, average implementation cycle, typical customization requirements, rich vs. standard ERP functionality, etc. Also you should get comparison from relatively objective source, if you are asking to compare somebody, who implements and sells Great Plains ? more likely these people will try to prove that you need Great Plains and it is the best fit. On the other hand if you ask large consulting practice with regional offices to make comparison for you ? you should know that specific regional office might operate with maximum independence and promote, say Navision only. Imagine if Everyone Working In Your Office Was In Synch? Microsoft-Outlook is a pretty amazing program. So much more than simply an e-mail client, it provides a task list, a powerful calendar with recurring scheduling capabilities, wonderful electronic sticky notes, mail-merge capability with MS-Word support and so much more. Groupware and Version History: Collaboration Series #1 This article is the first of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Some of these characteristics may go hand in hand with business collaborative needs. Other characteristics go beyond what some groupware providers have to offer. The purpose of these articles is to equip the groupware user or investigator with helpful knowledge about the product in order to enable more effective use or to lead the investigator to the groupware service he or she is looking for. This first article explores Version History, a service that can be provided in groupware in order to simplify version tracking. Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution Microsoft CRM and IBM Lotus Notes Domino seem to be taking completely different paths and if company is Microsoft oriented - we see MS CRM, MS Exchange, MS SQL Server, SharePoint, etc. In the case of Lotus Domino - it is opposite - Lotus is corporate Information Media and could technically play CRM role with internal messaging coming through Lotus Domino server. However realities of modern corporation give us multiple examples when Microsoft CRM and Lotus Domino should coexist in compromise. There are several reasons why corporation doesn't like to stick to one platform: How the Firefox: How to... Manual Helped Me A few months back I really got sick of my computer always being slow and having system errors. So I started doing a bit of research and heard of a new browser called "Firefox". Microsoft CRM Modification ? Overview for IT Specialist Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision. Protect Your Computer...and Your Business! We all take the computer for granted. I mean, all we have to do is switch it on and it's ready to go. But did you ever stop to think what would happen if your computer suddenly crashed? And that is the only computer you have to work on! Begun, The Browser Wars Have As Mozilla Firefox nears 10% market share, with well over 25 million downloads direct from the makers website, and goodness knows how many through other sources, Microsoft announces that it will be releasing IE 7 ahead of schedule. Originally scheduled for release with Microsoft's new Longhorn operating system in 2006, it seems that Microsoft are reacting to the run away success that Firefox has had over the last few months. But is Microsoft's announcement just a response to Firefox's success, or is it truly a commitment by the software giant to improve the browsing experience of the masses? Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview In this small article we will show you the possible way of deploying Microsoft Business Solutions Great Plains for the market niche of large, mid-size and small reselling and distribution business in carpeting and floor covering, textile & fabric. We will not be talking about fabric production, but rather cutting for the end-user or small retailer. Microsoft Great Plains itself in our case should be considered as a platform for light customization and modification. We'll describe industry requirements and the way them to be implemented in Great Plains Off The Record - Tips For Picking Recording Software Need software to record your voice, streaming audio or musical instruments? There are dozens of great products on the market. Some cost up to five hundred dollars, but here are some of the low cost alternatives you might want to consider. How To Avoid Getting Hooked By Pfishing "Pfishing", sometimes spelled "Phishing", is a word that's used to describe a method of identity theft where con men use fake e-mail that looks like it comes from legitimate sources. This e-mail is designed to hoodwink you into giving out personal and financial information. Once the scammers receive your information they use it to either clone your identity or to empty out your bank accounts and run up your charge cards. Here are some tips on how to avoid becoming the next victim. S is for Spying, Surveillance -- and for Software as Well Words we choose to describe things and phenomena often show our attitude towards what we say. They imperceptibly reflect our opinions and judgments, prejudices and preferences, moral convictions and beliefs. Whether we like it or not, good deal of words we use are biased, or should I say "slanted", --positively or negatively. Two people will call the same thing differently, depending on their points of view.
|
| home | site map |
| © 2005 |