Login, change your address, subscribe to new or manage current magazines or e-newsletter subscriptions
ComputerWorldNetwork WorldCIO CanadaCIO Canada Governments' ReviewJobUniverse Canada
Advanced Search
Knowledge Centres
Content Types
Featured White Papers
Unlock the potential of data with the right data warehouse solutionUnlock the potential of data with the right data warehouse solution read more
IBM Multiform Master Data Management: The evolution of MDM applicationsIBM Multiform Master Data Management: The evolution of MDM applications read more
Closing the data privacy gap: Protecting sensitive data in non-production environmentsClosing the data privacy gap: Protecting sensitive data in non-production environments read more
Yuk it Up
Act to Amend the Copyright Act
Want a copyright law that protects spyware and virus writers? If not, sign our petition to amend Bill C-61
Featured IT Quiz
IT Quiz: Test yourself to see if you have the knowledge to fit into the open source world, and compare yourself with the rest of the respondents
Featured White Papers
This white paper details Intel's current and future energy-saving initiatives to reduce costs and support business goals. Learn how Intel IT is extending its efforts to be a role model enterprise IT organization by supporting the Climate Savers Computing Initiative, which aims to drive a 50 percent reduction in computer-related CO2 emissions worldwide. No registration required.
Sign-Up for
Information Architecture
eNewsletter Delivered Weekly
Click here
Page 1 of 1

Motorbike distributor uses SharePoint for BI

Deeley Harley Davidson Canada recently upgraded to JD Edwards EnterpriseOne, and is combining business intelligence from Cognos software with the collaboration features of Microsoft SharePoint 2007. What the company plans to do next

A Canadian motorcycle distributor is using Microsoft Corp.’s SharePoint software to help its employees collaborate on projects instead of relying on chains of e-mails with attachments.

“E-mail is a very inefficient when it comes to sharing documents,” said Graham Hunter, IT manager for Deeley Harley Davidson Canada, a Concord, Ont.-based firm that sells motorcycles in Canada for Harley Davidson Inc.

More SharePoint news from ComputerWorld Canada

Vancouver firm tackles SharePoint pain points

The company has hired Vancouver-based Habanero Consulting Group to create a corporate portal using SharePoint 2007. A major advantage of the software is its ability to integrate with other software packages from Microsoft, Hunter said.

Along with the portal, Deeley also started a pilot project that would combine business intelligence from Cognos software and the collaboration capabilities of SharePoint. The goal was to help business executives get a better understanding of underperforming projects and figure out what effect, if any, a promotional program had on sales.

“The name of the game is to get as much information as we can into our systems,” he said. “We see Cognos as being our conduit between enterprise systems and SharePoint.”

For its enterprise resource planning (ERP), Deeley uses Oracle Corp.’s JD Edwards EnterpriseOne software, running on IBM iSeries servers. The Cognos business intelligence software uses data from a Microsoft SQL Server database, Graham said.

Habanero helped them complete the migration to EnterpriseOne in April, and a major focus was on presenting the data in different ways to different workers, said Carol Villeneuve, a senior consultant with Habanero Consulting.

“You don’t want to give access to JD Edwards to every single person in your company, but that data’s really valuable, so we’re talking about different ways to service that data,” she said. “There’s lots of ways to getting the SharePoint site to retrieve data from other enterprise systems and display it.”

The entire project was “not a huge investment,” Hunter said, with hardware and licensing costs coming in between $150,000 and $200,000.

Next year, the company plans to connect the ERP system directly to SharePoint, without filtering the information through the Cognos software, and allow employees to view financial information at the account level.

“The beauty of SharePoint is you can apply security right down to the document level so that only the people who should see a particular document have rights to do it,” Villeneuve said. “We have the really senior people and they’re going to be allowed to see the financial stuff. Then there’s information that should be shared with every group in the company. Maybe it’s HR forms.”

Deeley has its own SharePoint developer team, so a major focus for the consultant was to teach them how to train non-tech workers.

“Typically we train the trainer,” Villeneuve said. “The internal training team then trains content authors to load the content in.” This way, she added, the people who use the content are making decisions as to what gets migrated to SharePoint.

Page 1 of 1
Send to a Friend  Rate This Page  Print This PageAdd a new comment
Bookmark this article on:
del.icio.us| Digg it| Furl| Google| Technorati| StumbleIt| Yahoo!

Have something to say about this article? Add a new comment

If you find a comment inappropriate, You can notify the moderator by clicking the Report an innapropriate comment icon.
ADD A COMMENT
Name:*Your email address will not appear online and will be used only in the event that the editor wishes to contact you personally for additional comment.
City:
Email:
Title:*
Comment:*
* required fields



Related Content
Articles

Special Advertising Partners
IDC Case Study: Identity And Access Management Buying Criteria.
IDC analyses IAM buying criteria and deployment at Coppin State University. Coppin State replaces "first generation" IAM solution to obtain benefits needed for today's agile enterprise: ease of integration, rapid deployment, simplified compliance, flexibility.
White Papers
Closing the data privacy gap: Protecting sensitive data in non-production environments
How can IT organizations protect sensitive data, including employee and customer information, as well as corporate confidential data and intellectual property? Industry analysts recommend "de-identifying" or masking data as a best practice for protecting privacy. This white paper explains the importance of closing the data privacy gap in non-production environments, and provides guidance on effective data masking. Complimentary with registration. Sponsored by IBM.
Unlock the potential of data with the right data warehouse solution
Once you've made the decision to implement a new data warehouse, you want to make sure you choose the one that's right for your organization. This buyer's guide provides checklists for starting points that you can use when evaluating vendors and their products. Complimentary with registration. Sponsored by IBM.
Prepare for a more efficient SAP implementation: Take data issues off the critical path
This white paper outlines how the Preliminary Data Assessment Appliance (PDAA) from IBM can help address the challenges of integrating data from different operational applications across the enterprise to an SAP platform. Complimentary with registration. Sponsored by IBM.