Microsoft BizTalk France

For one of our main customers, we integrated the Customer's legacy system to SalesForce. The project "is an out of the box" solution. We not only integrated BizTalk Server with SalesForce, but we putted in place a Tracking Framework that users can manipulate for instance:

- what is the content of the message sent to SalesForce,

- A Clear view of Successful messages and failed messages,

The display of the tracking enabled framework is based on SQL Server Reporting Services.

We would be willing to help our future customers with what we learned, a demo is available, please feel free to contact us

Tags:

Hits: 3362 | Read more...

http://msdn.microsoft.com/en-us/library/cc952299%28BTS.10%29.aspx

http://msdn.microsoft.com/en-us/library/bb246105%28BTS.70%29.aspx

Tags:

Hits: 656 | Read more...

PowerShell for BizTalk Server

http://psbiztalk.codeplex.com/

Naming convention

http://www.traceofthought.net/misc/BizTalk%20Naming%20Conventions.htm

BizTalk Cop (check convention name rules)

A set of FxCop rules for enforcing coding standards on BizTalk projects. First release includes configurable naming rules based on Scott Colestock's published conventions.
http://biztalkcop.codeplex.com/

BizTalk Performance Benchmark

Project Description
The BizTalk Benchmark Wizard is a simple tool to validate a BizTalk installation, making sure it performs as could be expected.

The purpose of this tool is to verify your BizTalk environment performs as expected. The typical use-case where you would use the BizTalk Benchmark Wizard would be after BizTalk Server is installed and before deploying any solutions to the environment.

BizTalk Benchmark Wizard performs load to BizTalk Server in relation to specific scenarios. During the execution of the test, counter information is collected and benchmarked against collected statistics relevant to your BizTalk Server environment
http://bbw.codeplex.com/

Tags: cop | performance | BizTalk naming convention | powershell

Hits: 972 | Read more...

Biztalk Server tips 

http://msdn.microsoft.com/en-us/magazine/cc163423.aspx#S5

SCOM 2007 PACK 4 Biztalk Server

http://www.microsoft.com/downloads/details.aspx?FamilyID=389fcb89-f4cf-46d7-bc6e-57830d234f91&DisplayLang=en

Post Build Event in Visual Studio to GAC the assembly

"$(DevEnvDir)..\..\SDK\v2.0\Bin\GacUtil.exe" /i "$(TargetPath)" /f

Tags: soap | tips | monitoring | BizTalk

Hits: 6947 | Read more...

Tags: Microsoft | Polling | function | Oracle | OracleESB | OracleDB | LOB | WCF | OAQ | BizTalk | Oracle Advanced Queuing

Hits: 2118 | Read more...

Une erreur étrange que j'ai eu sur mon chemin.

Je me suis arraché la tête pendant plusieurs heures, maintenant avec l'article peut être que je pourrais trouver la solution

Affaire à suivre...

Tags:

Hits: 2027 | Read more...

How to List all tables that don't have clustered index

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
      AND TABLE_NAME NOT IN
            (SELECT OBJECT_NAME(id)
             FROM sysindexes
             WHERE indid = 1)

How to visualize the unused space for heap tables (with no clustered index)

Tags:

Hits: 1392 | Read more...

Clustered Index versus Heap Tables: here 

General Performance consideration : here

Database optimisation  : here

Tags: Custered | Index | Heap | Tables

Hits: 1699 | Read more...

Have you ever had a table that kep growing, while the performaces kept degrading, the first nice idea  would be to define indexes, fair enough, but as the table continues to grow so does the indexes, and still the indexes might not be sufficient. So what do you do? buy a more powerful server? 

Well this is an extreme solution, before just try to partition your huge table (well what is huge? above 10Gb is already huge in my case)

Partitionning is equivalent to create as many smaller objects as your partition boundaries

Tags: transfer | existing table | SQL Server | Partition | Table | schema | function

Hits: 8461 | Read more...

How do we use Business Data Catalog?

Well to keep it very simple, you have an example file below that you need to download or to rewrite. The file contains a basic query to the AdventureWorks database. However you need to change some variables in order to adapt the file to your context (change all the "my" starting  word thing)

Then go to Sharepoint Central Administration, in the left menu, click on SharedServices1, then click on the Import application definition. Choose your file location, then for the moment leave the other options as they are. 

And here you are done, the BDC is imported, and you could youse it in any BDC Web Part

Tags: Definition file | Catalog | Data | Business | Sharepoint | BDC

Hits: 5350 | Read more...

I found an interesting article in the internet that responds to the question :

Why the hell my Filtered view in the document library in Sharepoint doesn't filter when I specify Approved, or Complete, or whatever.

In fact the solution is simple : 

Tags: Workflow | View | Sharepoint | Filter | Status | Approved | Rejected | In Progress

Hits: 2327 | Read more...

An error occurred that requires the BizTalk service to terminate. The most common causes are the following:
 1) An unexpected out of memory error.
 OR
 2) An inability to connect or a loss of connectivity to one of the BizTalk databases.
 The service will shutdown and auto-restart in 1 minute. If the problematic database remains unavailable, this cycle will repeat.

 Error message: Exception has been thrown by the target of an  invocation.
 Error source: mscorlib

 BizTalk host name: BizTalkPricingApplication
 Windows service name: BTSSvc$BizTalkPricingApplication

Tags:

Hits: 1552 | Read more...

I am trying to configure  Microsoft SAP Adapter 2.0.

I created send and receive ports as for documentation, RFC programs
also running at receive location folder,when i started buldingIdoc XSD
from SAP Adapter Wizard i am getting error:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FileNotFoundException: File or assembly name SAP.Connector,or one of
its dependencies, was not found
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I have to generate Idoc XSD from SAP Adapter.

The Microsoft SAP Adapter V2 works with the SAP .NET Connector V1.0.3.

If you have V2 of the .NET Connector then you get the error you have seen. Try removing the V2 .NET connector and replacing with 1.0.3.The results you get seem to vary with the installations that have beeninstalled. Some folks report success with the .NET Connector V2

Tags: SAP | BizTalk | Adapter | Connection | IDoc | schema | Generation

Hits: 6875 | Read more...

I already experienced several times the error : "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" Could any one explain to me to what this is related?

This time there was no impact, but it could have in the future?

For information purposes only, we found what was going wrong.

The BizTalk Server is not the same as the SQL Server A user belonging to the Active Directory was used by BizTalk Server to access SQL Server

Tags: user null | Error | Connection | BizTalk | Active Directory | SQL Server

Hits: 10453 | Read more...

We are trying to connect BizTalk 2006 R2 to Sharepoint 2007, What are the rights the BizTalk User should have (within Sharepoint) in order to retrieve and save documents to Sharepoint? I guess Site Owner is
too much

To Save: Contribution Rights Also the BizTalk user must be part of the SharePoint Enables Host group on the SharePoint Server. 

Tags: Sharepoint Enables Host | Contributor | Minimum | Rights | Sharepoint | BizTalk

Hits: 10417 | Read more...

I'm trying to use enable routing for failed messages, I specify my send port with a filter on the existence of a failure code (everything is ok till here, the failed messages are correctly routed)

Then I add a filter on errors that come specifically from a receive port. And here nothing, the message is not routed and this acts as if no routing existed, when I see the context of the failed message the receive port is a promoted property !

If you look closely at your suspended Error Message (The non-resumable instance), you will see that the regular ReceivePortName (BTS.) is marked "Not Promoted", whereas the ErrorReport.ReceivePortName is. So you need to change your subscription to:
ErrorReport.ErrorType exits AND
ErrorReport.ReceivePortName = WHATEVER 

Tags: Routing | failed messages | BizTalk | Receive | Port | Error | schema

Hits: 10332 | Read more...

I installed MOSS 2007 on my virtual PC. locally everything works find by using and typing the http://myserver/

However, when I try to access my virtual PC from the outside http://myipaddress:myport/ (which points to my VPC), every thing works fine except :

When I click on Documents (top bar), I see the http://myipaddress:myport/Docs  (on the task bar of ie), however the http gets redirected to http://myserver which of course doesn't exist in the outside of home network

This is wired, does MOSS have a hardcoded http addresses (including the name of the server) or does it work exclusively on relative http addresses?

Next when I click on site specifications of document, I could see that they are on http://myIPAddress/Documents/Forms/AllItems.aspx however I can see no myport specification

Tags: Virtual | map ip | external access | MOSS | url | Alternate access | Sharepoint

Hits: 5374 | Read more...

Some weeks ago I was faced with a problem, as entry, I had a flatfile schema with positional fields. Before processing this file I needed to validate that every field is ok.

I had a problem with dates, since if I received let's say 10 space characters (representing and empty date) then the schema was not valid. So how the hell could we have resolved the problem? How could we say to BizTalk that for space characters on the Date it is ok, and it should go forward?

Here we needed BizTalk Server to stop processing any wrong file, we did not want BizTalk to continue any further. 

Every solution must be on the schema, solutions in other parts of BizTalk (mapping, custom pipeline, orchestration, ...etc.) was not a state of the art solution.

So What I did was simple :

• In the schema you specify that the padding character is spaces

• you specify that the empty fields are authorized

Tags: schema | BizTalk | flatfile | mapping | orchestration | custom pipeline | dates | empty data | padding

Hits: 11654 | Read more...