DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.


Reports Module 5.0 Update – Data Sources part 2: Generic ADO.Net

First off, sorry about the long delay between posts…another semester of university started and I’ve been really busy getting school work done. I may be looking for some help in the next month or so, if anyone is interested in working on the Reports Module with me (I’m going it alone right now).

The main goal of the new Data Sources framework is to be able to support data from any number of varying sources. These sources may be standard relational Databases or they may be other data stores such as Active Directory, Excel, CRM Systems, etc.
In order to be as flexible as possible, the Reports module includes a “Generic ADO.Net Data Source” which allows you to query any data source for which there is an ADO.Net Data Provider.

The .Net Framework includes pre-installed data providers for: OLE DB, ODBC, Microsoft SQL Server (though the Sql Server Data Source is more appropriate in this case), and Oracle. Plus, ADO.Net providers are available for many other data stores such as PostgreSQL, Firebird, and MySQL. Using this Data Source, users can query any of these providers in a generic way.

Eventually, the Reports module will be able to support many of these Data Sources directly, for example it would be fairly straightforward for a third-party developer to create a PostgreSQL Data Source for the Reports module that is customized to work with that particular DBMS. However, until these Data Sources are developed, this generic system allows users to access those data sources right now.

The downside is that since the Data Source knows nothing about the individual data stores, it cannot provide the same advanced features as the custom Data Sources. For example, the Microsoft SQL Server Data Source allows you to create a Connection String by entering data into structured fields like Server, Database, User Name, Password, etc. However, the Generic ADO.Net Provider requires you to create and enter the connection string manually. This is the price that is paid for a generic system, but sites like http://www.connectionstrings.com can make it a bit easier.

Next up is the "User Defined Table Module" Data Source, hopefully I'll get that post up in less time than it took me to get this one up :)

Comments

Comment Form

Only registered users may post comments.

NewsArchives


Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Andy Tryba (1)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (32)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Bogdan Litescu (1)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (209)
Chris Paterra (55)
Clinton Patterson (41)
Cuong Dang (21)
Daniel Bartholomew (2)
Daniel Mettler (154)
Dave Buckner (2)
David Poindexter (4)
David Rodriguez (3)
Dennis Shiao (1)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (10)
George Alatrash (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (274)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Miguel Gatmaytan (3)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (54)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (40)
Will Strohl (165)
William Severance (5)

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out