Perhaps each Good Plains technological advisor is aware of how you can make one factor like Income Invoice integration, possessing two textual content data.  One can be doc header and the subsequent 1 is doc strains file.  Hyperlink is centered on Doc selection.  Nonetheless, what you probably have only one file, wherever doc selection is present on each single line?  Or if it’s important to provide with textual content file, which is coming from legacy billing program in the kind of textual content report, readable by human, nevertheless it has paragraphs, webpage numbers, headers and strains (and all these are coming from Unix field, which you might be unable to change)?  How about this circumstance – you might have Excel desk, wherever you might have a lot of objects outlined on the exact same row?  What if data is sitting someplace in Oracle Databases and it’s so substantial, that it may very well be impractical to tug it out into the textual content file – as a substitute it’s important to have to tug it immediately from Oracle?  In these or comparable situations you could think about deploying integration centered on Superior ODBC question.  Let’s attempt to consider examples given above and the way they have to be handled:

one. Methods to make the combination from 1 useful resource file, wherever line has doc selection and the merchandise selection, description, amount and charge?  This living proof is present in IM pattern integrations, assessment GL Entry with 1 useful resource file.  You must group simply 1 column doc selection and this offers you header desk question.  In particular situations you would not have doc selection, however presumably have some form of grouping column (transaction day, in case you make day-to-day invoices, you probably have a number of consumers for every day, than incorporate buyer ID into grouping as effectively)

two. CSV or Excel file, wherever you might have a lot of objects with parts on the exact same row.  Right here you might be leaping into superior ODBC queries.  In superior ODBC question you need to use these sorts of SQL constructions as Union.  You possibly can unionize a lot of Select statements, wherever first 1 receives merchandise selection and amount from the primary and subsequent columns, the subsequent Select receives merchandise and amount from the third and fourth columns and so forth

three. Textual content report coming from the Unix field in the kind of readable by human Invoice, Get hold of Order doc.  Is it really doable to by one factor like that immediately to the Good Plains Integration Supervisor.  Any individual from GP consulting area people might say – No method!  Nonetheless, permits attention-grabbing down and speculate a minor little bit about SQL and doc parsing.  How have you learnt which textual content strains you wish to extract?  All of them are presumably commencing from the exact same place, in addition to they’ve a lot of columns each single of them additionally begins on the mounted place of the doc.  And now, presumably all of the headers, room strains and webpage numbers have empty character on the exact same first place, wherever you merchandise strains have legitimate character.  So, the SQL assertion is presumably not fairly sophisticated, you merely implement standards Precisely the place first character of the sector selection 1 shouldn’t be like room character…  And by the best way, the exact same end result of removing room strains, headers and different non-valid strains – may very well be attained in VBA scripting in Forward of Doc occasion – however that is one factor you may strive by yourself in case you are cozy in VBA scripting

4. Integration  Supervisor because the device to learn by EDI formatted textual content file.  In EDI (Digital Doc Interchange construction) you will have much more drawback, however IM gives you energy to specify dividing character (it may very well be Coma, Tab otherwise you determine the character, required by EDI construction).  However even when your EDI protocol is actually robust to parse, please assessment Select assertion with exact discipline formatting

5. Finding out data immediately from SQL centered ODBC compliant useful resource.  No matter it’s – Oracle, MySQL/PHP, Microsoft Entry, SQL Server, Pervasive SQL/Btrieve, Ctree, you determine it, assuming that there’s ODBC driver to get connection from Microsoft House home windows working program (as Integration Supervisor is obtainable on Microsoft working program system solely) to your database.  One of many approaches we prefer to suggest is that this.  Think about growing Linked Server building in MS SQL Server Administration Studio 2008, 2005 (or Group Supervisor in case you are on SQL 2000).  Linked Server will present connection by way of ODBC driver (typically Approach DSN) to your third social gathering database.  Second stage is that this – you make cross-system SQL Perspective.  And then you definitely make your Superior ODBC question centered on the take a look at, simply made in Microsoft SQL Server.  Such sights may very well be so efficient that you could be strive quite deep historic Income and Acquiring data conversion, by importing substantial Income butch of paperwork (for, say 1 historic month) after which submit them in Dynamics GP consumer workstation (must presumably think about uncheck publishing to and thru Regular Ledger, as you’ll do presumably GL unique balances or consolidated each month transactions for historic GL data migration)

6. VBA Event Managing Scripts.  For those who assume, that you’re not so cozy to code sophisticated SQL Views (with circumstances and state of affairs statements, stuff like that) – you are able to do the exact same in VBA occasion handlers.  In our view, SQL is one factor wherever technological innovation guiding is capitalizing on aggregation character and as a result of this attribute – SQL is a method quite a bit faster, evaluating to cursor pushed logic, which you might have when engaging in VBA scripting (SQL should use aggregation, however each single doc must give up and maintain out proper up till VBA script in occasion handler does its job).  So, in case you technique to deliver historic data out of your legacy accounting program (Peach Tree, QuickBooks, MYOB, SAP Enterprise One, Accpac, and so forth.), wherever the amount of information is substantial and you will have to should repeat examine conversions many time, previous to the remaining conversion – we advise you to do data therapeutic massage in SQL Views immediately, in comparison with VBA occasion handlers

7. Superior ODBC integration state of affairs research.  Certainly one of them can be eCommerce quasi severe time integration, wherever you learn by ecommerce shopping for cart transactions each, say 10 minutes and produce them greater than to Dynamics GP by Integration Supervisor SOP doc integration.  IM may very well be scheduled to fireplace integration each 10 minutes by way of House home windows macro program and scheduled duties.  For those who use new technological innovation – eConnect connectors for the combination – these integrations don’t even name for Dynamics GP consumer workstation to be often on (reverse to traditional IM technological innovation, wherever Good Plains workstation was made use of as OLE Server and because of this it skilled to be functioning, consuming 1 treasured Good Plains concurrent consumer license)

eight. eConnect or how one can cut up by outdated Integration Supervisor performance hurdles.  In Dynamics GP mannequin ten. (and of examine course current mannequin 2010/eleven.) in Integration Supervisor now you can deploy integration targets, centered on eConnect connectors.  Let’s attempt to come by some excurse into eConnect technological innovation by itself.  eConnect was concerned with Microsoft Mission Inexperienced (afterwards reworked into Microsoft Dynamics challenge), wherever the plan was to deemphasize these sorts of traditional Company ERP shells, these sorts of as Good Plains Dexterity, coded in C programming language, and as a substitute rewrite enterprise enterprise logic in SQL Saved Methods.  SQL Saved Plan of action must run quite a bit faster, evaluating to Dexterity cursor, wherever computation first transpires in Dexterity Sanscript code, then it interprets into C++ code after which finally into Microsoft Assembler to switch steerage to your AMD or Intel processor .  New trend eConnect connector phone calls SQL saved processes to carry out the combination, evaluating to outdated technological innovation, wherever first it’s important to provoke Dynamics GP OLE Server, then open Good Plains sort (on OLE quantity), fill in each single discipline, then publish it for validation and if every thing is high-quality, preserve the report by the kind Protect button click on

9. If we actually haven’t got Integration Supervisor module license, is it Okay simply to do direct SQL Insert assertion?  On this predicament you could comprehend your options and hazard zone.  Nice Plains Dynamics and its successor Microsoft Dynamics GP enable so that you can do data repair and insertion immediately into SQL firm database.  It’s a incredible electrical energy, however, by engaging in so chances are you’ll compromise enterprise enterprise logic and break your Company ERP paperwork.  Because of this we really feel that buying Integration Supervisor program licenses shall be higher choice

ten. If we’re on outdated mannequin of Good Plains and we do have Integration Supervisor license, what’s doable and what’s not, evaluating to newest mannequin of Dynamics GP 2010? Effectively, Integration Supervisor was launched with 1 of the primary releases of Good Plains Dynamics, wherever it was centered on OLE Server technological innovation.  The one limitation we might point out is presumably eConnect data connectors, the relief have to be fairly comparable and we don’t see the challenges to deploy Integration Supervisor

eleven. We’re upgrading our Good Plains Dynamics (mannequin 5., 6., 7., 7.5, eight.) to Microsoft Dynamics GP ten (9., 2010/eleven.) and we use a lot of Integrations.  Is there improve approach for the Integration Supervisor?  There’s improve approach, it isn’t prompt for inside improve, you could join together with your Microsoft Dynamics GP Advisor

twelve. I’m programmer and I wish to perceive how you can software VBA handlers for Integration Supervisor.  The place must I begin?  Initially allow us point out that trendy VB.Web programming language is a bit of bit completely different (or most likely higher to say a method much more completely different), evaluating to outdated Seen Important.  VBA (Seen Important for Apps) scripting is sort of subset of outdated Seen Important.  You might want to glimpse at these sorts of applied sciences as ADO (not the ADO.Web, however traditional 1).  VBA scripting is the best way to switch these sorts of Microsoft purposes as Excel, Phrase, MS Entry (wherever VBA scripting is the device to animate MS Entry Varieties and Experiences).  There’s additionally VBA programmer guide, supplied on Dynamics GP DVD/CDs, wherever you may find examples of VBA occasion dealing with codes

13. To ask for extra assist, please join with us one-866-528-0577, help@albaspectrum.com We’ve to should discover your playing cards so as to counsel you the best options, which isn’t contingent to our tastes.  We offer you U.s.a. of america/Canada nationwide by way of distant assist (web courses and phone/skype conferences).  Native assist is obtainable in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston location of the purpose out of Texas

You may also like

No Comment

You can post first response comment.

Leave A Comment

Please enter your name. Please enter an valid email address. Please enter a message.
Rankie WordPress Plugin