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.
shuttle from Midway Glen Ellyn ..The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Research bears that less than 70 percent of development projects... Read More
The adware and spyware definitions list is very long. But... Read More
I suggest that you do not spend a lot of... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
The title of "software engineer" has got to be among... Read More
Viruses and spyware usually show up on your computer one... Read More
Following tips help you to learn a software in lesser... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
We all already got used to computer monitoring both at... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
Spyware and malware are large problems for Internet users today... Read More
Beginning with Domino version R4 it has integration with the... Read More
Navision Software was purchased by Microsoft and now it is... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Domino server is a buffer between the operation system and... Read More
Now that spyware is the single most dangerous threat to... Read More
Stealing company information used to be the specialty of spies... Read More
All of us know that Microsoft bought former Great Plains... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
shuttle from O'Hare North Chicago ..And kill the best layout software in the process of... Read More
The Windows Indexing Service provides you with the ability to... Read More
Music downloads are off the charts! We're listening to digital... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
We would like to give you several situations, when you... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
With any good luck and a good amount of hard... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Words we choose to describe things and phenomena often show... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Are you a whiz at calculating financial information? Not the... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Learning how to program software seems like a daunting task... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
Remember old good days when your company probably had Great... Read More
If your company has regional and worldwide operations, you might... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Software |