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

Which DataSource for Azure Database?

5 Answers 301 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
J
Top achievements
Rank 2
J asked on 06 Sep 2016, 02:35 AM

Which is the correct DataSource to use for an Azure Database, SQL Data Source?

Documentation here doesn't seem to mentioned Azure Databases at all:

http://docs.telerik.com/reporting/quick-start-create-simple-report

5 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 07 Sep 2016, 09:26 AM
Hello Jon,

In general, there is a reporting SqlDataSource component that operates as follows:
  1. The developer configures what .NET data provider to be used, it must be suitable for reading data from the desired data storage. It is recommended to use an official .NET provider for the selected data storage;
  2. The developer provides a connection string giving access to the data storage;
  3. The developer provides a SQL query which results can be used in a Telerik Report.

    At run-time the SqlDataSource uses the specified .NET data provider (SqlDataSource.ProviderName, where the provider must be specified in the connection string as well) and its associated ADO.NET classes (information obtained through the data provider's assemblies) to create a connection and command objects, including the information from the SqlDataSource.ConnectionString and SqlDataSource.SelectCommand.
    Connection strings are read from the running application's CONFIG file (XML, not JSON).


Please elaborate on the data storage you use for your application - Choose a cloud SQL Server option: Azure SQL (PaaS) Database or SQL Server on Azure VMs (IaaS)  and Use of SQL Azure In Visual Studio 2015 Step By Step Guide (both links lead to external resources).

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
J
Top achievements
Rank 2
answered on 08 Sep 2016, 01:24 AM
In the Telerik wizard do I select 'SQL Data Source' to connect to an Azure Database, yes or no? If no, what do I select?
0
Stef
Telerik team
answered on 08 Sep 2016, 09:27 AM
Hello Jon,

If it is a SQL database that can be accessed via .NET data provider and a connection string, the answer is SqlDataSource component.

Still the question is not clear and thus there is no direct answer to it. We need details about your settings in order to suggest you the proper data source components. In general, we provide data source components and means for connecting to any data, which may or may not include additional code, depending on the settings.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
J
Top achievements
Rank 2
answered on 09 Sep 2016, 12:19 AM

I can see that it would not be clear if you didn't know what an Azure SQL database was. Maybe you should do some reading to catch up on what Telerik Marketing is selling. Here are some pointers for you:

https://azure.microsoft.com/en-us/services/sql-database/

https://en.wikipedia.org/wiki/SQL_Azure

Since Telerik Reporting is supposed to support Azure, what is the recommended DataSource to use in the wizard when connecting to a SQL Azure database?

0
Stef
Telerik team
answered on 09 Sep 2016, 05:33 PM
Hi Jon,

I am not familiar with Azure SQL databases and there is no recommended data source component. The data source components you will use have to be considered with your requirements and implemented data access.

Having into account the provided Wiki article - https://en.wikipedia.org/wiki/SQL_Azure, and https://en.wikipedia.org/wiki/WCF_Data_Services and https://azure.microsoft.com/en-us/documentation/articles/web-sites-dotnet-deploy-aspnet-mvc-app-membership-oauth-sql-database/, you can use the ObjectDataSource component (this is the most general one).

This allows you to implement custom data access layer, in which you can create the context and execute methods to fetch data. How the ObjectDataSource works: In general, the purpose of the ObjectDataSource component is to provide data to the report in a declarative manner. The ObjectDataSource.DataSource should be the assembly qualified name or Type of the data access layer (class), where the reporting engine will use System.Reflection to create the instance of the class (by using its default constructor) and to execute its method specified by the ObjectDataSource.DataMember property.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
J
Top achievements
Rank 2
Answers by
Stef
Telerik team
J
Top achievements
Rank 2
Share this question
or