I'm trying to use SQL Reporting Services to generate some reports from a remote MySQL database. I've installed the MySQL ODBC driver on my machine and can successfully connect. I've also installed and setup SQL reporting services on the same machine. I can successfully see the reporting services webpage located at http://localhost/Reports I'm new to SQL Reporting Services - I believe I need to push a 'Report Model' to my reporting server before I can begin to generate reports? This is the part that I'm having trouble with. How can I create a report model when the data source is a remote MYSQL database? When I try to define a data source in my Report Model project, there doesn't seem to be an option to connect to an MySql server? Can anyone tell me what I'm doing wrong?

hello, a model is mostly used for allowing end users to create reports using the relatively user friendly report builder application. The model allows you to restrict what tables and data the users can query. These reports can then be saved back to the report server for others to use. You can also create reports directly in Visual Studio (BIDS) and deploying them to your report server. This is the typical method a developer would use to create a report. I attempted to use a mysql model a while back and all my researching pointed to that its not entirely feasible. However you can create mysql reports in BIDS using an ODBC data source. For it to work once you deploy it you need to also install the ODBC driver on the report server. Also you should name your mysql odbc connection the same name you specify in your report data source. edit: by infeasible i mean is it may be possible to get create and deploy a model using a mysql ole connection, but you'll likely run into all sorts of problems trying to use it in report builder

hello, a model is mostly used for allowing end users to create reports using the relatively user friendly report builder application. The model allows you to restrict what tables and data the users can query. These reports can then be saved back to the report server for others to use. You can also create reports directly in Visual Studio (BIDS) and deploying them to your report server. This is the typical method a developer would use to create a report. I attempted to use a mysql model a while back and all my researching pointed to that its not entirely feasible. However you can create mysql reports in BIDS using an ODBC data source. For it to work once you deploy it you need to also install the ODBC driver on the report server. Also you should name your mysql odbc connection the same name you specify in your report data source.

You don't need a model to create a report, you can create a datasource and a dataset to consume your MySQL data MySQL is not a supported source for a model, you can check the sources here http://msdn.microsoft.com/en-us/library/ms159219.aspx The models can be created from SQL Server 2008 and later SQL Server 2005 SQL Server 2000 SQL Server 2005 Analysis Services Oracle 9.2.0.3 or later Teradata v13, v12, and v6.2

You don't need a model to create a report, you can create a datasource and a dataset to consume your MySQL data MySQL is not a supported source for a model, you can check the sources here http://msdn.microsoft.com/en-us/library/ms159219.aspx The models can be created from SQL Server 2008 and later SQL Server 2005 SQL Server 2000 SQL Server 2005 Analysis Services Oracle 9.2.0.3 or later Teradata v13, v12, and v6.2 Thanks Jamie - do you have any information on how I can create a DataSet from my MySQL database?

Follow the steps in http://msdn.microsoft.com/en-us/library/dd220525.aspx to create the datasource and this http://msdn.microsoft.com/en-us/library/dd239345.aspx to create the dataset in Report Builder for SQL Server 2008R2