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
Good luck in integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
About The Author
Andrew Karasev is Chief Technology Officer in Microsoft Business Solutions Partner: Alba Spectrum Technologies ? USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (help@albaspectrum.com). You can contact Robert: help@albaspectrum.com.
monthly home cleaning Buffalo Grove ..When it comes to screenplay software each screenwriter needs to... Read More
Fleet Maintenance Management is a critical position in any company... Read More
I have yet to see a business that, sometimes in... Read More
Fundraising software lets you connect with donors in a way... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
One day, you suddenly realize that your computer started to... Read More
The world of small business accounting software can be a... Read More
If you copy something from a Web site or elsewhere...... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
In the real world a "fire wall" is a fireproof... Read More
Software development is a risky business.Many software developers are barely... Read More
In this article you will find some background information about... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
C++ Function templates are those functions which can handle different... Read More
Just imagine: you are walking, say, towards your car, and... Read More
scheduled maid service Mundelein ..This is the tutorial where we really get into programming.... Read More
Viruses and spyware usually show up on your computer one... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
We would like to give you pluses and minuses of... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Almost all new and major brand of PCs come with... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
If you are to buy a HelpDesk & Asset Management... Read More
When you need a phone number, you do a quick... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
This article is the first of a series of articles... Read More
In the real world a "fire wall" is a fireproof... Read More
Just when you thought you were Web savvy, one more... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
If you would like to pick something from Microsoft, or... Read More
In a previous article, I wrote about OpenOffice... Read More
How many steps does it take you to locate and... Read More
With many manufacturing shops heading over seas in favor of... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
In this small article we will be looking at the... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Are you one of those people that keeps track of... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
Software |