BizTalk Innovation Day, London – Charles Young and Jon Fancey confirmed as Q&A panellists

We are ramping up our preparation for BizTalk Innovation Day London http://bid.biztalk360.com . You can read more about it in the detail blog post here "BizTalk Innovation Day, London. 16th January 2013" We wanted to make it big and exclusive for people who are involved in the Microsoft BizTalk server space. We originally planned for […]

The post BizTalk Innovation Day, London – Charles Young and Jon Fancey confirmed as Q&A panellists appeared first on BizTalk360 Blog.

Blog Post by: Saravana Kumar

BizTalk, SalesForce and timezone

BizTalk, SalesForce and timezone

I had the interesting request that it was important to a system (SalesForce) to set the right time including the timezone.

So I created a .Net function with a string as input and a string as output. This function is call from a map. Here are the function:

DateTime myDateTime = Convert.ToDateTime(input);
TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById(“W. Europe
Standard Time”
);
TimeSpan offset =
tzi.GetUtcOffset(myDateTime);
DateTimeOffset d = new DateTimeOffset(myDateTime, offset);
string
output = d.ToString(
“o”);

The Id of the zone can be found by running through all the names by running this code:

ReadOnlyCollection<TimeZoneInfo> zones = TimeZoneInfo.GetSystemTimeZones();
Console.WriteLine("The local system has the following {0} time zones", zones.Count);
foreach (TimeZoneInfo zone in zones)
   Console.WriteLine(zone.Id);
The result is in a format that this, which also takes care of DST (Daylight saving time):
2012-07-02T02:12:00.0000000+02:00 (input --> 02-07-2012 02:12) 2012-02-28T14:00:00.0000000+01:00 (input --> 28-02-2012 14:00)

Random posts:

Help me, help you. You know how 😉 (click, click, click…)


SQL Server Configuration Manager – Error 0x80041010

SQL Server Configuration Manager – Error 0x80041010

When opening the SQL Server Configuration manager (for SQL Server 2008 R2 in my case), I kept getting following error:

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]

The solution to resolve this turned out to be quite simple. Just open a command prompt and execute following command:

C:\Program Files\Microsoft SQL Server\100\Shared>mofcomp “C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”

Depending on the SQL version installed the path to the file could also be something like C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof

New minor release of BizTalk Scheduled Task Adapter for BizTalk Server 2010 is now available

New minor release of BizTalk Scheduled Task Adapter for BizTalk Server 2010 is now available

Finally I had some free time available to be able to update and fix some minor bugs which existed in the latest version of this adapter and already had been reported by community members. I have to give a special thanks to maakku that reported a problem related to the Daily schedule properties and the […]
Blog Post by: Sandro Pereira

Running both Windows 7 and Windows 8 in a MacBook Pro

Last month I updated my main laptop MacBook Pro to Windows 8 and I’ve written about the experience here "Installing Windows 8 on MacBook Pro experience".  There are no noticeable issues and I’m quite pleased with it. Even though technically all of the applications that run in Windows 7 should run on Windows 8, still […]

The post Running both Windows 7 and Windows 8 in a MacBook Pro appeared first on BizTalk360 Blog.

Blog Post by: Saravana Kumar

BizTalk maps with two inputs – Complement, Intersect and Union of Sets

BizTalk maps with two inputs – Complement, Intersect and Union of Sets

Union In set theory, the union (denoted by %u222a) of a collection of sets is the set of all distinct elements in the collection. It is one of the fundamental operations through which sets can be combined and related to each other. (http://en.wikipedia.org/wiki/Union_(set_theory)). For example, if A = {1, 2, 3, 4, 5, 6, 7} […]
Blog Post by: mbrimble

WCF SQL operations

WCF SQL operations

Normal
0

false
false
false

EN-AU
X-NONE
X-NONE

MicrosoftInternetExplorer4

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:”Calibri”,”sans-serif”;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:”Times New Roman”;
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}

When adding WCF sql ports to BizTalk, you can add a whole
host of different types of operation with SQL and it’s incredibly powerful. 
The problem is with all these options, the wizard rarely
makes a binding file for you, it will make the schemas, but the binding file
contains that extra little bit of magic

The key to all of this in the SOAP action header you specify on the port.
There are your basic ones:
TableOp/Insert/dbo/Employee
TableOp/Update/dbo/Employee
If you read this, it will do a table operation and insert or
update employee record(s) in the employee table.

Then there is of course stored procedures for both send and receive ports. 


TypedProcedure/dbo/StoredProcedureName

Simple enough, however maybe you have a few operations you
want to do, you want to go for a more composite operation. 
Your Soap action can be CompositeOperation
The message you send can do a whole host of things, for
example, insert into a table, and when done, run a stored procedure.
You have your insert schema, and your execute stored
procedure schema, that the wizard generates, now bundle this into the following
structure and all of a sudden a whole world of opportunities opens up.
<xs:element name=Request>
    <xs:complexType>
      <xs:sequence>
        <xs:element
ref=ns0:Insert />
        <xs:element
ref=ns1:CompareEmployee />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element
name=RequestResponse>
   <xs:complexType>
    <xs:sequence>
     <xs:element
ref=ns0:InsertResponse />
     <xs:element
ref=ns1:CompareEmployeeResponse/>
    </xs:sequence>
   </xs:complexType>
 
</
xs:element>
Then there are the Generic operations, vastly undocumented,
for example a SQL reader, that can execute SQL against the database and return
the results of the query
Your Soap Action header would be: GenericOp/ExecuteReader
The schema looks like this:
  <ExecuteReader
xmlns=http://schemas.microsoft.com/Sql/2008/05/GenericTableOp/>
    <Query>[PL/SQL
STATEMENT1];[PL/SQL STATEMENT2];</Query>
  </ExecuteReader>
Have a look at some of the more unknown options available, and you start to see the power in all of this. 

Operation
Soap Action
 Header
ExecuteNonQuery
Request
GenericOp/ExecuteNonQuery
ExecuteNonQuery
Response
GenericOp/ExecuteNonQuery/response
ExecuteReader
Request
GenericOp/ExecuteReader
ExecuteReader
Response
GenericOp/ExecuteReader/response
ExecuteScalar
Request
GenericOp/ExecuteScalar
ExecuteScalar
Response
GenericOp/ExecuteScalar/response

Refer to this link for more: http://msdn.microsoft.com/en-us/library/dd788372%28v=bts.10%29.aspx