How to Connect to Episerver Content Datasource?

Owned by Sergey Yuryev(gmail)
Last updated: Aug 27, 2020 by Support Ilangl
2 min read

To find our more about establishing connection to data source, please check How to connect to Content Data-source?

Episerver MS SQL Connection

This connection is a primary connection to export/import content. iLangL Cloud is using this string to connect directly to Microsoft SQL Server database.  

The process requires connection between Ms SQL server, where Episerver database is hosted, and iLangl Cloud server.

To find our more about connection to SQL server over the Internet, please read a dedicated article: Connecting to SQL Server over the Internet

And watch a video:

Parameters:

  • Server(Required) - a name or a network address of an SQL Server instance you are connecting to;
  • Port(Optional) - a server port that will be added to a server name 'Server':'Port';
  • User Id(Required) - an SQL Server login account;
  • Password(not always required *) - a password for the SQL Server account;
  • Database(Required) - a database name;
  • Table prefix(Optional) - the database table prefix for your CMS installation (usually empty for EpiServer);

*

In case of Integrated security on customer's side, it is possible to establish connection without password via Local connection


Here is what the final connection string generated to Content Provider will look like:

Server=[Server]:[Port];Database=[Database];Uid=[User Id];Pwd=[Password];

Episerver HTTP Connection

iLangL Cloud imports content to EpiServer CMS via MS SQL database connection. Episerver uses content cache to optimize server workload and increase performance.

When content is imported directly to a database, Episerver web application doesn't know about this operation and therefore, keeps old content cached.

In order to refresh this cache, you have to set up 'Episerver HTTP Connection' using an Episerver user account that has permissions to install plugins.

Once system finishes content import, it logs in with the account specified in 'Episerver HTTP Connection' and resets cache.

This will ensure that content changes are visible right after import.

Parameters:

  • Server(Required) - web URL of a website (for example company.com);
  • Port(Optional) - website port (for example: if Port = 80, requests will be sent to http://company.com:80);
  • User Id(Required) -  EpiServer account name;
  • Password(Required) - EpiServer account password.

All other parameters will be ignored for an 'EpiServer HTTP Connection'.