Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves bothour custom integration tool, which imports transactions
European and American megamarkets. It was originallyfrom MS RMS to native Navision Database.
written by Denmark-based Navision Software in itsIf you use MS SQL Server as Navision platform? -
own proprietary language C/SIDE (Client/Serverthen you are open for all Microsoft SQL Server tools,
Integrated Development Environment). Currentlysuch as linked server and distributed query. You can
Navision is supported on two platforms - Navisiondeploy your own programmers to move data from
native (C/SIDE) database and on Microsoft SQLRMS to Navision via Transact SQL scripts/stored
Server. In this small article we would like to give youprocs
the clue on Navision integration with Microsoft RetailAdditional things t consider:
Management System - Microsoft RMS.Do you plan on Crystal Reports? - you can always
Legendary Strength of C/SIDE database - the historydeploy C/ODBC to enable your C/SIDE database for
of Navision design reveals the primary goals to haveCrystal Report
its own proprietary database with the built-in featuresDo you need OLAP/Datawarehousing? - if you use
of database transaction integrity. As far as databaseMS SQL Server - you are positioned better. It has built
is proprietary - Navision can manipulate its and tune itin Analytical Server with OLAP cube creation and
to serve its application. You can have users use theExcel data pivoting
system heavily and suddenly shut down the power -Do you plan to expose Navision data to other
when power is back on - Navision will be in the sameapplications? - Navision has tools to expose the data
good shap. The second goal was to provide robustfrom C/SIDE database (C/ODBC, C/FRONT), but in
graphical interface.the case of SQL Server you certainly have standard
Microsoft RMS is SQL based application - this meansMicrosoft technologies in your disposition
that even C/ODBC is limited - Microsoft RMS is usingGood luck in integration and if you have issues or
alien database platform and we do not recommendconcerns - we are here to help! If you want us to do
you to use MS SQL linked server to address Navisionthe job - give us a call 1-866-528-0577!
native database. The good news is - you can deploy