SOA and Host Systems

Posted: May 12, 2007  |  Categories: BizTalk HIS 2006 Host Systems SOA Uncategorized

Microsoft recently released a white paper about leveraging value of host systems with real world SOA. The paper can be downloaded here. We from Microsoft Unit at Inter Access are now doing some researched based on this paper. We are trying for instance to call RPG code on AS/400. In a previous posts I mentioned I have been able to extract data from DB2 on AS/400, so connecting to AS/400 was easy. Same counts for connecting to a DB2 database. My colleague Hugo has written a nice tool to view data inside DB2 that helps to indentify tables, colums and so on.

I must say he has done a nice job with only a few lines of code:

MsDb2Connection con = new MsDb2Connection(textBox1.Text);
MsDb2Command command = new MsDb2Command(textBox2.Text, con); MsDb2DataAdapter adapter = new MsDb2DataAdapter(command);
MsDb2Transaction tran = null;
DataSet ds = new DataSet();

tran = con.BeginTransaction(IsolationLevel.ReadCommitted);
command.Transaction = tran;
dataGridView1.DataSource = ds.Tables[0];

textBox3.Text = string.Format(“Records selected: {0}”, ds.Tables[0].Rows.Count.ToString());

catch (Exception ex)
textBox3.Text = string.Format(“Exception: ” + ex.Source + ” Message: ” + ex.Message);

By using Microsofts Host Integration Server one can connect to back-end systems like AS/400. With this product from Microsoft functionality, data that resides on legacy systems can be exposed to outside world through services. So these systems can be still usefull inside an organisation and through services made available. Hence services can expose functionality/data from these systems a SOA is perfect. SOA provides capabilities to legacy systems to interact more with modern business process management and workflow tools. From Microsoft view this will be BizTalk Server and Workflow Foundation. More findings about our research will be posted later on.


Author: Steef-Jan Wiggers

Steef-Jan Wiggers is all in on Microsoft Azure, Integration, and Data Science. He has over 15 years’ experience in a wide variety of scenarios such as custom .NET solution development, overseeing large enterprise integrations, building web services, managing projects, designing web services, experimenting with data, SQL Server database administration, and consulting. Steef-Jan loves challenges in the Microsoft playing field combining it with his domain knowledge in energy, utility, banking, insurance, healthcare, agriculture, (local) government, bio-sciences, retail, travel, and logistics. He is very active in the community as a blogger, TechNet Wiki author, book author, and global public speaker. For these efforts, Microsoft has recognized him a Microsoft MVP for the past 8 years.


Back to Top