[thelist] SharePoint to Cognos

[Dwayne]

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 !