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.
Culver prom limo ..With the advent of 'Service Pack 2' for Windows XP... Read More
When reading an article where some term is used often,... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
When making a decision to buy any piece of software... Read More
The java programming language is becoming more and more popular... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
The objective for Zandi Digital is to make available clever... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
I love new technology. I am still ready to wait... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
In the case when you represent mid-size or mid-size-to-large business,... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Wood Dale limo ..While several preventive maintenance software manufacturers offer free trials for... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Whether you are an experienced web programmer or a complete... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
If you have Microsoft Great Plains and support it for... Read More
This is a short article, written in question/answer/FAQ style to... Read More
Homeland security, airport security, Internet security ??" these days we???re... Read More
What is a Web Database?A web database is a database... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
How to delete the user? This is the first problem... Read More
Spyware and malware are large problems for Internet users today... Read More
To all web designers out there, this article is for... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
One of the main reasons business owners and entrepreneurs use... Read More
When making a decision to buy any piece of software... Read More
Finding the best spyware removers to detect and remove spyware... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Sales are all about leverage, because there is only so... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
The fact that a software tester is a most infamous... Read More
Software |