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 (www.albaspectrum.com). You can contact Robert: welcome@albaspectrum.com.
limousine chicago serviceCustomer Relationship Management or CRM is a combination of enterprise... Read More
We were recently faced with a decision: either to let... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
And kill the best layout software in the process of... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
There are so many different programs that clutter up your... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Fleet Maintenance Management is a critical position in any company... Read More
Are you one of those people that keeps track of... Read More
There is many things more frustrating than surfing a website... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Remember old good days when your company probably had Great... Read More
During the years of our consulting practice, which comes back... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
When you visit department stores and see that majority of... Read More
We would like to give you pluses and minuses of... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
So, why should you use any O/R mapping tool? I... Read More
induction self-ballasted led street light suppliers Pete's produce ..Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
It's no secret that software companies operate in a very... Read More
We would like first emphasize the change in the paradigm.... Read More
Software development is a risky business.Many software developers are barely... Read More
IntroductionPHP can be used for a lot of different things,... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Stealing company information used to be the specialty of spies... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Have you ever noticed that when you look at your... Read More
How do you run a program on a remote server... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Usually workflow & messaging is realized in CRM and then... Read More
As seeing large number of implementations ? in our case... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
Finally, you have some time to personalize your desktop with... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
In a previous article, I wrote about... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
Are you one of those people that keeps track of... Read More
Accounts payable is just one area of office management where... Read More
Once a business idea is selected, it is highly recommended... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Software Software |