I work in an environment (like everyone else) that consists of a production database and a test database. My test environment is an exact image of my production database. What I'd like to do is to create a Crystal Report that works for both environments...if this is possible. Basically, I'd like for my users to be able to run reports in our testing environment without having to re-create all of my Crystals to point towards the test database. Having two sets of each Crystal isn't something that I'd like to do...or maintain.
Basically I'd like to just change the database name dynamically at runtime.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.