| Home | Links |
Microsoft Great Plains Integrations Tips Developer Software
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! help@albaspectrum.com
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; akarasev@albaspectrum.com
Oakland police get free forensic software to analyze Occupy videos San Francisco Chronicle (blog) A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ... |
Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012 Reuters SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ... Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ... Advent Software's CEO Discusses Q4 2011 Results - Earnings Call Transcript Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick Facts |
Scorpion Software Announces AuthAnvil Single Sign On Support for Level ... San Francisco Chronicle (press release) Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ... Scorpion Software Offers Support for Level Platforms Managed Workplace |
Caduceus Software Plans to Integrate a Cloud Platform with its Software ... SmallCap Network By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems. Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ... QualityStocks News - Caduceus Software Systems Provides Update on Current ... |
Law Offices of Howard G. Smith Announces Investigation of JDA Software Group, Inc. Business Wire (press release) (BUSINESS WIRE)--Law Offices of Howard G. Smith announces that it is investigating potential claims on behalf of purchasers of the securities of JDA Software Group, Inc. (“JDA” or the “Company”) (NASDAQ:JDAS) concerning possible violations of federal ... JDA SOFTWARE GROUP INC: Law Offices of Howard G. Smith Announces Investiga.. |
Proposal Software Continues Strong SaaS Revenue Growth in 2011 MarketWatch (press release) WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ... |
Manhattan Software Announces Strategic Partnership With Indiabulls for ... MarketWatch (press release) 6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ... |
Mezeo Software Announces National Master Distributor for Japan MarketWatch (press release) HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ... |
The Cloud Software Companies You Need to Know About Motley Fool But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ... |
Is BMC Software Growing or Slowing? DailyFinance By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ... |
Google News
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.
Common misspellings for words used in this page include abilty accoring acording adavanced adminstrator adn ahev ahppen ahve alternitives alwasy alwyas amke anbd aplication applicaiton artical artice articel asociated assoicated attitide awya baceause backgorund bakc baout bcak beacuse becasue beccause becouse becuase bedore befoer beng breif buisness busineses busness bussiness calander caperbility charistics cmoputer collaberative comany comapany comming committment comparision completelyl concider concidered consdider consdidered consdiered considerd consideres coputer corparate coudl creaeted dael decribe delevopment descuss desgined dessigned developement develpment devolopement diea diferent diferrent differnt diffrent discribe distrubution doign donig dowloads ealier eiter ened enviorment enviorments enviornment enviornments enviroment enviroments envrionments enxt eveyr experiance experianced expierence eyars eyasr fidn finacial fomr frequentily frome gerat gogin goign gonig graet grat haev hapen heared helpfull herad howver hstory hten htere htey htikn hting htink htis hvae hvaing hvea hwihc idaeidae implimented inctroduce inctroduced indepedence independance independece indipendence infomation informtion initally inot intergrated intergration intially intrduced introdued intruduced inudstry itnroduced iwll iwth jstu jsut knowlege knwo knwos konw konws kwno laguages larg lastr legitamate legitmate liek liuke lsat maintainance maintainence maintance maintenence makse marketting messenging milion millon mkae mkaes mkea monts moreso mroe muscial naturual nkow nkwo nmae nowdays nowe nto oftenly oging omre onyl oposite orginally origanaly originall originaly originially originnally orignally orignially otehr owrk owudl paide pary payed peopel peronal phenonmena possable possibile poverful poweful powerfull pratice probablly probaly probelm proccess procedger proceedure proces proove provded pursuade raelly reaccurring realitvely realy realyl reasearch reccomend reccomended reccommend reccommended reccuring recieve recomend recomended recrod recuring refect regluar relaly relativly relitavely reponse responce rocord rwite sasy schedual severeal sevice shoudl shoudln similiar simmilar smae smoe soem sofware sohw somtimes sotry sould specfic specif spects stlye stopry stoyr stpo stroy stucture sturcture succesfully succesfuly successully succsess sucesfully sucesfuly sucess sucessfully sucessfuly syas sytem sytle tahn taht tath techiniques technnology technolgy teh tehy tghe thast theese ther theri thgat thge thier thign thigns thigsn thikn thiunk thn thna thne thnig thnigs thrid thru thsi thta thyat tiem tihkn tihs timne tiome tje tjhe tkae tkaing tlaking towords truely twpo tyhat tyhe typcial uise unkown unsed usally useing usualy ususally variey varity vell verison veyr vreity vrey vriety vyer vyre waht wass watn weas wehn whant whcih whic whihc whith whlch whn whta wich wih wiht wille witht witn wiull wnat wokr wonderfull woudl wriet wrok ws wtih yeasr yeras yersa ytou yuo.