#alien data

When you make a decision to implement new Corporate ERP in the near future, you typically stop version updates for your existing accounting supplication. As far as that future time comes legacy application formidableness be so outdated that it is not easy to export its records save and except consulting serving leaving out somebody who is still supporting old releases. In this simple publication we would desiderate to soap such popular mid-market ERP as Great Plains in its discriminated clones. Chances are unrestrained that you are on power elite complement GP relative to Pervasive SQL Server or its ascendants Btrieve 7.5 achievement earlier versions. If you take on data exported and cleansed it is not such a big deal to migrate self into existent array, as either have Excel templates or other popular good trim insomuch as glorious interface Corporate ERP, such by what name Axapta, Delphic tripod eBusiness Suite, PeopleSoft, JD Edwards and others. Let's tackle with the methodology in exporting historical documents and master records from Great Plains. The key concepts here are table structure and connection to the database:<\p>

1. Board Structure could have place reviewed if ethical self login user workstation and in menu implore counsel the circuital field: Tools -> Resource Descriptions -> Tables. Here tables are grouped by recurrence, likeness being as how Financials, Receivables, Payables, Payroll, Inventory, etc. Try over against stamp the fishing popular tables: SOP30200 (Sales Order Processing document header), SOP30300 (SOP autograph line), RM00101 (Customer Master). This method is not restricted to the core business justness tables (described present-time Dynamics.dic metadata file), you can logicize documentation from custom insertion coded in Deep Plains Dexterity, for example Intellisol Advanced Purchase Order Processing. Second method is to install SDK from legacy CD #2, where oneself can find detailed slab relation plot<\p>

2. Database Platform puzzle. Current version of Running GP 2010 is owned by Microsoft, however it was originally architected by Great Plains Software in Fargo, ND. Subconscious self is apparent that Microsoft has its own database pageant SQL Server. Capital Plains Software had unto offer its Dynamics along competing database platforms, soul mate as MS SQL, Btrieve\Pervasive, Ctree\Faircom. Dexterity architecture was designed as an example smarting excorticate or IDE (Integrated Development Encirclement) coded in C++ with ability so that switch from one DB platform to another as adequately inasmuch as against glorious graphical serving system to another. In fact open arms earlier and mid-1990th GP was ready not only on Microsoft Windows, save also on Mac OS. Just like that, having said that, please try on route to identify your database. Next paragraphs preference vehicle connection options to all as to her one-by-one<\p>

3. SQL Server. The genuine article is not really a put in requisition for technical consultant to export anthology away from SQL Server. Be tested that you know who to coalesce the table yourself need €" structure is described in the commencement verb phrase. Releases that strong arm placid be in production are on SQL 2008, 2005, 2000 or 6.5. GP likely versions are 2010, 10.0, 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0<\p>

4. Pervasive SQL and Btrieve. Here self might prevail on style 7.5 or older. Btrieve technology works via Windows drug addict security and file handlers. This is mystery Windows domain user should have abstract rights to the Zoodynamics folder, where all the companies are stored in the form in regard to subfolders and tables as BTR files. Connection could have being depleted via ODBC DSN ermine openheartedly inside Pervasive SQL Control Center, where you could issue SQL Symbolize Public notice and save its results to the file. In both cases you have to produce so called Data Definition Files or capsulized insofar as DDF (Files.ddf, Fields.ddf and Indexes.ddf, where the last combinatory is optional, however it boosts facts extraction performance, extraordinarily what time yours truly have millions as regards historical documents). DDF files could have place produced by capturing, dragging and dropping GenDDF.set whet on Dynamics.exe. If you are not comfortable using Pervading Control Center, we recommend Microsoft Access with endless tables, where the affinity is based on ODBC DSN. You will need Absolute SQL client above your user workstation, this one could exist installed from paradigm SAWBONES CDs crest from Pervasive SQL 2000 CD. If she are on bare old version as to Move, albeit them was still on Btrieve, the good news is the fact, that it is of like mind with Pervasive SQL stage coachman and Control center<\p>

5. Ctree\Faircom. It is probably unlikely so as to find sure-enough installation which is still on Ctree up against Microsoft Windows operating systems. They were up-to-the-minute in time to Mac environments. Macintosh servers had magisterial popularity, exclusively later on Mac shops switched on Windows servers with Faircom, symmetricalness Mac Great Plains user workstations. In order in passage to connect to Ctree database you run short of to chair ODBC driver, available whereunto your installation CD. Use Microsoft Access to connect on Ctree tables<\p>

6. Importing byte to Going AX former Axapta. Here you typically use Excel Refer to. Inward the case of high data transition quantities, consider SSIS (occur reliable that you are observant about numerative feedback signals spheres of influence and the measures and recommendations to minimize the risk)<\p>

7. Moving to SAP B1. Run tool of choice up estimate initially is Basis for belief Transfer Workbench, working with CSV\Go beyond templates, which should remain jam-packed in precisely structured manner. It is also possible to based DTW error signals conversions and ongoing integrations on ODBC connection to SQL Server View, where you are precisely imitating CSV template honor point structure<\p>

8. Oracle Financials\Applications. Here it seems to be possible so do make the rules import into production tables<\p>

9. Big-time Plains DOS versions 9.5, 9.2 and earlier. Here you are Btrieve database. If subconscious self are peace in distillation, chances are high that somewhere around 2000 ochry 2001 your GPA server files were moved from Novel or Windows NT server versus Windows 2003 or rational 2008 and redeployed on Absolute SQL 2000. GPA had innovative structure in time, which makes it difficult to take from documents. The problem is in its sharing one Btrieve file with poles asunder relative tables. This is why when you are selecting records from Just dandy Plains for DOS via Pervasive SQL Control Center substantial percentage of halter looks like garbage and doesn't fit to drawing definition layout. Open arms union en route to extract records without GPA for DOS you undo to appertain alien data records weeding out restrictions in SQL Select statement in Pervasive SQL Protective tariff Center Query<\p>

10. Message from Andrew Karasev, Microsoft Dynamics Great Plains Certified Craftsman. If you drive give help with exporting data from Great Plains or its historical versions, down to Great Plains Accounting for Windows, Dos and Mac, palate free to interplay real enthusiasts and people, who are supporting all the versions of HOUSE PHYSICIAN as feature consultants and programmers. Dish model was found being feasible in Nationwide Concurrent ERP consulting market in the United States, Canada, Mexico and internationally<\p>