microsoft sql management studio mysql
As a smaller business organizations and medium are deploying open source operating system platform and tools, such as Linux with various blends and PHP / MySQL, we would like to share our experience implementing Microsoft Great Plains in these combined OS environments. If you are using Oracle and Unix, you can also consider the methodology, however, which deserves separate article only for a brief hearing, especially on Java, EJB nuances.
1. MS Great Plains platform view. GP workstation is written in C Shell, named Great Plains Dexterity. It was designed in earlier 1990th, when PP and independence of operating system platform was the paradigm. However, when Microsoft bought Great Plains Software, seven years ago, Microsoft Dexterity was a kind of relief and – GP itself was open. Net and platform Microsoft Visual Studio C # and VB developers, especially through eConnect. In addition, GP is available on Microsoft SQL Server DB platform only. Saying this, Microsoft Great Plains version 10.0 and 9.0 should be regarded as a commitment to Microsoft technologies: SQL Server,. Net, Windows, MS Office: SharePoint, Excel, etc
2. Cross Platform SQL queries. If it does so from Microsoft SQL Server 2005 or 2000 side, construction is typically used linked server, first should try the ODBC connection to Linux World. If you are on Oracle, then a similar construction allows you to connect MS SQL Server
3. Web Services. eConnect allows you to open objects GP for non-Microsoft developer through XML web services â € "you can use the direct eConnect interface or wrapped in custom Web service interface
4. excursus eConnect. The core of eConnect is a set of MS SQL Server encrypted stored procedures, which allows you to manipulate GP master records and work transactions: SOP Entry, POP Receivings, customers, suppliers, to name a few. eConnect has constraints of the architecture GP, a typical frequently asked questions is why you can not post batches in GP eConnect? Well, this is the restriction, but you can break the use of Albaspectrum ad server. eConnect was initially dedicated to software developers e-commerce, so as GP ERP platform for back office accounting e-commerce front end
5. Integration technology. EConnect Here comes again to the scenes. GP Integration Manager, which is rather traditional Great tool integration of the Plains, was recently redesigned in eConnect and partly so the performance of MI was substantially increased. IM can read the information and text files comma delimited, as well as consultations with ODBC compliant databases. When is the integration of programming, be sure to select destination eConnect connector preferred against the deployment of regular destination connector (old-fashioned connectors use physician workstation as OLE server to validate the Great Plains business logic directly on screen in GP, which obviously slows down performance)
Virtual Warehouse Management System Part 2 of 3