|
by Andrew Karasev
Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision
Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). Currently Navision is supported on
two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server. In this small article we would like to give you the clue
on Navision integration with Microsoft Retail Management System - Microsoft RMS.
Legendary Strength of C/SIDE database - the history of Navision design reveals the primary goals to have its own proprietary database
with the built-in features of database transaction integrity. As far as database is proprietary - Navision can manipulate its and tune
it to serve its application. You can have users use the system heavily and suddenly shut down the power - when power is back on - Navision
will be in the same good shap. The second goal was to provide robust graphical interface.
Microsoft RMS is SQL based application - this means that even C/ODBC is limited - Microsoft RMS is using alien database platform and
we do not recommend you to use MS SQL linked server to address Navision native database. The good news is - you can deploy our custom
integration tool, which imports transactions from MS RMS to native Navision Database.
If you use MS SQL Server as Navision platform? - then you are open for all Microsoft SQL Server tools, such as linked server and distributed
query. You can deploy your own programmers to move data from RMS to Navision via Transact SQL scripts/stored procs
Additional things t consider:
- Do you plan on Crystal Reports? - you can always deploy C/ODBC to enable your C/SIDE database for Crystal Report
- Do you need OLAP/Datawarehousing? - if you use MS SQL Server - you are positioned better. It has built in Analytical Server with
OLAP cube creation and Excel data pivoting
- Do you plan to expose Navision data to other applications? - Navision has tools to expose the data from C/SIDE database (C/ODBC, C/FRONT),
but in the case of SQL Server you certainly have standard Microsoft technologies in your disposition.
Happy integrating! if you want us to do the job or use our product - give us a call 1-866-528-0577! help@albaspectrum.com
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization
company, based in Chicago, Arizona, California, Colorado, Texas, New York, Georgia, Florida and having locations in multiple states and internationally
(www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
akarasev@albaspectrum.com
Related Topics
Microsoft Great Plains Dexterity Customizations
Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL - development options
Microsoft CRM Customization: Integration with third party SQL Application/Database
Microsoft RMS - Great Plains Integration - overview for IT specialist
Microsoft CRM Customization
Crystal Reports - Microsoft SQL Server
Crystal Reports design for Microsoft Great Plains - overview
|