Hiya Folks,
I'm evaluating the Telerik products.
I have a requirement to write a report that (concurrently) uses data from BOTH an ODBC MySQL Database Connection AND a MS SQL Database.
Will Telerik's Report Writer support this requirement?
The ODBC MySQL uses the MySQL 3.51 ODBC client and is read only using Views. The MS SQL is current 2008. VS 2008 and .NET 3.5 is the development environment. I'd like to wrap the reports in a SL 3 app (yes, I saw the recent TK example on how to do this - very nice).
If so, is there an example that demonstrates this?
If the Report Writer doesn't support multiple data sources on a single report, is there a fuctional work around with OpenAccess to combine tables from separate sources into a single data connection/source? If so, I'll follow through with a post in the ORM forum.
FYI: My last resort would be to create a data warehouse for the MySQL data in MS SQL - I would like to avoid having to do that.
I'm always open to alternate solutions.
Thanks,
Garth
*********** Later Update *********
I am looking into ORM example:
http://www.telerik.com/ClientsFiles/112754_classlibraries.zip
to access multiple databases.
I would appreciate hearing from experienced users or TK on best practices in creating multi-database applications.
I'm evaluating the Telerik products.
I have a requirement to write a report that (concurrently) uses data from BOTH an ODBC MySQL Database Connection AND a MS SQL Database.
Will Telerik's Report Writer support this requirement?
The ODBC MySQL uses the MySQL 3.51 ODBC client and is read only using Views. The MS SQL is current 2008. VS 2008 and .NET 3.5 is the development environment. I'd like to wrap the reports in a SL 3 app (yes, I saw the recent TK example on how to do this - very nice).
If so, is there an example that demonstrates this?
If the Report Writer doesn't support multiple data sources on a single report, is there a fuctional work around with OpenAccess to combine tables from separate sources into a single data connection/source? If so, I'll follow through with a post in the ORM forum.
FYI: My last resort would be to create a data warehouse for the MySQL data in MS SQL - I would like to avoid having to do that.
I'm always open to alternate solutions.
Thanks,
Garth
*********** Later Update *********
I am looking into ORM example:
http://www.telerik.com/ClientsFiles/112754_classlibraries.zip
to access multiple databases.
I would appreciate hearing from experienced users or TK on best practices in creating multi-database applications.