Displaying data from other database Options
Jose Malone
Posted: Thursday, March 13, 2008 8:39:41 PM

Rank: Devotee

Joined: 9/8/2006
Posts: 80
Location: Northern California
I'm trying to wrap my head around this and would appreciate any insight how one would do this.

I basically have a database of 20,000 companies I want to create a listing site for and would like to publish the data dynamically within Umbraco and display the data in various ways. Such as by state, county, business type, etc.

If the data is in the external database I want umbraco to display it, but I still want the ability to manage the templates of the pages the dynamic data is displayed in.

Anyone doing this now?

Thanks.

Jose
neehouse
Posted: Thursday, March 13, 2008 9:18:47 PM
Rank: Umbracoholic

Joined: 7/20/2006
Posts: 1,018
Location: Charleston, West Virginia, United States
You could build xslt libraries to call .NET methods and return the data as xml for the xslt.

It would not be template based, but, it would at least be presentation control in umbraco.



• 2007 - 2008 MVP • Charleston, WV, USA • umbracoholic since Dec. 2004 (v.2.0) •
Achieved umbracoholic status on 2008-04-25
Ig_p118
Posted: Monday, March 31, 2008 10:58:10 AM
Rank: Aficionado

Joined: 7/21/2006
Posts: 155
Location: Italy
or you can use an usercontrol

Red Consulting s.a.s - Umbraco from v1.0
sjors
Posted: Monday, March 31, 2008 1:50:30 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 401
Location: Amsterdam
I think the best way is to creat a SOAP service on your existing application/database, its not too hard from Umbraco to retrieve data from a soapservice, there is already a sample with Umbraco/Flickr. The good thing about creating a soapservice is that you keep stuff seperated, which is never a bad thing i think.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.