Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist微軟Navision與微軟RMS -可概括為I T專家

By Andrew Karasev據Karasev
Microsoft Business Solutions Navision serves both European and American megamarkets.微軟商業解決方案Navision服務，歐洲和美洲megamarkets 。 It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment).它最初是由丹麥的Navision軟件在自己的專利C語言/方（客戶機/服務器集成開發環境） 。 Currently Navision is supported on two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server.目前Navision是支持兩個平台-N avision本地（丙/側）數據庫和微軟S QLS erver。 In this small article we would like to give you the clue on Navision integration with Microsoft Retail Management System - Microsoft RMS.在這小文章，我們想給你們的線索就Navision與微軟零售管理系統-微軟有效值。

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. 傳奇強度對C /側數據庫-歷史上的顯示N avision設計的主要目標有自己的專利數據庫，內置的功能數據庫事務的完整性。 As far as database is proprietary - Navision can manipulate its and tune it to serve its application.至於數據庫是專有的-N avision可以操縱和調整它的應用服務。 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.你可以有用戶使用該系統的重，突然關閉電源-當電源恢復- Na vision將在同一個良好的形狀。 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. 微軟RMS是基於應用的SQL -這意味著，即使ç /的O DBC是有限的-微軟RM S是使用外來物種數據庫平台和我們不建議您使用數據庫鏈接服務器來處理Na vision本地數據庫。 The good news is - you can deploy our custom integration tool, which imports transactions from MS RMS to native Navision Database.好消息是-您可以部署我們的定制集成工具，進口交易從M S有效值本地N avision數據庫。

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. 如果您使用MS SQL Server作為Navision平台？ -那你是開放所有微軟S QLS erver工具，如相連的服務器和分佈式查詢。 You can deploy your own programmers to move data from RMS to Navision via Transact SQL scripts/stored procs您可以部署自己的程序員將數據從有效值Navision通過的Transact SQL腳本/存儲procs

Additional things to consider:更多的事情需要考慮：

Do you plan on Crystal Reports? - you can always deploy C/ODBC to enable your C/SIDE database for Crystal Report. 你計劃的水晶報表？ -您可以隨時部署ç /的O DBC，使您的C /側數據庫水晶報表。

Do you need OLAP/Datawarehousing? - if you use MS SQL Server - you are positioned better. 你需要的OLAP /數據倉庫？ -如果你使用M SS QLS erver數據庫-你的位置更好。 It has built in Analytical Server with OLAP cube creation and Excel data pivoting它建立在分析服務器OLAP多維數據集創建和Excel數據樞軸

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 你的計劃，揭露Navision數據到其它應用程序？ -N avision已工具，以揭露的數據從C /側數據庫（丙/的O DBC和c /陣線） ，但在案件的S QLS erver你肯定有微軟技術標準在您的處置

Good luck in integration and if you have issues or concerns we are here to help!祝你好運，在集成與如果您有問題或concernsÂ我們來這裡是為了幫助！ If you want us to do the job - give us a call 1-866-528-0577!如果你想要我們做的工作-給我們一個電話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 (安德魯Karasev是首席技術執行官在微軟商業解決方案合作夥伴：阿爾巴頻譜技術美國全國Navision公司，大平原，微軟CRM定制化公司，總部設在芝加哥，加利福尼亞州，亞利桑那州，德克薩斯州，佛羅里達州，紐約州，喬治亞州，華盛頓州，科羅拉多州，加拿大，英國，澳大利亞和地點有多個國家和國際（ www.albaspectrum.com ). ） 。

You can contact Robert:你可以聯絡羅伯特： welcome@albaspectrum.com . 。 akarasev@albaspectrum.com

Article Source:文章來源： http://EzineArticles.com/?expert=Andrew_Karasev

Save $30 instantly on McAfee Total Protection and Internet Security! 保存30美元即時的McAfee Total Protection和互聯網安全！