ODBC Driver and Canary Historian

Hi, all! I'm currently building a report to pull information from Canary Historian, and am running into some issues which I believe may be driver based. 
A bit of background: I'm using BDPro v11.0.3 and the driver for the data source is sun.jdbc.odbc.JdbcOdbcDriver. I know from reading other posts in the forums that this is not the 'correct' driver to be using as it is only a stop-gap that Sun put out for temporary use. The report runs, but will only spit out sevens days' worth of data not matter what time span I use over seven.
I've run the query in QTODBC with no issues at all when searching 30 days of results. If I look at the driver info there, it says the name is CanaryODBCClientDriver from Simba Technologies, Inc., and the file name is CANARYODBCCLIENT.DLL. 
I guess my question is: Is there a way for me to utilize that driver in BDPro to possibly alleviate the date range issues?
 
Have a great day!
 
Thanks,
Scott

Find more posts tagged with

Comments

jfranken

Hi Scott,
 
The drivers typically go in the \eclipse\plugins\org.eclipse.birt.report.data...\drivers folder. I know nothing about the Canary driver so I can't tell you if that will work or not. 
 
In terms of modifying the query for the driver that only returns a weeks worth of data, I can't think of a simple solution. My first thought was to do something with a scripted Data Set, but there's a good chance you'll run into the same driver limitation.