Andrew Karasev, Alba Spectrum, help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP: Great Plains and SAP Business One community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We also specialize in Oracle custom programming. We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America
If you work for large organization, which has independent subsidiaries and branches, running various ERP and accounting systems: Microsoft Dynamics GP, SAP Business One for example, and in the headquarters you have custom Oracle database application deployed (CRM, Sales Order Processing, EDI, eCommerce web site, Warehouse Management, Quality Control, etc.), then you might be interested in cross platform integration between Dynamics GP and Oracle application. Again, if you have Great Plains Dynamics implemented, it is rather legacy MRP and ERP systems situation, where either Oracle or Great Plains is the legacy, depending on your corporate IT strategy. In this small publication we would like to review Oracle integration options to Great Plains Dynamics GP:
1. Dynamics GP SDK. We recommend you to review GP eConnect, as the set of libraries for your integration gateway to program bidirectional integration to and from Dynamics GP. You can deploy eConnect in Microsoft Visual Studio .Net C# or VB project, from where you could also call ODBC gateway to Oracle database world. You can either schedule eConnect gateway in batch integration scenario, or call it in real time with parameters of current transaction
2. Dynamics GP Integration Manager. This scenario is more user friendly , but at the same time less flexible (if you are programmer and seeking for sophisticated custom integration logic). You can also schedule Dynamics GP IM in batch integration mode (look for generic Windows application macro solutions, where you can call EXE application with parameters, or simply purchase IM scheduler from Microsoft Business Solutions Dynamics GP reseller)
3. Connection to Oracle. Here you may think about several technologies. If you are working for Oracle shop IT department, you should be already familiar with ODBC options at the Oracle end. If you are in Microsoft SQL Server type of circle, consider creating SQL Linked Server (in MS SQL Server 2005 or 2000) to open the door to Oracle databases
4. Text files as Data interchange, CSV and Tab Delimited. This approach is feasible if your Oracle resides in Unix or upscale Linux (also consider XML data interchange, which is relative to the idea of platform independent text file). Text files, exported from Oracle database should be easy to process either in Dynamics GP Integration Manager or eConnect Add-on. If you have the objective to move your GL transactions from Dynamics GP General Ledger to Oracle Financials, you can easily export new Dynamics GP GL records via SQL view from GL20000 table
- Related Videos
- Related Articles
- Ask / Related Q&A
- Oracle To Dynamics Gp Great Plains Integration Notes
- Great Plains Partner Newsflash: Dynamics GP Large Scale Ongoing Integration
- Great Plains Partner Newsflash: Dynamics Gp Implementation Recovery
- Dynamics Gp Support in Chicago and Northern Illinois
- ERP for Small Business: Sap Business One Vs. Great Plains Dynamics Gp
- Dynamics Gp ERP Installation, Consulting, Support Highlights
- Dynamics Gp Consultant Newsflash: Importing Into Great Plains
- Great Plains Data Import: Dynamics Gp Integration
How to convert youtube video to MP4 for iPod
By: Jessy Brown | 04/01/2010Is it possible to get YouTube videos on iPod? Well, it seems interesting, if the two are kind of connection, yet YouTube videos are all Flash videos played by a Flash Player, and iPod supports the videos in MP4!
Remember Isaac Newton, watch FLV videos on your iPod/iTouch
By: alex nikle | 04/01/2010Today is Isaac Newton's 367th birthday. Let's watch videos of Isaac Newton's legendary life on iPod/iTouch easy and fast.
Examsoon Cisco 640-802 certification
By: aminalee | 04/01/2010Examsoon known to be the best for providing the exam questions for the Cisco 640-802 certification and training . Our 640-802 expert’s team has designed and prepared the training kit for Cisco 640-802 certification.
Dell Support Creating Landmark In customer Satisfaction
By: Jas Devid | 04/01/2010Dell is a customer centric organization, offering quality services for the diverse segment of users. In order to keep its customer satisfaction graph on the peek, Dell has collaborated with reputed outsourcing organizations. These support firms are working on 24/7 basis to meet the expectation of the users.
How to watch DVD movies and videos on PS3?
By: Herb368 | 04/01/2010With a larger 250GB of hard disk drive storage for more games, movies, music, videos and photos, Sony’s new PlayStation 3 is an ideal solution for ditital entertainment. This article will share you an easy to play DVD movies and videos on PS3.
How do Labels organize you with countless things?
By: Janett Parker | 04/01/2010Labels are those tags that contain the name or any specific information on the object. They are the stickers either used for identification purpose or for promotional reason. Proper use of labels enables you to organize yourself at home, school, college or office. A person can design stickers attractively for identification purposes.
Advantages of Using a Sales Dashboard For Analysis of Retail Business
By: Sudhi Ranjan Das | 04/01/2010This year holiday season revealed how insufficient use of technology can lead to a sales and production cost mismatch. So it is very important to determine sales figures and volumes to calculate production, marketing and all kinds of overhead in comparison to sales & revenue.
Adding Custom Fonts To Your Wordpress Website Is Easy
By: Collaborate | 04/01/2010How to add custom fonts to your wordpress website easily with the wp-cufon plugin. Adding custom fonts to your website has for a time been very difficult. You get you site looking pretty and then upload it to the server and low and behold it looks great on your PC but looks absolutely terrible on everyone elses. The reason for this is that every one only has a few core fonts in common and if you add non-core fonts to your site those without them cant see them. Now it has changed it’s much eas
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.
Microsoft Dynamics GP 7.5, 9.0 version update notes
By: Andrew Karasev | 27/12/2009 | SoftwareAs recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level
Ecommerce to Dynamics GP Real Time Integration: Order Connector
By: Andrew Karasev | 25/12/2009 | SoftwareIf your back office Corporate ERP application is Microsoft Dynamics GP, former versions were also known as Microsoft Great Plains and Great Plains Dynamics, and you have in-house developed ecommerce web application with items catalogs with advanced price lists (especially in B2B ecommerce scenarios), shopping cart, credit card processing, we would like to present you this small publication in the form of FAQ and orientation session.
Microsoft Dynamics GP Deployment and User Training Notes
By: Andrew Karasev | 24/12/2009 | SoftwareIf your organization plans to deploy Microsoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise and its predecessor Great Plains Accounting for DOS, Windows and Mac, we would like to offer you this small introduction level publication.
Great Plains Support: Covering All Versions - Dynamics GP, Pervasive SQL, GPA for DOS
By: Andrew Karasev | 22/12/2009 | SoftwareAll versions of Microsoft Dynamics GP and its predecessor Great Plains Dynamics and eEnterprise, plus earlier versions of GP on Pervasive SQL 2000 or Ctree (including Mac based Faircom version), as well as Great Plains Accounting for DOS, Windows or Macintosh are supportable. In this small publication we will review all versions of GPA, Great Plains and Microsoft Dynamics GP (from earlier 1990th up to May 2010) and their support methods.