Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Multiple Database IntegrationMultiple Database Integration
Previous
 
Next
New Post
3/21/2007 6:40 PM
 
Hans Zassenahaus


www.thevwc.org
Joined: 3/10/2007
Posts: 221

Excuse me for using the forms for this query - I have searched the forum content but have not come up with a response.

I would like to aggregate custom reports from multiple different databases into the DDN portal whilst still retaining all of the capabilities of registration and security provided by the framework.  Basically, I would want to generate custom report pages into the portal by extracting data from these external databases without a URL redirect, such as would be necessary with an interface to Reporting Server.

Is there a way of extending the DAL to encompass multiple databases?  How would one go about this?

Thanks,

Hans

Regards
Hans
 
New Post
3/21/2007 10:10 PM
 
Tom McMurtry

Joined: 11/14/2003
Posts: 55
I use SqlGridSelectedView from http://www.tressleworks.ca/. This is a great module to query dbs.  I use data from 3 different sql servers.  You can define data sources in the web.config file or as part of the module settings.
 
New Post
3/22/2007 8:06 AM
 
Michael Washington


Michael Washington's Avatar

www.LightSwitchHelpWebsite.com
Joined: 7/17/2004
Posts: 3526
Hans38 wrote

is there a way of extending the DAL to encompass multiple databases?  How would one go about this?

see: Connecting to another database


Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
3/22/2007 9:47 AM
 
Hans Zassenahaus


www.thevwc.org
Joined: 3/10/2007
Posts: 221
tommcur - thanks fo ryour replay.  Yest, I saw this software module and have downloaded it for some experimentation.  It appears to be very powerful... the only issue now is getting images, such as with a catalogue.  Still Trying.  Thanks Hans
Regards
Hans
 
New Post
3/22/2007 9:51 AM
 
Hans Zassenahaus


www.thevwc.org
Joined: 3/10/2007
Posts: 221
Michael - Thanks fo ryour reply and reference.  I will experiment with this solution also.  The issue becomes that I need to ensure that the DotNetNuke database is also in play to ensure that we maintain security on some of the features/reports we are planning.  Thanks - I was not fully aware that we could use the MS Enterprise Patterns in conjunction with DDH.  --- Hans
Regards
Hans
 
 Page 1 of 1
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Multiple Database IntegrationMultiple Database Integration


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out