I was planing to use SQL Server Integration Services (SSIS) with SharePoint -- but the folks that set up the customer's environment are not sure that they have all of the services I want to use turned on. And since I get hand slapped when wanting to touch the infrastructure... have to hope for the best and plan for the worst. I do have Embarcadero Studio and anticipate having Sybase Power Designer as well, assuming their purchase order comes through. Nothing like a customer that makes things easy for you... -- I made magic once. Now the sofa is gone. http://blog.dwacon.com http://www.twitter.com/dwacon ________________________________ From: Matt Warden <mwarden at gmail.com> To: "thelist at lists.evolt.org" <thelist at lists.evolt.org> Sent: Thu, January 13, 2011 11:13:00 PM Subject: Re: [thelist] SharePoint to Cognos On Wed, Jan 12, 2011 at 8:38 PM, Dwayne Conyers <dwacon at yahoo.com> wrote: > I have a client who wants to build reports in Cognos using the data in a > SharePoint collection. > > My strategy is to do ETL to move the data into Microsoft SQL Server, which > will feed data to Cognos. I have the Embarcadero suite to do data modeling > and etc... > > Any thoughts on alternatives to that strategy... or lessons learned that > might be useful? I see nothing wrong with your strategy based on the requirements you've laid out. Although, those are rather general requirements. The common belief is that BI is easy. But the stats on BI project failure rate show that it isn't. I say this only to caution you not to underestimate the effort. One thing I don't see in your email is what you're going to to use to "do ETL". You don't necessarily need a tool to do this, by the way. You could simply use views to bend the data as you need it, and then do simple SQL (e.g. insert into targetTable select * from sourceView) to perform the actual move. Whether this is wise depends a lot on details about your scenario that I don't know. Good luck, -- Matt Warden Austin, TX, USA http://mattwarden.com This email proudly and graciously contributes to entropy. -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !