Learn More





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 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 :)


Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (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 (268)
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)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
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 (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?