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 ..Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Microsoft Outlook is one of the most widely used software... Read More
Did you ever give a thought to the number of... Read More
Navision Software was purchased by Microsoft and now it is... Read More
The software giants don't do everything and don't always produce... Read More
Remember old good days when your company probably had Great... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Three highly respected names in Human Resources have joined forces... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
If you have Microsoft Great Plains and support it for... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Java has come along a long way. Many would agree... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Do you want to get quality software at a reasonable... Read More
Sometimes your PC will start acting strange for no apparent... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Using professional icons in your application or website can bring... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
scheduled maid service Mundelein ..When Great Plains Software was designing and developing Great Plains... Read More
In a previous article, I wrote about OpenOffice... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Linux essentials:It's free for download but you have to pay... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Fortunately one of the most common reasons cited for the... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Adware is a type of Spyware program that displays some... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
1. With mapping software you can create a report that... Read More
The Windows registry is a huge database that ensures normal... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
In the Clinton era the status quo was simple: you... Read More
Not every software testing project can or should be automated.... Read More
When reading an article where some term is used often,... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
In the new era of internet marketing the problem of... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
XML parser is a software module to read documents and... Read More
Software |