Install Sana Commerce Webshop on Web and Database Server

Open 'Install Sana Commerce Webshop on Web and Database Server' wizard, choose your solution and scenario to see more provider-related information.

Configure the Providers

Configuration of providers for users of Sana Commerce - SQL Provider with interfaces is shown below:

Step 1: Open the 'web.config' file of the Sana Commerce frontend (do the same for the 'web.config' file of the Sana Commerce backoffice).

Step 2: Locate the <modules> configuration section and replace it with the one provided below:

<modules>
        <catalog defaultProvider="SanaCommerceSqlCatalogProvider">
          <providers>
            <clear />
           <add name="SanaCommerceSqlCatalogProvider" type="Sana.Commerce.Customization.Catalog.DatabaseExtendedCatalogProvider, Sana.Commerce.Sdk, Culture=neutral" description="CatalogProvider which retrieves catalog information from Sql server" serviceConnection="localSqlServer" />
           <add name="NavisionCatalogProvider" type="Sana.Commerce.Customization.Catalog.NavisionExtendedCatalogProvider, Sana.Commerce.Sdk, Culture=neutral" description="CatalogProvider which retrieves catalog information from Navision using NAS" serviceConnection="NavisionStandardService" />
     </providers>
        </catalog>
        <customer defaultProvider="SanaCommerceSqlCustomerProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlCustomerProvider" type="Sana.Commerce.Customization.Customer.DatabaseExtendedCustomerProvider, Sana.Commerce.Sdk, Culture=neutral" description="CustomerProvider which retrieves catalog information from Sql server" serviceConnection="localSqlServer" />
            <add name="NavisionCustomerProvider" type="Sana.Commerce.Customization.Customer.NavisionExtendedCustomerProvider, Sana.Commerce.Sdk, Culture=neutral" description="CustomerProvider which retrieves customer information from Navision using NAS" serviceConnection="NavisionStandardService" />
   </providers>
        </customer>
        <order defaultProvider="SanaCommerceSqlOrderProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlOrderProvider" type="Sana.Commerce.Customization.Order.DatabaseExtendedOrderProvider, Sana.Commerce.Sdk, Culture=neutral" description="OrderProvider which retrieves catalog information from Sql server" serviceConnection="LocalSqlServer" />
            <add name="NavisionOrderProvider" type="Sana.Commerce.Customization.Order.NavisionExtendedOrderProvider, Sana.Commerce.Sdk, Culture=neutral" description="OrderProvider which retrieves order information from Navision using NAS" serviceConnection="NavisionStandardService" />
   </providers>
        </order>
        <shop defaultProvider="SanaCommerceSqlShopProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlShopProvider" type="Sana.Commerce.Customization.Shop.DatabaseExtendedShopProvider, Sana.Commerce.Sdk, Culture=neutral" description="ShopProvider which retrieves shop information (baskets, ect) from SQL database" serviceConnection="LocalSqlServer" />
          </providers>
        </shop>
        <common defaultProvider="SanaCommerceSqlCommonProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlCommonProvider" type="Sana.Commerce.Customization.Common.DatabaseExtendedCommonProvider, Sana.Commerce.Sdk, Culture=neutral" description="CommonProvider which retrieves catalog information from Sql server" serviceConnection="localSqlServer" />
            <add name="NavisionCommonProvider" type="Sana.Commerce.Customization.Common.NavisionExtendedCommonProvider, Sana.Commerce.Sdk, Culture=neutral" description="CommonProvider which retrieves common information from Navision using NAS" serviceConnection="NavisionStandardService" />
   </providers>
        </common>
        <content defaultProvider="SanaCommerceSqlContentProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlContentProvider" type="Sana.Commerce.Customization.Content.DatabaseExtendedContentProvider, Sana.Commerce.Sdk, Culture=neutral" description="Content provider which retrives content information(content pages, product descriptions) from SQL DB" serviceConnection="LocalSqlServer" />
          </providers>
        </content>
</modules>