CODEWITHSUNDEEP
databasesitecorepipeline
KMN
KMN

Reputation: 306

Sitecore external database integration

What would be a good way, and good practice when "integrating" an external SQL database, in a Sitecore project.

The Sitecore project will get alot of its content from this external database, which is maintained elsewhere, and is constantly updated. (so copying the external database or syncing, is not really prefered, and we dont plan on enriching the data either)

Are there some method of defining some objects and "pipelines" between the Sitecore, and the external database (say without having to use, too many webservices)

Upvotes: 4

Views: 1674

Answers (2)

Martijn van der Put
Martijn van der Put

Reputation: 4082

What you can do is create a custom Data Provider to connect to your external SQL database. This way you can expose the external data to Sitecore as if it were native data.

See When to Implement Data Providers in the Sitecore ASP.NET CMS for more information.

Upvotes: 7

Klaus Petersen
Klaus Petersen

Reputation: 301

When we implement architecture like this, we would use a search index (like solr) for maintaining state of the external database and keep enough content to display lists.

I would then request the external source for the display of an "article". Sitecore would own the web application, url and all page rendering definitions.

If you want to use DMS you might want to extend this further into having some items for referencing elements

Upvotes: 0

Related Questions