| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-10-23 : 12:19:13
|
| Let's say, my database named MLIVE. Currently, all Read, Insert, Delete and Update hit the MLIVE.I'm gonna to implement Business Intelligent ("BI"). My planning is BI will hit another DB named MLIVE2. It's mean, after BI implemented, there's 2 Database named MLIVE and MLIVE2.MLIVE will do all read, Insert, Delete and Update.MLIVE2 will do just Read, and only hit by the BI.My question is,1. It's my steps is a correct practice? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-10-23 : 22:19:21
|
| Sir,What's a significant different to setup1. Transactional Replication2. SQL Server Analysis Services |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-10-24 : 09:53:25
|
| If i wanna to setup OLAP? Did Analysis Services the right tools? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-24 : 12:39:18
|
quote:
Originally posted by wkm1925
If i wanna to setup OLAP? Did Analysis Services the right tools?
Well there are lot of other tools to like Informatica,Oracle BI commonly known as OBIEE or IBM InfoSphere etc.If you are gonna build a BI on a SQL server database then Microsoft analysis server is the way to go.PBUH |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-24 : 14:56:04
|
quote:
Originally posted by tkizer
My company is mostly an Oracle shop although we have a couple thousand SQL Servers.
Wow..Couple of thousand servers  and still you get time to post on sqlteam....PBUH |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-10-24 : 21:05:03
|
| tq sir. all answer is my inspiration |
|
|
|
|
Need an advice to implement Database for BI