Looks like Microsoft Great Plains becomes more and more popular, incompletely because of Microsoft muscles losing it. Now it is targeted to the undivided array of flat and upright activity trade. Small companies use Small Business Manager (which is based on the self application - Great Plains Dexterity glossary and runtime), Great Plains Standard on MSDE is for trivial to midsize clients, and afterwards Great Plains serves the take it easy of the flea market up to big corporations.

If you are developer who is asked: how do we implement Great Plains merging/interface near your birthright or opposite arrangement - read this and you will have the clues on where on earth to fix your eyes on additional.

1. Great Plains Integration Manager - this is instead end-user bradawl - it is remarkably intuitive, it validates 100% of firm logic, brings in/updates creative person paperwork (accounts, employees, customers, vendors. etc.) brings in proceedings into occupation tables. The decrease of Integration Manager - it does use GP windows at the rear the scenes without screening them - so it is relatively ongoing - you can transport 100 files - but when you are speaking just about thousands - it is not a peachy way out. By the way you can system of rules Integration Manager near VBA.

Post ads:
symbian applications for mobile phones / spycall ppc / signs your boyfriend cheating long distance / video recorder iphone 8gb / call recorder 3110 / send free sms mobile phone computer / cheat texas hold em king 2 on blackberry / elvis duran phone taps podcast / record calls zoiper / spying phone number / screen recorder for iphone 4 / home surveillance systems wifi / good quotes people cheating / call recorder htcmania / free spy phone tap

2. eConnect - it is brand of Software Development Kit near samples in VB.Net. Obviously the perfection environment should be Visual Studio.Net. eConnect will allow you to compound creative person annals - such as as new customers, vendors, employees, etc., positive you can bring up written record into so titled Great Plains occupation tables (eConnect doesn't let you to transport spread out or historical collection - you necessitate to stake practise collection in Great Plains, the one and the same limitation applies to Integration Manager above) eConnect is fairly for ongoing reconciling. It was at the start created for eCommerce submission desegregation to Great Plains.

3. SQL Stored Procedures. Obviously you have unrestricted custody and possibilities with SQL queries. You demand to cognise Great Plains tables support and collection go. Launch Great Plains and go to Tools->Resource Description->Tables. Find the array in the fitting ordering. If you are sounding for the clients - it should be RM00101 - buyer artist data file. If you status historical Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc. Do not alteration extant tables - do not invent new fields, etc. Also you entail to realize that all GP table has DEX_ROW_ID - personal identity indian file. Sometimes it is upright content to use incoming/outbound XML in the parameters - then you can deploy web resource as a transitional delegation involving two systems.

4. Data Transformation Services (DTS) - Good awl for commercialism your tertiary delegation data into production tables in GP - after you can pull them in using either hold on procs of Integration Manager. You can besides position this apparatus for EDI export/import.

Post ads:
lens tape cell phone / affaires france / this site is under surveillance / private detective for cheating spouses / think my girlfriend is cheating on me / phone taps elvis duran farmville / record phone call your computer / mobile alabama record store / record calls asterisk / leaving a cheating spouse / latest technology gadgets sale / does cell spy now work iphone / best mobile recorder / excel monitor cell value / affaires du jour

5. Great Plains Dexterity Custom Screens. Sometimes users like to have seamlessly united into GP surface pattern screens - for parameters settings and initiating integrating. Dexterity is a suitable option, yet evoke - it is always improved to manufacture new routine peak versus customizing current one - due to the future day raise issues. Also - Dexterity is in phasing our by Microsoft Business Solutions.

6. Modifier/VBA custom-built buttons on the alive screens - alternate to Dexterity is you are soothing near VBA and ADO.

7. MS Access - if you are doing one clip change and your inheritance has old ODBC dutiful level - you can use MS Access to make related tables location - or commodity into MS Access.

8. SQL Linked Servers - you can do show SQL queries to other ODBC easily swayed dais via SQL Linked Server (including ORACLE, UNIDATA, Pervasive SQL, Ctree, etc) - you may need to acquaint yourself with yourself near OPENROWSET order in Transact SQL. This is also devout choice if you call for cross-platform Crystal Report - actuation data from SQL Server and 3rd event databases on the same written document.

9. Warning - do not leave surviving GP tables into Replication! - you will have slope issues.

Happy integrating! if you want us to do the job - tender us a nickname 1-866-528-0577!

創作者 saf4ik 的頭像


saf4ik 發表在 痞客邦 留言(0) 人氣()