Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Database: Changing the CMS database or retrieving data from external sources View modes: 
User avatar
Member
Member
justin_tighe-hotmail - 7/1/2009 6:39:54 PM
   
Database: Changing the CMS database or retrieving data from external sources
Is it possible to amend the CMS database by adding my own schema to the database and then display the data in the portal? Can I retrieve and update data from external databases to display in the portal?

Are there any examples, what is the best practice?

User avatar
Kentico Developer
Kentico Developer
kentico_ondrejv - 7/6/2009 8:11:15 AM
   
RE:Database: Changing the CMS database or retrieving data from external sources
Hello,

It's possible to create additional tables. You can use 'Custom tables' feature: http://devnet.kentico.com/docs/devguide/managing_custom_tables.htm. You will display the data using standard controls.

Regarding external database - it's possible to display data from external database. It depends what approach you use - if you develop your site using Portal engine please see following article: http://devnet.kentico.com/docs/devguide/displaying_data_from_external_database_or_web_service.htm.
Whether you have ASPX templates please see following: http://devnet.kentico.com/docs/devguide/displaying_data_from_external_database.htm

Best regards
Ondrej Vasil

User avatar
Member
Member
sonic4ss-gmail - 8/26/2013 7:36:21 AM
   
RE:Database: Changing the CMS database or retrieving data from external sources
the first link looks great

http://devnet.kentico.com/docs/devguide/displaying_data_from_external_database_or_web_service.htm.

but there is something missing here i need
there is a problem when opening WebProject.sln in visual studio as i tried because the wep pages already working from virtual paths

so, How can it work through these steps to open it in visual studio ?

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 8/26/2013 6:33:51 PM
   
RE:Database: Changing the CMS database or retrieving data from external sources
Hello,

Could you please tell us which version of Kentico are you actually running?

Best Regards,
Martin Danko

User avatar
Member
Member
sonic4ss-gmail - 9/25/2013 8:48:35 AM
   
RE:Database: Changing the CMS database or retrieving data from external sources
right now since this Quote belong to 2009 and now we are 2013 i'm using
Kentico CMS 7.0 and Visual Studio 2012,
and i' try to open Kentico project as (exist web site) from IIS in VS 2012
so i can change the ConnectionString but i failed :(

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 9/26/2013 2:23:19 AM
   
RE:Database: Changing the CMS database or retrieving data from external sources
Hello,

Next time, please open a new thread under version 7 forum, version 4 is not supported anymore.

What exactly is the problem in your case? The connection string is stored in the web.config file and you can edit this file in any text editor and change the connection string without opening the project.

Best regards,
Martin Danko