Archive for February, 2009
Currently in rampup SAPís supply network collaboration solution promises to deliver smooth integration possibilities with all parties in a supply chain. Whether youíre a supplier (subcontractor, 3PL, outsourced manufacturer) or customer, SNC offers you various connection options.
When using remote server connections in MSSQL they need to be in the format select * from [ServerName].[DatabaseName].[SchemaName].[TableName]. If you want to switch between two servers (say Production and Test) you only need to recreate the LinkedServer. The problem arises when the database and or schema name on the linked server is different. [ProductionData].[Pub] -> [TestData].[dbo]. This change would mean that you have to change every query which reference to the linked server.
A solution is using Synonyms instead. This means that you can use select * from [SynonymSchemaName].[Synonym] instead. The big advantage is that you can script the creating of synonyms, so a database connection switch can be done in seconds rather then hours.No comments
Om COGNOS 8.4 te laten connecten met een SSAS cube. moet je een aantal zaken regelen. Begin met het in stalleren van SQL Server 2005 SP3 op de Cognos server.
Hierbij werd de SQL Native Client bijgewerkt alsmede de MSXML 6.0 installatie welke een prerequisite is voor de SSAS OLE DB 9.0 driver waarmee naar de cubes geconnect wordt.
One of the powerful features of OBIEE is the possibility of federated query’s. Sadly in most sales pitches we tend to emphases the technical part instead of the practical part. Every now and then there is a BI-manager in the audience who really knows his stuff and starts asking the wright/wrong questions. In this article I want to show you some of the pitfalls when trying to "sell" federated query’s.