and many others.) brings in transactions into function tables. The limitation of Integration Supervisor - it does use GP windows behind the scenes with no showing them - so it is relatively sluggish - you can bring one hundred data - but when you are speaking about countless numbers - it is not a very good option. By the way you can system Integration Manager with VBA.

2.eConnect - it is form of Software package Advancement Kit with samples in VB.Internet. Obviously the advancement surroundings need to be Visual Studio.Internet. eConnect will allow you to integrate master data - this kind of as new clients, distributors, personnel, etc., furthermore you can provide transactions into so named Great Plains function tables (eConnect doesn't allow you to carry open up or historical documents - you want to post function information in Great Plains, the exact same limitation applies to Integration Supervisor over) eConnect is rather for ongoing integration. It was at first designed for eCommerce software integration to Fantastic Plains.

three.SQL Saved Methods. Naturally you have limitless management and possibilities with SQL queries. You want to know Great Plains tables framework and information movement. Launch Excellent Plains and go to Equipment->Resource Description->Tables. Locate the table in the appropriate sequence. If you are hunting for the customers - it ought to be RM00101 - client grasp file. If you need to have historical Product sales Order Processing paperwork - they are in SOP30200 - Income Background Header file, and so forth. Do not transform existing tables - do not develop new fields, and so on. Also you require to understand that every GP table has DEX_ROW_ID - identity column. Sometimes it is great concept to use inbound/outbound XML in the parameters - then you can deploy world wide web service as a middle get together in between two techniques.

4.Knowledge Transformation Solutions (DTS) - Very good instrument for importing your 3rd celebration info into staging tables in GP - then you can pull them in making use of both saved procs of Integration Supervisor. You can also deploy this device for EDI export/import.

5.Great Plains Dexterity Custom Screens. At times consumers prefer to have seamlessly integrated into GP interface custom made screens - for parameters settings and initiating integration. Dexterity is a excellent option, nevertheless bear in mind - it is usually much better to produce new custom made display versus customizing present a single - due to the foreseeable future upgrade concerns. Also - Dexterity is in phasing our by Microsoft Enterprise Answers.

six.Modifier/VBA custom buttons on the present screens - option to Dexterity is you are at ease with VBA and ADO.

7.MS Obtain - if you are carrying out one time conversion and your legacy has previous ODBC compliant platform - you can use MS Access to develop joined tables there - or import into MS Accessibility.

eight.SQL Joined Servers - you can do immediate SQL queries to other ODBC compliant platform by way of SQL Connected Server (including ORACLE, UNIDATA, Pervasive SQL, Ctree, and so forth) - you might want to familiarize oneself with OPENROWSET command in Transact SQL. This is also very good alternative if you need cross-platform Crystal Report - pulling info from SQL Server and third social gathering databases on the very same report.

nine.Warning - do not place active GP tables into Replication! Reupholstery Miami , Decorative Folding Screen Miami, Custom Screens Miami

Share and enjoy

Post A Comment! :: Send to a Friend!