 |
Clients > Teekay
Project Overview
Teekay had the need to integrate the data of each shipping company's
vessel with the main vessel tracking system and to view results within
SharePoint. Vessel data was transmitted via a satellite link to a well known
location for BizTalk to process.
Project Details
- Architect for overall solution
- Worked with the business to define the requirements
- An Excel custom
pipeline component was created to convert Excel data to XML canonical
data to later be used within an orchestration. As Excel was used as
input, the data was subject to manual errors. Therefore a custom pipeline
component performed the conversion of Excel to XML and a second custom pipeline
component performed the XML validation.
- The XML data was saved to SharePoint via the use of a
custom Web service and the SharePoint API. A summary of this data was emailed
to managers via the SMTP adapter.
- A Scheduled Task Adapter was configured to trigger a
second orchestration to begin processing at specified times of the day.
This second orchestration retrieved a list of contacts from SharePoint
via a custom Web service, looped over this list of contacts and used the
SMTP adapter on a dynamic port to send a summary vessel report. There
was a summary report per company/vessel.
- Maps were used for date/time manipulation with custom
functoids and .NET assemblies. Missing XML fields were replaced with
default fields.
- Promoted properties were used to indicate the
shipping company. An orchestration decision point read this promoted
property and depending upon the shipping company would use a different XSLT style sheet to pass to a .NET assembly to apply the correct
conversion of XML to HTML.
- HAT and the BizTalk administration console were used
for message tracing
- A continuous integration environment was setup
through the use of CruiseControl.NET.
|
|
|
