Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 5.x > Portal Engine > Ultimate solution for integrating external data

View modes:

Member

fadishei-yahoo - 9/2/2010 10:08:38 AM

Ultimate solution for integrating external data

Hello

I have an existing movie database. I want to show movie information in a Kentico-powered web site. In spite of the documentations, I am not sure what the best approach is. For example I do not know whether I should implement a custom data source, or should I write a custom ASCX, or should I create a custom document type.

Nevertheless I have some requirements:
1- I need to show movies in lists and details
2- I want to be able to use the built-in comments and rating for movies. Users should be able to rate and comment under individual movies
3- I want to use server-side paging (i.e. using ROW_NUMBER style SQL queries) for the sake of performance when showing paged movie list

I know the comprehensive solution can be too long to come in a forum, but I just need to hear the correct direction to follow from Kentico experts.

Thanks in advance

Kentico Support

kentico_jurajo - 9/20/2010 7:47:05 AM

RE:Ultimate solution for integrating external data

Hi,

For 1 and 3 you can use repeater/datalist with custom SQL queries - so you can build custom query and get data from custom database. However in 2 if you want to use built-in comments and rating modules, you have to create documents in the content tree for each item - in other words it is like import all the movies into Kentico CMS and create document for each.

Otherwise, you need to create fully custom module which will store the comment and rating in some DB table related to the movies database.

Best regards,
Juraj Ondrus

Top