Forums (Obsolete)

Member

bsatish417-gmail - 5/27/2011 1:08:30 PM

Integrate with external Database

Hi ,

We have an external database which has 100's of tables in it.

We are looking forward to create some pages which fetch the data from the external database , but they need to be integrated in to the kentico portal .

Is there a way we can use Kentico libraries to call the external databases & fetch the data

or do we need to come up with Our own architecture to fetch the data ?

Also how do we have authorisation & authentication on those new pages ?

Thanks
Satish


Member	lancetek - 5/27/2011 1:23:17 PM RE:Integrate with external Database Kentico doesn't natively support external databases : oracle db example But since you have access to ASP .NET there's no reason you couldn't support/import/use any database you want to. For example it's really super-easy to create custom functions in Kentico : Custom functions rock! Good luck!


Member	bsatish417-gmail - 5/27/2011 1:35:27 PM RE:Integrate with external Database Thanks for the information. Btw the external database is Sql server database only :) Let me give a try & get back to you Thanks Satish


Member	bsatish417-gmail - 5/27/2011 1:39:50 PM RE:Integrate with external Database Btw the requirement is not to import the data using sql import to kentico CMS database They want to keep the external database as it is & use the database from kentico portal ? Does kentico support that ? What about authentication & authorization to different pages that access external database ? Thanks Satish


Member	lancetek - 5/27/2011 2:10:21 PM RE:Integrate with external Database I don't know your project, but I'm sort of assuming that you'd use Kentico as the client-facing website, and inside Kentico pull in data to display from the other database. Then you just have to worry about user authentication/auth in Kentico.


Member	lancetek - 5/27/2011 2:14:10 PM RE:Integrate with external Database Keep in mind that Kentico is very flexible... and that it's a 'standard' ASP.NET application / project. So pretty much anything you could do in ASP.NET you can do inside/beside/with Kentico!


Member	lancetek - 5/27/2011 2:07:50 PM RE:Integrate with external Database Sorry! By 'external' I took that to mean 'non-sql server'...


Member	bsatish417-gmail - 5/27/2011 3:55:32 PM RE:Integrate with external Database I tried to look in to the kentico code , but no where i could see where the CMSContext.CurrentUser is set. I want to add custom logic at login to set a flag CMSContext.CurrentUser.is_dealer = true or false based on if the login is done by dealer or user where can i do that ?


Member	lancetek - 5/28/2011 1:50:31 PM RE:Integrate with external Database Instead of that, why not just add a new property to the user object 'isDealer' and look it up at runtime using the CMSContext.CurrentUser["isDealer"]? Lance


Member	sonic4ss-gmail - 9/16/2013 4:30:39 AM RE:Integrate with external Database because i have the same Problem i think i choose to convert MySQL DB to SQL Server DB Is there is a way in V7.0 or still i can't integrate external DB for just View