First Post

-
Hi,

My name is Tim D'haeyer. I've been working with BizTalk and integration for almost 10 years now. I'm currently working as Integration Platform Coördinator at Puratos (We produce ingredients for bakery, patisserie and chocolate)
I'll be blogging about things I work on during my projects. So you can expect real life scenarios that hopefully help you in your own projects.
Some of the topics you can expect here are

  • EDI
  • SAP
  • SuccessFactors
  • XSLT (Just because I like it ☺)
  • And hopefully many more
I hope you enjoy my posts and you can always contact me personally if you have questions or requests.

Kind Regards
Tim

Comments

Post a Comment

Popular posts from this blog

Query SAP HANA from BizTalk

-
Image
ODBC The easiest way to connect to a HANA table or view, is to use ODBC. BizTalk has an ODBC adapter, but to be honest, try to avoid using that to connect to HANA. It's not easy to use and you can't find alot of documentation about it. The best option is to setup a linked server in SQL Server. In the back, it also uses ODBC, but you will be able to query the data with the WCF-SQL adapter which is alot easier. Setup a linked server To be able to connect to HANA, you will need to install the SAP HANA Client. Watch out, there is a 32bit and a 64bit version. Make sure that you get the correct one. You can download this from the SAP support site, but you need an account. So find somebody who has an account and ask them to download the latest version and install it on your SQL server. Second step is to setup a new System DSN in the ODBC Data Source Administrator. In the next screen, enter a relevant name and description, and provide the server and port of your HANA ser...
Read more

Receive invalid xml through WCF adapter

-
Image
Recently I had a small project that involved getting exchange rate data from the website of the Central Bank of the Republic of Turkey (CBRT). http://www.tcmb.gov.tr/kurlar/201707/10072017.xml Basically I just needed to do an HTTP GET to a specific URL, and that would give me back an xml with the exchange rate information I needed. So my first thought was to just use a WCF sendport with the webHttpBinding to download this. The first test I make results in the following error message. System.Xml.XmlException: Processing instructions (other than the XML declaration) and DTDs are not supported. Line 2, position 2. When I looked closer at the XML I get back, I saw that it contained a reference to an xsl file to make the file readable through a browser. <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="isokur.xsl"?> <Tarih_Date Tarih="07.07.2017" Date="07/07/2017"  Bulten...
Read more

Azure API Management : Exposing backend SOAP service as REST

-
Image
A very common scenario for any API management tools is to expose an (older) back end SOAP service as a REST JSON service. In this post I will explain how you can do this in Azure API Management. I'm not an API management expert, this is just my experience. The service The case I will be using is a WCF-basicHttp service hosted on a BizTalk 2010 machine and IIS. The service to list customers in the ERP (SAP). The SOAP request and response look like this. Request <CustomerList xmlns="http://www.mydomain.com/schemas/"> <SalesOrganizations> <SalesOrganization>XXXX</SalesOrganization> </SalesOrganizations> <WebshopRelevant>true</WebshopRelevant> </myp:CustomerList> Response <CustomerListResponse xmlns="http://www.mydomain.com/schemas/"> <Customer> <CustomerNumber>0000000001</CustomerNumber> <SalesOrganization>XXXX</SalesOrganization> <Lastname>Customer 1...
Read more