Microsoft.com Microsoft Knowledge Base
Microsoft.com Microsoft Knowledge Base
Microsoft Dynamics GP Integration Methods: IM, eConnect, Dexterity
Formerly this mid-market Corporate ERP application was known as Great Plains Dynamics and eEnterprise. In this small publication we would like to review advanced integration options, available in Dynamics GP Integration Manager, eConnect, as well as custom integration programming in Great Plains Dexterity. Plus, we will try to address options for older versions of Great Plains Dynamics on Pervasive SQL 2000/Btrieve and Ctree. Please, note that Great Plains Accounting for DOS, Windows and Mac is technically predecessor of Great Plains Dynamics for Windows and Macintosh, however GPA business logic and interface are different from Dynamics core functionality: GL, PM, RM, SOP, POP, Inventory Management. GPA is out of scope for this article (where we would like to make several observations)
1. Integration Manager. We understand that most of Great Plains Technical Consultants know how to setup simple integration, where the source are text tab or comma delimited files, including building document header by grouping text lines (by document date for example: General Ledger Transaction, Sales Order Processing Invoice, etc.). However, we saw pretty tough situations, where Dynamics GP integration consultants had hard time in complex data conversions, where transactions and master records are in SQL tables or ODBC compliant databases: Oracle, MS Access, Pervasive SQL/Btrieve, Ctree, MySQL, or when they are exported into very complex text files (where you have to weed out formatting lines, as reports are exported in human readable format, which is not something that text integration accepts without data massage). Good advice in our opinion in such scenarios is to import these text files into MS Excel, weed out formatting lines and then import the data into staging MS SQL Server tables. Then you create SQL View to pull data from staging tables and use it as a base for Advanced ODBC Data Source. We had cases, where we were able to import up to the whole year of mid-size company GL transactions via that method. We would like also to share IM ongoing and close to real time integration methodic via Integration Manager. If you have in-house programmed ecommerce website application, which requires close to real time or batch mode integration to Sales Order Processing (customer orders, invoices and returns) and new customers creation (where transactions are coming from Linux/PHP/MySQL based ecommerce application) - consider either exporting transactions in text file or even establishing ODBC connection from Dynamics GP hosting MS SQL Server to MySQL via Linked Server mechanism, and schedule IM Integration to run every 20 min or few hours via Windows Macro third party add-ons. We know that for some of you these complex technical passages might be too deep, but our mission here is to let you (as struggling ecommerce programmer) know what is possible with Dynamics GP ecommerce integration. And finally, the last observation, before we move on to eConnect technology, please know that IM for GP version 10.0 is available in two connection blends - traditional OLE Server and eConnect connectors. eConnect connectors are faster by their technology architecture and technically you may be achieving the same results as if you are programming eConnect directly from your ecommerce web application, where the advantage of Integration Manager is apparent - it is user friendly in integration design and doesn't require programming (except simple VBA scripts, or data translation tables, which could be composed in MS Excel)
2. eConnect Integration Programming. eConnect was introduced for Dynamics GP version 7.5 and 8.0 as the Software Development Kit, initially dedicated to eCommerce software developers. eConnect was under certain evolution for Dynamics GP versions 9.0 and 10.0, where it was adopted as integration technical platform strategy (and it was announced by Microsoft Business Solutions that eConnect should replace earlier integration platforms: Integration Manager, Dexterity - as middle tier). And now as we are writing these lines (October 2009), eConnect is triumphing among Dynamics GP integration low level technologies and connectors. eConnect technology is in fact simple - it is the collection of SQL Server encrypted stored procedures, replicating Great Plains Dexterity Dynamics GP business logic (often in Object Oriented Programming style, and this is good improvement to Dex, which is not technically Object Oriented Programming compliant with some exceptions). In our opinion eConnect came to its maturity as reliable Dynamics GP ecommerce and generic integration Software Development Kit with Great Plains Dynamics GP version 10.0 and probably 9.0. If you got certifications and experience as Microsoft .Net VB or C# programmer, you should find very useful code samples and prototype Microsoft Visual Studio eConnect projects: Dynamics GP Sales Order import, Customer import and update (including addresses) to give you start up ideas
3. Dexterity integrations. Dex is capable to do the ultimate and the most complex programming surgery in Dynamics GP system environment. If Integration Manager and even eConnect don't do the job or incapable to do the job (and this is possible as these tools have natural limitations). However, please recognize the challenges of Dexterity. In Dynamics GP realm there are no limits to Microsoft Dexterity customizations, and if you contact with Great Plains Dexterity programmers (who have access to Dexterity Source Code and have experience in Dex source code programming), please go ahead to evaluate these channels. The only advise we would like to feature here is fact that Dexterity requires too long learning curve for newcomers, and it is not recommended for small or mid-size companies IT department to do Dexterity custom programming inhouse
4. Direct SQL Data Feeding. If you are experienced Microsoft SQL DBA, please review Dynamics GP Tables Structure Tools->Resource Description->Tables (or install Dynamics GP SDK from DC#2, where tables structure is formally documented). We would like to make comments and recommendations, before you try direct SQL data feed via SQL Stored Procedures. Please, consider the fact that eConnect is already doing this job via its methods and Stored Procedures. Also take into consideration the fact that Dynamics GP business logic and data flow is quite complex and it is unlikely that you can do imitate this logic in couple of day, couple of week or even in couple of months. If you have unlimited IT budget, then please disregard and go all the way through until you consider yourself experienced eConnect programmer with comfort to send records directly to Dynamics GP tables: GL10000, GL10001, SOP10100, SOP10200, SOP30200, SOP30300,etc.
5. Great Plains Integration options for Old GP versions: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and Great Plains Dynamics on Pervasive SQL Server 2000/Btrieve and Ctree. If you are on archaic version, it is unlikely that you can get support directly from Microsoft Business Solutions Dynamics GP subdivision (as you are likely not current in MBS annual enhancement program)
6. Great Plains Accounting for DOS, Windows or Mac integration options. GPA has its own integration module, and if this is your Corporate ERP, please contact us separately, we have access to GPA knowledge base, inherited from Great Plains Software - if your case is known and documented (plus if you can recognize your problem in GPA after 10+ years of GPA and Dynamics GP Consulting), we are uniquely positioned to support Great Plains Accounting for DOS, Windows and Mac: 9.5, 9.2, 9.1 or earlier versions USA and Canada nationwide and internationally most likely Central, South America, Mexico, Caribbean, Pacific, Malaysia, Indonesia, Singapore, Saudi Arabia, Kuwait, Pakistan, Casablanca, Agadir, India, Bangladesh)
7. Unicode characters integration notes. Great Plains Dexterity doesn't support hieroglyphs: Chinese, Japanese, Korean, Mongolian, Thai. All we can do for you is enable hieroglyphs in Crystal Reports or Microsoft SQL Server Reporting Services (often abbreviated as SSRS)
8. Dynamics GP Great Plains in Russian Federation, Kazakhstan, Uzbekistan, Azerbaijan, Poland, Czech republic, Latvia, Estonia, Lithuania, Romania, Slovakia, Georgia, Armenia. Great Plains Software tried to market and localize Great Plains (version 4.0 and 5.0) in Common Wealth of Independent States (most of the former Soviet Union territory, except East Baltic States) . When Great Plains Software was in its order acquired by Microsoft Business Solutions, MS recommended Navision as the Corporate ERP of choice back in earlier 2000th, and later on MBS localized Axapta Microsoft Dynamics AX for most of Western, Central and Eastern European Corporate ERP markets. To avoid further complexities, we recommend you to chose SAP Business One in former CIS, Baltic States and in Arabic World as good local branch Corporate ERP, which has simple integration tools and options to your Dynamics GP ERP in the headquarters
9. How to get help? Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us [email protected] We are very technical and real Dynamics GP Dexterity, SAP Business One SDK and Microsoft CRM programming gurus. We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs. Plus we speak English, Chinese, Spanish, Portuguese, Arabic, Russian, and not only as native speaking sales folks, but as real technical consultants. If you prefer skype: albaspectrum
About the Author
Andrew Karasev, Alba Spectrum , [email protected] 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One 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, Russia, Central America: Mexico, Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala , South America: Chile, Argentina, Paraguay, Peru, Uruguay, Venezuela, Colombia, Ecuador, Bolivia
SOS!! why my computer cant configure the wireless connection? There is nothing in the list!!SOS!?
I cannot configure my new wireless network
I have just purchased a new router and it is a netgear WGR614 v6
when i go to the wireless network connection in the control panel there is nothing but this in the list:
Windows cannot configure this wireless connection
If you have enabled another program to manage this wireless connection, use that software
If you want Windows to configure this wireless connection, start the Wireless Zero Configuration (WZC) service. For information about starting the WZC service, see article 871122 in the Microsoft Knowledge Base on the microsoft .com Web Site.
However even when i have turn on WZC it still is not working!!!!
The router and internet connection are fine as i can see the wireless light on and the router can transfer internet stuff to my other computer through cable
So anyway, plz help me and that would be very appreciateful.
*(___)^
What your Windows is trying to tell you is that you are using 2 different connections to access the Internet.
(1) Windows already has the Wireless Network Connection default panel to manage your Internet connection.
(2) Your Netgear router is something added on and it has its own panel.
You have to use either one or the other.
Go to Start > Connect to > Show all connections. Right-click on the one which says Wireless Network Connection, then go to Properties > Wireless Networks tab, uncheck the 'Use Windows to configure my wireless network settings'.
The Netgear connection icon should be in your task tray. You can click on it and see if it opens up for you to navigate it. There really isn't anything to configure in there.
Once you uncheck the Windows configuration box, you should automatically be able to connect to the Internet with your Netgear.
Microsoft.com Microsoft Knowledge Base
Microsoft Knowledge Base on Facebook
Get MCP MCSA MCSE Certified Easily and Quickly By CertXpert.com
We offer a one-stop solution for you also take exams and get Microsoft certifications in the shortest time. The solutions are developed by our professional technicians with extensive testing experience. We help you to the tests without having to spend much time and money to prepare for the strange trials.
So, we have fully trained advisors ready to help you make the best decision for you! We look forward to helping with your request and advise you about your career goals!
We are all the payments, should report to you, for some reason not an audit. The refund is an unconditional full refund of all monies paid, plus a free test voucher. This is a simple and guarantee to beat.
Introduction to Microsoft Certifications
Certifications are a necessity in these days, the good from the bad to say, even at the start. However, the test does not end, but only means that you have a chance at the job and not the job.
Microsoft has made great efforts to ensure academic degree is an engineer to test all aspects of a company, if he claims to be a Microsoft Certified Systems Engineer.
Microsoft offers a number of certification levels depending on specific areas of expertise and the type of work. Some of the certificates in connection with the Field of Networking:
Microsoft Certified Professional (MCP)
Microsoft Certified Systems Administrator (MCSA)
Microsoft Certified System Engineer (MCSE)
Each certification level has certain exams associated with it. You can decide the appropriate level of certification exam on their experiences, based skills and interests.
Why is Microsoft Certification?
Imagine a number of potential employees who know the technology well, and you have the certification together with the necessary experience, it's your guess as good as mine, who ends up with the job.
Yes, that's Microsoft certification as a basis for streamlining the recruiting process. A passport with which you win an entry to the organization, including at least the interview, if it were not the work itself!
Who are these certifications mean?
If your line is the job in this list, then the test / certification is for you: system administrator
Network Engineers
System Analyst
Training - Network
MIS
Enterprise Administrator
Web Administrators
What is MCSE 2003 certification to pursue?
Microsoft Certified Systems Engineer (MCSE) candidates on the Microsoft Win-dows Server 2003 track are required to pass the following 6 core exams and 1 elective exam:
Core Exams: Networking (4 Exams Required)
70-290: Managing and Maintaining a Microsoft Windows Server 2003 environment.
70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure.
70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infra-structure.
70-294: Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory infrastructure.
Core Exam: Client Operating System (1 Exam Required)
70-270: Installing, Configuring and Administering Microsoft Windows ® XP Professional.
70-210: Installing, Configuring and Administering Microsoft Windows 2000 Professional.
Core Exam: Design (1 Exam Required)
70-297: Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure (Note: Can be used, but not both as a choice or design requirement).
70-298: Designing Security for a Microsoft Windows Server 2003 Network (Note: Can be used as an option) or design requirements are, but not both.
Passing Score
Beginning with the version of Microsoft Windows Server 2003 in connection with audits, Microsoft provides numerical values for tests. The new standard requires a minimum score of 700 on all the tests. The maximum score on the tests vary de-applications will be measured on the complexity of the skills. You can from this de-tails on the Microsoft website to update themselves for the changes.
About the tests themselves
There are seven tests pass in all and can dull with the various question patterns, scenarios, etc. If you are not cast in the hours of preparation and is available on every page of every book you would not be a passing score in all the seven tests at once .
Something on the assessment model can help you. Most of the questions in the exam have several options. The questions require close the "best" answer from several responses. Some questions may present an implementation scenario, requirements, and a proposed solution and then ask whether the solution to all of the requirements or combinations of primary and secondary requirements.
Microsoft has introduced some testing innovations for the certification exams such as Hot Zone, Active Screen, Drag and Drop, Case Study-based test demo, testing with simulations.
Note: Exams 70-297 and 70-298, any time, either as a core design exam or verification of credentials count.
Resources
The best way to succeed is a hands-on, hands-on and hands-on. But then again, you would not lose if you have a number Sybex preparing a book or MSDN site itself for the knowledge base, case study, and so on trying. See how many white papers as you can on all Microsoft technologies, it is the best way to understand a technology from the basics. Finally, do not appear for the test before your hands are a good example simulator, especially if it is your money and time is precious to you.
Be warned! Study or do not buffalo. These tests are now wearing simulation-based questions. If you are up to now questioned on the concept of Disk Administrator utility, you can now encouraged to use it effectively in the exam. For this reason, your only choice is 2003 not only known by all administrative and maintenance costs and toll in Windows, but also really good!
Professionals take advantage of Microsoft certifications
The Microsoft certifications provide the following target groups: network administrators
Network Engineers
System Analyst
Security Analyst
Mail server administrators
Operating System Administrators
Web server administrators
Manager of IT systems
Pre-Requisite Experience (recommended) for Microsoft Certifications
To achieve MCSE certificates, you should have at least 1 years experience implementing and administering a network operating system in environments with 200 to 26,000 supported users in about 5 to 150 physical locations.
Implementing network services and applications such as file and print services, database services, messaging services, proxy server or firewall services, dial-in server services and web hosting.
Implementing and administering a desktop operating system.
Designing a network infrastructure
For more information, please visit our website: www.certxpert.com
E-mail: [email protected]
About the Author
mcse, mcse training, mcse 2003, mcse exam, mcsa mcse, mcse ccna, mcse certification, mcse jobs, microsoft mcse, mcse exams, mcse guide, mcse course, mcse server 2003, mcse study, windows 2003 mcse by http://www.certxpert.com
|
|
Fritz Chess 13 $19.69 TAKE YOUR GAME TO A HIGHER LEVEL with FRITZ CHESS 13 and experience its array of exciting new features! Take your game into the cloud and enter a virtual world of chess where players of all abilities can play and train using revolutionary new functions! Whether you’re a chess beginner, club player or professional Grandmaster, FRITZ CHESS 13 has it all! The top-ranked Fritz Chess engine adjusts i... |
|
|
Information Rules: A Strategic Guide to the Network Economy $10.00 Chapter 1 of Information Rules begins with a description of the change brought on by technology at the close of the century--but the century described is not this one, it's the late 1800s. One hundred years ago, it was an emerging telephone and electrical network that was transforming business. Today it's the Internet. The point? While the circumstances of a particular era may be unique, the... |
|
|
Windows Server Undocumented Solutions: Beyond the Knowledge Base (One-Off) $0.01 This book is perfect for any network administrator looking to push their servers to improved performance or to perform uncustomary tasks. Provides undocumented techniques for installation, networking, multimedia tools, disk checking, migration (single and multiCPUs), backup, IIS tuning, Active Directory, memory, upgrades, and much more.... |
|
|
Microsoft Data Mining: Integrated Business Intelligence for e-Commerce and Knowledge Management $43.76 Microsoft Data Mining approaches data mining from the particular perspective of IT professionals using Microsoft data management technologies. The author explains the new data mining capabilities in Microsoft's SQL Server 2000 database, Commerce Server, and other products, details the Microsoft OLE DB for Data Mining standard, and gives readers best practices for using all of them. The book bridg... |
Microsoft.com Microsoft Knowledge Base
