Hi all,
Is it possible to connect to an IBM Redbrick Database via Data Sources in AS 2005? I can't get to ODBC's and don't see an OLE driver.
Thanks in advance,
Mark
You must have a driver AND a cartridge that will work with Redbrick. The driver is pretty straightforward. The cartridge is an XSLT file that translates an internally generated XML-based query into a valid SQL statement for submission to the source system. On my system, the cartidges are available at:
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\Cartridges
If a cartridge is not available for your specific system (which is the case for Redbrick), SSAS attempts to use the sql2000.xsl cartridge. This might work for you, but I'm not certain.
Another optoin for you is to create a set of views in SQL Server that use the OPENROWSET function to establish the connection to Redbrick for you. You might be able to then expose those views to SSAS and since SSAS has cartridges for SQL Server this might work out.
Good luck,
Bryan
|||Thanks for the suggestions/guidance Bryan.
I appreciate the help.
