Monday, December 30, 2013
Monday, July 4, 2011
Expert day 2011
So it seems that I'm going to participate in this great event.
Check it out on: http://www.facebook.com/experts4d
Check it out on: http://www.facebook.com/experts4d
Monday, February 15, 2010
How to test a pipeline
You can find in this link
Inside you can find a sample to use XPathMutator to quick ly extract Xml using XPath queries
Labels:
BizTalk 2006,
Testing,
XPath,
XPathMutator
Wednesday, December 23, 2009
How to build a message in helper
I've found wonderful post about building a message inside orchestration (via helper)
Labels:
.Net Assemblies,
BizTalk 2006,
BizTalk 2009
Friday, August 7, 2009
Thursday, July 23, 2009
Connecting to Oracle via SQL Adapter
In a specific scenario, we needed two receive location bounded to Oracle db.
One was simple, we needed a table rows to start a process. This was eazy using BizTalk Oracle Adapter. Installing Oracle client, defining TNS, and connection establish.
The other data we needed was a bit more complex. We needed the employee courses including subject learned in the course.
The Oracle adapter can not receive XML queries as result, so we preffered to define a linked server from SQL to Oracle, define the query SQL with the linked server like that:
Select *
from
OpenQuery(Ora,"Select empid,courseid,x1....xn from courses") course,
OpenQuery(Ora,"Select empid,courseid,y1...ym from subjects") subject
where
course.empid = subject.empid and
course.courseid = subject.courseid
for xml auto
the query worked fine in SQL Managment studio. But the receice location query failed in the adapter since the BizTalk tried to add the Oracle DB to the distributed transaction belongs to the SQL Server, over the linked server.
When searching this issue, I came accross a blog, Joe unfiltered: BizTalk, SQL linked servers and DTC trying to do the same.
Following the post solution, we created new linked server, adding the string "DistribTX=0" to Provider settings (and selecting Oracle OLE DB Provider - instead of MSDAORA), which solve the issue.
Shimshon Fishler
שמשון פישלר
One was simple, we needed a table rows to start a process. This was eazy using BizTalk Oracle Adapter. Installing Oracle client, defining TNS, and connection establish.
The other data we needed was a bit more complex. We needed the employee courses including subject learned in the course.
The Oracle adapter can not receive XML queries as result, so we preffered to define a linked server from SQL to Oracle, define the query SQL with the linked server like that:
Select *
from
OpenQuery(Ora,"Select empid,courseid,x1....xn from courses") course,
OpenQuery(Ora,"Select empid,courseid,y1...ym from subjects") subject
where
course.empid = subject.empid and
course.courseid = subject.courseid
for xml auto
the query worked fine in SQL Managment studio. But the receice location query failed in the adapter since the BizTalk tried to add the Oracle DB to the distributed transaction belongs to the SQL Server, over the linked server.
When searching this issue, I came accross a blog, Joe unfiltered: BizTalk, SQL linked servers and DTC trying to do the same.
Following the post solution, we created new linked server, adding the string "DistribTX=0" to Provider settings (and selecting Oracle OLE DB Provider - instead of MSDAORA), which solve the issue.
Shimshon Fishler
שמשון פישלר
Labels:
BizTalk 2006,
DTC,
for XML Auto,
linked server,
OpenQuery,
Oracle Adapter
Sunday, July 12, 2009
Sending email attachments from BizTalk orchestration
There are some ways to add attachments to outgoing email from BizTalk orchestration.
One method is the use dynamic send port and to set output message content with the attachments paths.
The syntax for the "SMTP.Attachements" property is File1File2...
Sample:
Msg(SMTP.Attachements)="C:\Temp\smpt1.jpgC:\Temp\smpt2.jpg";
Shimshon
Labels:
Adapter,
BizTalk 2006,
BizTalk 2009,
Gaurdian,
microsoft,
SMTP,
Software
Subscribe to:
Posts (Atom)