This is a migrated thread and some comments may be shown as answers.

Write a report with 2 different data base connections?

1 Answer 89 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Garth
Top achievements
Rank 1
Garth asked on 19 Jul 2009, 07:49 PM
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.

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 22 Jul 2009, 02:02 PM
Hello Garth,

Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists - for more information on report data binding, please, refer to this help topic). In this line of thoughts, it is neither aware nor does it matter to it how/where the data comes from. It is up to the developer to prepare the data in a convenient way (having in mind the supported datasources) and bind the report to it.
Telerik Reporting can be bound to a single table only. If you need data from others you can use create multiple reports and use the SubReport item, or take advantage of the table item which acts as "separate data region".
"is there a fuctional work around with OpenAccess to combine tables from separate sources into a single data":
This is not possible as well - the datasource works with a single table only. What Open Access can do is
help you create classes from all the tables/databases, but if you want to combine the data from the different tables, you would have to do it manually e.g. in new objects.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
General Discussions
Asked by
Garth
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or