Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

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 (www.albaspectrum.com). You can contact Robert: welcome@albaspectrum.com.

akarasev@albaspectrum.com

MORE RESOURCES:

Microsoft: New software not Symantec, McAfee rival - Reuters

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/0i-0fd=Rurl=http://news.bbc.co.uk/1/hi/technology/7737520.stmcid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNHWaIAYBwrIKtBLiDBUroA6SQR5nwimg src=http://news.google.com/news?imgefp=ZEi3QvPWjUEJimgurl=newsimg.bbc.co.uk/media/images/45151000/jpg/_45151313_windowsindex.jpg width=80 height=60 alt= border=1brfont size=-2BBC News/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/0-0fd=Rurl=http://www.reuters.com/article/technologyNews/idUSTRE4AI7T420081119cid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNEdqzXuoh4d-K_uMxsbe4TAEOyjVAMicrosoft: New bsoftware/b not Symantec, McAfee rival/abrfont size=-1font color=#6f6f6fReutersnbsp;-/font nobr23 hours ago/nobr/fontbrfont size=-1BOSTON (Reuters) - Microsoft Corp#39;s upcoming security bsoftware/b is not designed to take sales from Symantec Corp and McAfee Inc as it is a stripped-down, b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-1fd=Rurl=http://education.zdnet.com/%3Fp%3D1965cid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNHvu07wuKttv97-q5et7MCSHfsG3AI really don’t want to use Windows anymore/a font size=-1 color=#6f6f6fnobrZDNet/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-2fd=Rurl=http://www.allheadlinenews.com/articles/7013120895cid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNEF_bKLUHm72lSu0jKphcASja9R4wMicrosoft To Stop Paid PC Security Service, Offers Free Anti-Virus b.../b/a font size=-1 color=#6f6f6fnobrAHN/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-3fd=Rurl=http://www.networkworld.com/news/2008/111808-microsoft-drops-onecare-antivirus.html%3Ft51hbcid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNHDJwISctQeGef_bSJHOIdprHuIlAMicrosoft to offer free security bsoftware/b/a font size=-1 color=#6f6f6fnobrNetworkWorld.com/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/0-4fd=Rurl=http://www.bizjournals.com/sanjose/stories/2008/11/17/daily43.htmlcid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNFiC8xk85_IZum8ufShuT9IkGf_egnobrBizjournals.com/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/0-5fd=Rurl=http://www.internetnews.com/software/article.php/3786246/Microsoft%2BOffers%2BFree%2BSecurity%2BPulls%2BLive%2BOneCare.htmcid=1272030386ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNF1HOxy5e3e_0y3LQWKqLHMYUjMtwnobrInternetNews.com/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272030386hl=ennobrall 285 news articles/nobr/a/font/div/font/td/tr/table

American Software, Inc. Invites You to Join Its Second Quarter ... - MarketWatch

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/1-0fd=Rurl=http://www.marketwatch.com/news/story/American-Software-Inc-Invites-You/story.aspx%3Fguid%3D%257B3B268B55-50D6-4DDF-89D4-2D9832A1DC01%257Dcid=1272655668ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNFJdu0lHh2AeSPME776h-oilM94ewAmerican bSoftware/b, Inc. Invites You to Join Its Second Quarter b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr30 minutes ago/nobr/fontbrfont size=-1Headquartered in Atlanta, American bSoftware/b develops, markets and supports one of the industry#39;s most comprehensive offerings of integrated business b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-1fd=Rurl=http://www.earthtimes.org/articles/show/american-software-inc-invites-you,631790.shtmlcid=1272655668ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNEztaDT1zz91YydC5i2Tp4WvtfvfgAmerican bSoftware/b, Inc. Invites You to Join Its Second Quarter b.../b/a font size=-1 color=#6f6f6fnobrEarthtimes (press release)/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272655668hl=ennobrall 8 news articles/nobr/a/font/div/font/td/tr/table

New Edition of Email Newsletter Software Delivers Improved Email ... - MarketWatch

HighJump Software Helps Customers Do More in Less Time With New ... - MarketWatch

Turning Technologies#39; TurningPoint(R) Student Response Software ... - MarketWatch

Intrinsyc Software International, Inc.: Leading Device Maker ... - MarketWatch

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/5-0fd=Rurl=http://www.marketwatch.com/news/story/Intrinsyc-Software-International-Inc-Leading/story.aspx%3Fguid%3D%257B0E88B10F-7273-45B8-9EB5-A0032F73EA4A%257Dcid=1272557160ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNERSS29YEshFT7aFf2wq-Uq2xcqzQIntrinsyc bSoftware/b International, Inc.: Leading Device Maker b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr7 hours ago/nobr/fontbrfont size=-1Destinator navigation bsoftware/b sets new standards for driver safety, ease-of-use, rich content and user interface customization. b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/5-1fd=Rurl=http://www.trucknews.com/PressReleases/FullStory.asp%3FArticleID2%3D3464174cid=1272557160ei=L84lSc3wA5zI8AS21aG5AQusg=AFQjCNHgNVvPjO3SIXuKi1De4IJxlOpVpwAbout Intrinsyc bSoftware/b International, Inc./a font size=-1 color=#6f6f6fnobrTruck News/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272557160hl=ennobrall 20 news articles/nobr/a/font/div/font/td/tr/table

DataCore Software, Promise Technology and Microsoft Windows HPC at ... - MarketWatch

Research and Markets: Software-as-a-Service in APAC - The Momentum ... - MarketWatch

New Accounting Software Enhancements Recommended and Prioritized ... - MarketWatch

SPSS Delivers 403% ROI for Insurance Company with Predictive ... - MarketWatch

Software - Google News

RELATED ARTICLES

Bill of Lading - Custom Reporting for Microsoft Great Plains - Overview for Consultant
Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business - Bill of Lading with multiple custom forms should be present there.

Recovering Microsoft Great Plains Customization - Tips for IT Director
Remember nice and prosperous Clinton era? When you implemented innovative those old days accounting application - Great Plains Dynamics. And did a lot of customizations to fit your business requirements precisely.

Microsoft Business Solutions Partner - How to Launch New IT Consulting Practice
In the new era of internet marketing the problem of severe competition comes into the first position. If you look back into 1990-th you will find high tech companies using traditional sales techniques: purchasing local and regional businesses contact lists, making cold calls and then trying hard sales closing techniques, such as "selling to the top" - IBM style, selling to VITO (very important top officer), etc.

Can You Calculate Complex Financial Calculations?
Are you a whiz at calculating financial information? Not the easy personal stuff, like figuring out your monthly mortgage based on a fixed interest rate for x number of years, or how much money you have available each month after all your bills are paid. (You can probably use your fingers to figure that one out!)But the hard stuff, you know, the things you need to know when you're running a small business.

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation
If you would like to pick something from Microsoft, or its ERP subdivision - Microsoft Business Solutions, and in case of large public company, you should consider these three: Axapta, Navision or Great Plains. We are not talking about Solomon here, because it is recommended for project organization.

Microsoft CRM for Corporate Business - Working Offline
If your company has regional and worldwide operations, you might already realized that it is very hard to get decent internet connection in your remote locations. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection.

Microsoft Great Plains: Customization Upgrade & Recovery - Visual Studio VB 6.0
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th - the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6.

Vlans
In order to implement VLANs in a network environment, you'll need a Layer 2 switch that supports them. Almost all switches sold today that are described as "managed" switches provide the ability to make ports members of different VLANs.

Software Tools To Help Your Business Sell More
Sales are all about leverage, because there is only so much you can do on your own. But, with the help of these simple tools, you can easily double, triple and quadruple your productiviting and make more sales.

Causes of ERP Failures
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP software integrates business activities across various functional departments, from product planning, parts purchasing, inventory control, product distribution, to order tracking.

Dashboard Widgets for Windows
For a windows user like me, just can watch with envy the new eye candy features in Mac OS X and wondering how I can have the same feature on my belove windows.Before Apple introduce dashboard in their latest Mac OS X, most of mac users already can have widget on their desktop using Konfabulator by Pixoria Inc.

SyncUp - A File/Folder Synchronizer For Windows
SyncUp, a file synchronizer is designed to assist the home and advanced users. The product has a simple and familiar windows explorer type interface for easy file handling.

Spyware Protection: A Must for Any Home Computer
Now that spyware is the single most dangerous threat to home computers connected to the internet today, getting your hands on some sort of spyware and adware protection is critical. Spyware has outpaced computer viruses in its prevalence, and in the kind of damage it can do to your system.

Microsoft Great Plains Inventory Control - Overview For Consultant
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features.

eConnect: eCommerce Development for Microsoft Great Plains
Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder - this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web.

Run Your Own Search Engine
Our hosted solution allow you to run your own search engine.You can have your own special search engine such as travel, games,animals, medical, software, sports, music, cars or any other category you like.

How the Firefox: How to... Manual Helped Me
A few months back I really got sick of my computer always being slow and having system errors. So I started doing a bit of research and heard of a new browser called "Firefox".

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content
It's no secret that software companies operate in a very competitive space where rivalry is increasingly fierce and where profit margins can be razor thin. New, smaller software companies are sprouting up each month and the leading software companies continually make strong advancements forward leveraging massive cash flow reserves.

Razzle Dazzle Them
Once upon a time not so long ago, there was a little boy who went to the market to try to sell his wares. He wasn't having any luck.

Windows Screensavers Explained
In this article you will find some background information about screensavers and their history. You will also learn how Windows screensavers differ from other programs and how you can use it to your own advantage.