Which DataSource for Azure Database?

6 posts, 0 answers
  1. Jon
    Jon avatar
    17 posts
    Member since:
    Jul 2013

    Posted 05 Sep Link to this post

    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

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 07 Sep Link to this post

    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
  3. DevCraft banner
  4. Jon
    Jon avatar
    17 posts
    Member since:
    Jul 2013

    Posted 07 Sep in reply to Stef Link to this post

    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?
  5. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 08 Sep Link to this post

    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
  6. Jon
    Jon avatar
    17 posts
    Member since:
    Jul 2013

    Posted 08 Sep in reply to Stef Link to this post

    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?

  7. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 09 Sep Link to this post

    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
Back to Top
DevCraft banner