Need help getting data from Red Brick to SQL Server

  • Hi

    I work for a company that is one of several owned by a larger company.  We are trying to get some data from a sister company's Red Brick db into our SQL Server db.  Unfortunately my company doesn't own Red Brick.  Any ideas?

    Thanks

  • As a start point try Googling for:

    red brick odbc

  • You might also want to try here:

    http://publib.boulder.ibm.com/infocenter/rbhelp/v6r3/index.jsp?topic=/com.ibm.redbrick.doc6.3/ciacg/ciacg26.htm

     

    ... if you have a choice between different ODBC drivers available for redbrick, do some serious testing, especially if it's not just a one-time import. 

    I'm sure the drivers have changed since I used them several years ago, but we found there were some unusual optimizations in the driver we were using.  Like, it performed really well with an IN list of 40000 items, and not so well using some join-based approaches that you would normally use to handle the same type of problem.

    >L<

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply