All geek questions in one place

Sitecore External Database Integration

Which would be a good way and good practice when “integrating” an external SQL database into a Sitecore project.

The Sitecore project will get most of its content from this external database, which is maintained elsewhere and is constantly updated. (so copying an external database or synchronization is not preferable, and we do not plan to enrich the data either)

Is there any method for defining some objects and pipelines between Sitecore and an external database (say, without using too many web services)

+4
source share
2 answers

What you can do is create a custom data provider to connect to your external SQL database. This way, you can display the external Sitecore data as if it were raw data. See this link and this link for more details.

+7
source

When we implement an architecture like this, we will use a search index (for example, solr) to maintain the state of the external database and store enough content to display the lists.

Then I will ask an external source to display the "article". Sitecore will own the definitions of web applications, URLs, and all pages.

If you want to use DMS, you might want to extend this by adding some elements for element references.

0
source

Source: https://habr.com/ru/post/1486427/

More articles:


All Articles