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 |
|
MrNorth27
Starting Member
2 Posts |
 Posted - 2007-06-26 : 09:51:43
|
| Hi!I have a task on my table, and Im not really sure how to do this in MS SQL 2005.The customer wants to import data from an oracle db to a sql server 2005, this is easy. Then the customer want me to allow them to implement a few business models on top of this data... and allow them to run various simulations. The data is financial, so they already have some financial business model they want to implement in MS SQL Server 2005.Is there some sort of service in SS 2005? I was thinking about reporting and analyzis services, but I have never worked with those before... would they solve the puzzle for me? One keyword in the request was "interative simulation"... they want to be able to play with the data and to see what changes to certain constants in the model produce the best output...When all this is done, they want to push this data back into Oracle.To me this sounds like Data mining and business intelligence using OLAP cubes etc. Or what do you think? Is there an easy way to do this in SS 2005? Any suggestions is helpfulkind regardsHenrik |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-06-26 : 10:03:45
|
| SQL 2005 is just a database engine; sounds like you need a user interface and things like that. MS Access can be very good at this, and I know cognos (http://www.cognos.com/ ) has tools that let you do this as well. SQL Server Reporting Services and Crystal Reports will let you output reports, but they won't let you do interactive data modeling.It depends on your specific needs. I've done lots of projects like this, and I have found MS Access to be a very powerful tool, but you must very familiar with it to use it well and to not end up making a big, inefficient mess.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
MrNorth27
Starting Member
2 Posts |
Posted - 2007-06-26 : 16:08:36
|
| Hi!Yeah the things you are writing about are exactly my thougts. We had a big project using cognos, and then we hired experts for that, and I was only responsible for setting up the Oracle database. The tricky part is that this assignment was haded over directly to me, even though I have no record of working with data analysis and simulations. I need to have a talk with both my boss and the customer, to try and find out exactly what it is they want.Its a piece of cake for me to implement a set of views or procedures that can handle this logic, and then build an asp.net mockup interface that allow them to enter some values and see what happens with the key values and underlying data (calling the procedures). I wonder if they are really sure about what they want... and if Im the right guy for this.SQL Server 2005 has so many new exciting features, I wish I could learn them all (reporting, replication, integration, analysis).Thanks for the input, I will quote your words when talking to my boss...kind regardsHenrik |
|
|
|
|
|
|
|
|
Data analysis in SQL 2005?