(David Allan) A common query over the years is how to do more dynamic changes at runtime, with the core OWB mappings, a common technique which has been used through the years is to use Oracle database synonyms (see forum entries such as this). This is useful for when you are doing cookie cutter styl
Other News
Using a Sub-Analysis as a Base Filter for Main Analysis Request
(Christian Screen) Stepping away from the back-end of OBI 11g for a minute, I wanted to show one of the features of OBI that has just moved slightly to a different location that where it existed in 10g. Seemingly in OBI 11g there a few features that look to be hidden just by the way the new prompts
SQL SERVER – expressor Studio Includes Powerful Scripting Capabilities
(Pinal Dave) One of the major problems in developing a data integration application is writing transformation code. Many tools try to meet this need by providing a large number of operators that minimize coding through configuration.
Querying external server without adding it as linked server
(Madhivanan) One of the members in the SQL Server forum asked a question about querying the remote server without actually adding it as a Linked Server. One of the options to do this is to make use of the OPENDATASOURCE function.
Highly Available and Scalable Systems with IBM eX5 and DB2 pureScale
(Mike Ebbers and Michael Schulz) The pressures related to managing transactional databases are increasing rapidly. Business growth, the drive to consolidate databases, and the need to deploy new, data-intensive technologies are fostering the massive expansion of data volumes and application workload
SQL Server Database Mirroring: Part 1
(Nipun Tomar) In SQL Server both Log Shipping and Mirroring can work together to provide solutions for high availability and disaster recovery. We can convert an existing log shipping configuration to a database mirroring configuration and also easily switch which pair of instances is using database
Get started developing applications with the IBM Data Server Driver package
(Deepasri Krishnaraja and Arun Kn Purnaiah) The IBM Data Server Driver Package (commonly referred to as the DS Driver) provides runtime support for applications that interact with DB2 and Informix databases through ODBC and DB2 CLI function calls.
Steps to clear the server list in SQL Server Management Studio
(Jugal Shah) Generally we connect to several SQL Server instances. Once connected successfully, this server history is shown in the drop down list as shown below. In some cases we might have similar names for servers as such as using P for production, D for Development, U for UAT and T for Test en
Plan Guides
SelecTViews With Stephen Wynkoop A pet peeve – what is up with the silence about the massive cloud data breach??? Also on the show today – Michael Crump and some great applications for Silverlight. [Watch the Show] $$SWYNK$$ Plan Guides In response to yesterdays tip using sp_execute_SQL I received the following comment from Leif regarding a database configuration that can […]
Why the radio silence with this data breach?
Why the radio silence with this data breach? I’m confused. "The cloud is the answer" to so many things from scalability to security and performance. Sure, it’s not the be-all, end-all, but it is touted as a rational extension to your systems. I get it, and I agree… but I’ve been concerned about security from the get-go. I also think […]