Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
faivre
Starting Member
1 Post |
 Posted - 2009-05-28 : 16:54:59
|
| Hello,I am looking for some direction on how to handle the following situation our company is facing. We have three SQL databases that reside on three different servers. Two of these databases collect process control information. The other database collects pertinent information that is not generated from our control systems. All three databases are SQL Server 2005. It is possible that we will be looking to incorporate information from other databases and data sources (flat files, spreadsheets, etc.). I need to be able to combine this information for reporting. Can someone please point me in a starting direction using the SQL Server architecture? Should I be looking into SSIS or SSAS?Thank you,Brian Faivre |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-05-28 : 17:12:05
|
| From what you have posted sounds like you can approach this with a Data Warehouse or Data Mart strategy. That would be extracting, parsing and storing all information germaine to the reporting needs. You could use SSIS to gather the data.A classic scenario, that you can take one step further and develop a business intelligence system on the data mart using ssas at some point in time.Talk sense to a fool and he calls you foolish. |
 |
|
|
|
|
|
Access multiple databases for reporting