Best Internet 4 U Info
Welcome to Best Internet 4 U Info!

Technology Articles


Microsoft Great Plains Data Conversion ? overview for developers
By Andrew Karasev


Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.

If you are developer who is asked: how do we convert our old system data for initial Great Plains setup ? read this and you will have the clues on where to look further.

Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables. The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records for ongoing integration - for one-time conversion/integration you are probably OK with IM. By the way you can program Integration Manager with VBA.

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.

SQL Stored Procedures. Obviously you have unlimited control and possibilities with SQL queries. You need to know Great Plains tables structure and data flow. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc. Do not change existing tables - do not create new fields, etc. Also you need to realize that each GP table has DEX_ROW_ID - identity column. For ongoing integrations - sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems.

Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager. You can also deploy this tool for EDI export/import.

Great Plains Dexterity Conversion Utilities. If your legacy data sits in old Dexterity customization on Ctree/Pervasice.SQL/Btrieve - you can create custom Dexterity conversion utility, which will read the table in Ctree/Btrieve and will move it to SQL based new custom Dexterity table. In this scenario - you need Dexterity customization upgrade as well. (Great Plains Dexterity - is programming language and technology of former Great Plains Software - Microsoft Great Plains is written in Dexterity)

MS Access ? if you are doing one time conversion and your legacy has old ODBC compliant platform - you can use MS Access to create linked tables there - or import into MS Access.

SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including ORACLE, UNIDATA, Pervasive SQL, Ctree, etc) - you may need to familiarize yourself with OPENROWSET command in Transact SQL. This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report.

MS Excel - yes - sometime you can use it for legacy data massage before feeding it into Great Plains.

Warning - do not place existing GP tables into Replication! - you will have upgrade issues.

Happy converting! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

For more information about this article and/or the author visit mailto:help@albaspectrum.com

For more information, news and articles see:

Lineshaft - Lineshaft
...purchase a lineshaft for your business you want the very best. Whether you require one for simply moving objects from A to B, for use on production or packaging lines and even on order picking statio...
Visit Lineshaft...

3d Images - 3d Images
...y briefed on the property brochure we were producing for a well known developer, having just six months to get the whole thing done in time for the launch of the new estate the pressure was on and we ...
Visit 3d Images...

Test Automation Tools - Test Automation Tools
...tion Tools are the software or programs used in the performance testing of software automatically. Test Automation Tools actually control the execution of tests, the comparison of actual end product t...
Visit Test Automation Tools...

Police Earpiece - Police Earpiece
...re`s no average day for a police officer as they just never know what they`ll be facing when they report for duty. One day they could be stopping motorists to check their vehicles and the next they m...
Visit Police Earpiece...

Rack Mount Pc - Rack Mount Pc
...ou can create a little extra space for your workers. You have toyed with the idea of installing rack mounted computers that could be the ideal solution to your problem. Within sturdy racking a numbe...
Visit Rack Mount Pc...

Clive Roberts - Clive Roberts
...VB6 project to deliver a front-end application to Local Government. Councillors used the application during their `surgeries` with the public to record details of the meetings, take actions including ...
Visit Clive Roberts...

Prototype - Prototype
...pe to move your product forward you`ll find companies like Thompson Precision can do precisely that. They have been working in the engineering business for many years know and they can help you to pr...
Visit Prototype...

Automated Software Testing - Automated Software Testing
...the quality of the product or service and the performance of the same. Software testing also find out whether the objective of the software has rightly achieved or not and it provides an insightful an...
Visit Automated Software Testing...

Solid State Relay - Solid State Relay
... Solid state relay switches all over the world. Solid state relay is a fairly new invention in the engineering world, but it is an invention that has categorically changed the face of the engineering ...
Visit Solid State Relay...

Epos Tills - Epos Tills
...to get some cheap clothes for myself and my family to take on our annual summer holidays. There are some amazing bargains to be had in shops like this and it really is worth the horrendous queues you...
Visit Epos Tills...

It Consultants London - It Consultants London
...ery comprehensive service and they`ll be able to find suitable solutions for companies that will be perfect for their needs. it consultants london can help to support existing systems or can recommen...
Visit It Consultants London...

Reed Switch - Gettign The Right Reed Switch
... case. Within this case, these blades are held a particular distance apart while the case protects the contacts from corrosion because outside air can`t reach inside. The contacts extend outside the c...
Visit Reed Switch...

Meade Telescope - Meade Telescope
...y my brother has loved astronomy and all things to do with stars. At first my parents thought it was quite a strange hobby for him to get into but, over the years, his dedication to the field has rea...
Visit Meade Telescope...

Air Conditioner - Air Conditioner
...he rain we`ve had so far. June was indifferent, air conditioner July was a washout and August is proving to be a bit hit and miss....
Visit Air Conditioner...

Hard Drive Disposal - Hard Drive Disposal
...ge order for state-of-the?art replacements. This presents you with a problem as you have information stored on the hard drives of the computers that needs to be disposed of in a safe and secure manne...
Visit Hard Drive Disposal...

Network Cabling - Network Cabling
...w important it is for their customers to have the cables installed on time and within the set budgets. Whether the network cabling requirements are for fibre optic, electrical or phone systems and s...
Visit Network Cabling...

Cr2032 Battery - Cr2032 Battery
...te control on your car`s key fob stopped working recently? When you press the open button nothing happens and you now have to manually use the key to access the building. Chances are the cr2032 batt...
Visit Cr2032 Battery...

Cnc Turning - Cnc Turning
...f routing would have been carried out by a carpenter in a workshop. These days a workshop might still be involved but a machine will carry out the process. Moreover, the machine will be receiving its...
Visit Cnc Turning...

Pallet Conveyors - Pallet Conveyors
...tes pallet conveyors at the local factory. He has to make sure that the pallet conveyors are working property as well as using them to ensure that they do their job properly. Although his job is not...
Visit Pallet Conveyors...

Industrial Ethernet Switch - Industrial Ethernet Switch
...e Industrial Ethernet Switch from Korenix is ideal in dusty or dirty scenarios. Information won`t be interrupted at all when this type of switch is in action and you can imagine that the services pro...
Visit Industrial Ethernet Switch...

Cisco Training - Cisco Training
...cations to make it happen? Don`t worry if you find that your qualifications fall short of the mark because there are training courses you can take part in that will provide you with all the necessary...
Visit Cisco Training...

Exhibition Stand Design - Exhibition Stand Design
...wing together a couple of tables, plonking a Television and VCR on top and blue-tacking some posters to display boards at the back. A thoughtful and professional Exhibition Stand Design can make the ...
Visit Exhibition Stand Design...

Exhibition Services - Exhibition Services
...rs exhibition services for large companies who want to put on exhibitions in various locations up and down the country. The exhibition services they offer cover a wide range of things from stands t...
Visit Exhibition Services...

Bluetooth Earpiece - Bluetooth Earpiece
... a difference to her life. Before she got the Bluetooth Earpiece she had to carry her phone with her everywhere and often, she told me that she would end up cutting people off before speaking to them...
Visit Bluetooth Earpiece...

Pre Term Fibre - Pre Term Fibre
... for a computer cable company and he is responsible for installing the pre term fibre in offices around the city centre of Manchester. He really enjoys his job, particularly because installing pre te...
Visit Pre Term Fibre...

Fibre Patch Leads - Fibre Patch Leads
...alternatives as they are far lighter that their copper colleagues. What`s more, Fibre Patch Leads can be easier to install than copper leads and anyone who works within computer-related industries wi...
Visit Fibre Patch Leads...

Telescopes - Telescopes
...question about the Milky Way they will be able to answer all queries. To gaze at the stars powerful Telescopes are used and they can help people of all ages look into the night sky. It`s a fascinati...
Visit Telescopes...

Cat5e Cable - Cat5e Cable
... sometimes known is an industry standard type of manufactured cable used to create computer and telephone networks. Computer networks can be found in office buildings throughout the world and most of ...
Visit Cat5e Cable...

Small Pc - Small Pc
...days of the monstrous towering PC`s that used to take up half of your desk. Today with a Small PC you can reclaim valuable desk space, also a Small PC looks a lot neater than its contemparory full si...
Visit Small Pc...

Hard Drive Destruction - Hard Drive Destruction
...ormation that was stored on your company`s hard drives fell into the wrong hands? Your competitors would have a field day with their newfound knowledge and your business would suffer as a result. Th...
Visit Hard Drive Destruction...

Software Engineer - Software Engineer
...nd polishing it, as if it were a wooden sculpture, not a series of logic instructions. The problem here is that you cannot engineer art. Programming falls somewhere between an art and a science....
Visit Software Engineer...

Embedded Computers - Embedded Computers
...can benefit from their technology right from the start. The world wide-web is the place to look for new embedded computers because on the internet there are companies that supply some of the best syst...
Visit Embedded Computers...

Syma Spare Parts - Syma Spare Parts
...Apache helicopter and since Christmas he`s managed to master the controls. When he first got the machine he did struggle at first learning how to control it in a smooth manner. Due to this the helic...
Visit Syma Spare Parts...

Air Conditioning Hampshire - Air Conditioning Hampshire
...ioning can help when things become a little unbearable and for offices in the South of the county, air conditioning hampshire can be ideal. Currently plenty of offices that are South of the border ar...
Visit Air Conditioning Hampshire...

Computer Network Support - Computer Network Support
...s the chances are you`ll need some form of computer network support to help with your company`s systems. Larger organizations tend to have their own IT techies who know all there is to know about net...
Visit Computer Network Support...

Computer Training - Computer Training
... rely on them over the past few years. Imagine not being able to surf the web when you liked or type word documents as part of your daily duties? Due to the fact that we have become so reliant on com...
Visit Computer Training...

3d Building Rendering - 3d Building Rendering
...use to market potential developments. They no longer have to use rather dreary plans to promote their schemes; they can use a 3d Building renderingservice instead. This process uses computer imagery...
Visit 3d Building Rendering...

Restaurant Tills - Restaurant Tills
...less likely you are to be able to view the Restaurant tills. Obviously, if you are in a high street burger chain then the Restaurant tills are one of the most obvious features in the room with a plet...
Visit Restaurant Tills...


Click For More Detailed Information on:
prevent future ::easy phone internet ::machines computers ::your plasma for you ::my care computers ::your tech science ::mean science pro ::trchnology website ::big pacing pro ::interior space

Home  |  About Us  |  Contact Us  |  Articles  |  Special Reports  |  Links  |  Site Map

Copyright © 2003-2012. All Rights Reserved.


Valid CSS!