November 6th, 2012
This article is the companion part from the last article and to easily understand this article you should read the first part. This article elaborate the integration between Navision and BizTalk Server using WCF technology and it would be an alternative solution apart from using Commerce Gateway adapter component. The elaboration in this article would be heavily with BizTalk WCF adapter technology and .NET COM component wrapper which I developed by Visual Studio 2010 Express Edition in C# language. The test solution environment are based on Windows Server 2003 32 bits, BizTalk server 2006 R2 and Navision 2009 R2. It is very high likely, the solution would prevail with higher windows version and higher BizTalk server version.
August 15th, 2012
Recently, I have been thinking of Navision Commerce Gateway future module especially the BizTalk Commerce Gateway adapter. The latest Microsoft platform are moving forward to 64 bits and Navision maturity closer to .net. These situation cause Commerce Gateway adapter torn out to be good solution or unfitted. Wonder if Microsoft Dynamics would disclose for new technology solution or would rather let the partner to do them self. I can understand people tried to make BizTalk server injecting data into or pulling data from Navision SQL database thru BizTalk SQL adapters. Certainly, there is nothing wrong with it but it has many limitation for few and more integration transaction to go along with it. Regardless, Navision 2009 introduce SOAP web service and high lightly it is good starting point to exploring BizTalk talk to Navision via Navision SOAP web service. In this article I am focusing on how to consume Navision web service and will talk about Navision consuming BizTalk WCF service in another post article.
In the past, I was writing some article regarding project integration with older Navision version. The article overall was about developing a web service extension for exposing Navision business process and data domain reach out to external. In Navision 2009 however, the web service existence really make integration much more easily. This article is resuming from past project integration, I would like to share with you the web service request/response pattern based on Navision web service 2009.
February 18th, 2011
Recently, I have been developing a batch job automation to extract/import Navision tables into/from xml format. Well it is not quite challenging if I have to use XML port object for each table and this is straight forward solution. However, in my case, I would like to extract/import any table dynamically from user selection during runtime and I don’t wish to create each xml port object for each table in Navision.
Certainly I am looking at RecordRef and FieldRef data type that would be my outmost possible solution and indeed I almost there but I was stuck with Blob data type and check mate. As you have probably known the field reference provide us with Value or Validate method to extract or to assigned the value for a field. These methods are seem good for simple data types and very unfortunately the method of CREATEINSTREAM and CREATEOUTSTREAM are absent from field reference and it is seem I am turn into the end of the road.
June 23rd, 2010
Recently, I have been thinking of consuming typical web service such currency exchange rate or RSS weather forecast from Navision. So I come to think how to consume all these services on the web and finally I found “HTTPWebRequest” class under System.Net framework that help me do the wonders. So, I am exciting to create the COM wrapper for Navision to make a request and capture the response. Like usual, I am using Microsoft Visual C# 2008 express editions and Navision message type designer to managing XML at Navision side. Let’s go with substantial matter now.
June 14th, 2010
This article is the next project from last article regarding the .net component of Navision message service which contains all the message contracts. In this article I will talk about the .net component creation that contain WCF service contract, operation contract and host them in IIS application. This component will utilize the .net Navision message service to communicate with Navision listener.
June 5th, 2010
In this article I would like to share with you about creating .net component that contains Navision message service library. The first plan is to have message structure in C# class for each message type so the message communication can be easily constructed in .net development. Secondly, I could have the message contract library component that will support the WCF services project. Nevertheless, Navision 4.0/5.0 cannot generate Meta data that I need to generate C# message class but with certain extend it is possible. This article I would share with you the way to achieve this rapidly and hopefully you can catch the concept why I develop message type designer at first place at Navision and relation to this article.
June 1st, 2010
This is the last fraction of Navision TCP/IP listener component which I ever mentioned in previous article. You can use this connector to communicate with Navision listener for many advantages. To inline with the overall project integration, I want this connector component to assist creating Navision service on top of WCF technology. The result of this component would be just an assembly that provide encapsulation of the detail communication between the client and the Navision listener. I am developing this component using Microsoft Visual C# 2008 Express editions.
Read the rest of this entry »
May 29th, 2010
I am back with Navision project integration article after a while I have been worked underground for research, studying and mock up development. This article would be the second sub project elaboration of Navision Integration Project and perhaps you could spend a little time read previous article regarding Integration Project for refreshment. This article would be heavy with Microsoft .Net framework stuff, C# languages and of course Navision C/AL codes. This project development has some objectives as follow:
- To develop component COM Wrapper TCP/IP listener for Navision.
- This component would be the passageway of communication between Navision and external system.
- Data format would be in XML but not limited and this conjunction with Navision Message Type Designer development project.
- This component would be run on Navision Application Service (NAS) and Navision client.
This component is server listener and certainly needs TCP client component which will make request and communicate with. Unfortunately this article would not cover the client component but in next article post. So, please stay tune and have fun with current article.
May 19th, 2009
In this article I would like to share the project development in Navision which is one part project integration. This article explains conceptual design and simple real practices that hopefully can be easily understand and give you some idea handling the integration.It is clear that XML is the most outstanding option for exposing Navision information to the world and also allow Navision to digest information in XML format. So it is said Navision C/AL native language could not be alone dealing with XML directly until XMLPORT object type arises in Navision 4.0. The other alternative options is using Microsoft XML DOM component in which echoing this as an automation variable in Navision C/AL.I have some reasons to use automation over the XMLPORT in here and indeed to align with the goal of this development. I have written some reason in the past article and wish you could visit them for your glance.There are few main objectives in this development as follow:
- To create a designer that allow developer construct the XML message rapidly
- Providing a form that easy to maintain and administer message type and it’s process
- To develop framework that will help developer to handle the messages in record base.