Advanced Techniques - in MS SQL Enterprise Manager you can create Linked Server to all ODBC/OLEDB compliant databases. Microsoft SQL Server or MSDE - this means that you can deploy native SQL driver for connection or use ODBC for flexibility. Ctree, PervasiveSQL/Btrieve, MS Access, ORACLE, DB2, Unidata, Navision (C/ODBC) and using OPENROWSET construction you can create geterogeneus view and stored proc - then you can have the data from multiple systems in your Crystal Report. Please pay attention to the brackets around Transaction - transaction is reserved word in MS Transact SQL - the Microsoft blend of SQL92. SQL Views and Stored Procedures - yes - feel free to create them directly in RMS Headquarters database and deploy in your Crystal Report.
Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases.
User Training - we are just listing this item - it is up to you to decide on the way to train your users
Using Two Systems in Parallel - this is recommended. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Washington, Minnesota, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www. Net, Crystal Reports and Microsoft CRM SDK developer. Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages
Do I need consultant? We strongly recommend you to use consultant in the following cases.
Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc. Direct SQL touch - in #4 above I described you the scenario with MS Exchange handlers - this would be ideal world if MS CRM SDK does the job. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it. If you have SQL database, sitting on the same or linked SQL Server - you can create ASPX. MS CRM Customization tool - this is rather end-user tool and we don't describe it here - read the manual.
John Kleb is Certified Navision Specialist in Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www.
You have C/SIDE customization or any customization for your Navision
You have a lot of custom Jet Reports
Your Navision has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems
You don't have support - in this case you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade. We strongly recommend you to use consultant in the following cases. Do I need consultant? It is probably good idea to have consultant to do the upgrade. If you have Microsoft Business Solutions Navision and support it for your company then you need to know some technical details about Navision version upgrade and what is going on behind the scenes, which options do you have in case of C/SIDE customization or Jet Reports.
A smart webmaster performs a regular monthly analysis of the valuable information contained in the server log. Platform and User Agent Good server log analysis software will tell you which operating systems and which browser brands and versions people are using to access your website. Stick to content related to the subject of your website, but delineate a wide enough scope of the topic so that when your server statistics point out an opportunity to increase traffic, you have rules to guide you. Some webmasters brag about the number of hits their website receives, but hits themselves are not important. Good server log analysis software will tell you which countries your website visitors are located in.
DBxtra allows you to connect to Microsoft Access, Microsoft SQL Server, MySQL, Oracle, DB2 and any other database through ODBC. This allows for you to quickly publish valuable information in real time for internal and external users, without ever having to give them true access to your database systems. At this point the Active Server Page is available for everyone to view. Ultimately created and ported over to the web server is an Active Server Page . So after generating the Active Server Page users are placed into DBxtra's GUI Designer where different styles may be imposed on top of the generated Active Server Page.
You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be changed in the new version then you need to analyze your SQL code. Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports.
No run time fees, No server-CPU fees, and no development fees charged by AlachiSoft. No run time fees, No server-CPU fees, and no development fees charged by AlachiSoft. New Oracle optimization includes the ability to generate. NET components using Oracle Native Data Provider for. Follow five easy steps to Rapid Development with TierDeveloper 3.
Microsoft Great Plains/Navision/Axapta/Solomon/Microsoft CRM/Small Business Financials ERP, based on MS SQL Server DB platform and all this nice suite is working under Microsoft Windows 2003 Server. Nowadays we see the trend to use reasonably inexpensive and functionally sufficient applications, based in decent SQL platform. Good luck and you can always seek our help in customization, implementation, integration and support. Microsoft CRM would integrate with Oracle
smoothly. Microsoft CRM or SalesLogix would do the job.
You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data. SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be changed in the new version then you need to analyze your SQL code. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. Server side - upgrade converts tables from old format to the new one.
When Microsoft SQL Server won the database market - Great Plains Software began migration campaign from Ctree/Faircom, Btrieve/Pervasive SQL to MS SQL Server 7. Oracle, Ingress, Sybase, DB2, Ctree/Faircom, Btrieve (Pervasive SQL 2000 later on. Use Crystal Reports design and our recommendation is to base Crystal Report on SQL View or Stored Procedure. Right now (2004-2005) we are in the transformation phase when old tools, such as Dexterity are still playing important role, but if you are thinking about customization, you probably better consider SQL Server scripts/views/stored procs, if you have customization budget - make a research on eConnect. Try to make as much web publishing in Visual Studio.
In the case of both Great Plains and Microsoft CRM you use MS SQL Server linked server technology. In some cases you would like to use Lotus Notes Domino as email server - this is also possible. You should create heterogeneous SQL view and base you Crystal Report on this view. Net to program MS CRM lookups, in some cases you can use WebMatrix, but we do not recommend tools, which do not have rich debugging features. Microsoft CRM security suggests you to use MS CRM SDK or built-in Crystal Reports Enterprise to comply.
You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports. Server side - upgrade converts tables from old format to the new one.
If you have consulting programmer - she or he can connect to your MSDE installation, using MS SQL Server Enterprise Manager, installed on consultant's laptop. The reason is - it works with Inventoried items and typical eCommerce is ordering specific items off the internet. These restrictions lead you, eCommerce developer to direct SQL programming. Usually eCommerce solution works around Sales Order Processing tables. Receivables Management Module - When Sales Order Processing Invoices are posted - they create record in Accounts Receivables or Receivables Management Module.
If you have UNIX-based ERP/Accounting, you can deploy MS SQL linked server to bridge MS CRM and ERP. Microsoft CRM has relatively simple business logic and sits in Microsoft SQL Server, which enables customization and integration with third party systems and databases. However if you have IBM Lotus Domino email server - you can deploy MS CRM-Lotus connector, developed and supported by Alba Spectrum Technologies. Multiple clients, especially large companies, do it themselves. Microsoft Business Solutions promotes MS CRM worldwide and has local versions of the product.
|
|