Missing Data Connection Library In SharePoint

In this article, I’m gonna to solve the below issue

Missing Data Connection Library In SharePoint


Scenario

If you are working on InfoPath or Excel Services in SharePoint, you will need to use a Data Connection Library to save your external connection files like a “udcx” file.

But sometimes, when you tried to add a new Data Connection Library, you may ىخف بهىي it in the “Add an App” Page.

Missing Data Connection Library In SharePoint


Cause

Missing Data Connection Library In SharePoint depends on the SharePoint Edition and usually occurs in case of

  1. The current SharePoint edition is
    • SharePoint Foundation or
    • SharePoint Standard.
  2. The current SharePoint edition is SharePoint Enterprise, but the SharePoint Server Enterprise Site feature is not activated.
  3. The current SharePoint edition is SharePoint Enterprise, the SharePoint Server Enterprise Site feature is already activated but you still missing Data Connection Library.

Solution

Missing Data Connection Library in SharePoint Standard & SharePoint Foundation

The Data Connection Library is not included in the SharePoint Foundation. however, you can use it on the Search Server Express that requires

  • Independent Search Server in your SharePoint foundation farm.
  • Install and Enable “DataconnectionLibrary” via Powershell as the following.
Install-SPFeature DataconnectionLibrary
Install-SPFeature DataconnectionLibraryStapling
Enable-SPFeature DataConnectionLibrary -url http://siteurl

Missing Data Connection Library in SharePoint Enterprise

Although the Data connectivity library is available in the SHarePoint Enterprise Edition, you may still don’t find it, this because of the SharePoint Server Enterprise Site feature is not activated.

Activate SharePoint Server Enterprise Site feature

  • Site Setting > Site Action > Manage Site Features.

Manage Site Features

  • Activate SharePoint Server Enterprise Site features.

activate-sharepoint-server-enterprise-site-features

  • Go back to add an app > search for data connection > The Data Connection Library should be now listed as shown below:
add-data-connection-library

Still Missing Data Connection Library in SharePoint Enterprise

Actually, it’s a rare situation, but sometimes after you have activated the SharePoint Server Enterprise Site features, you still didn’t get the Data Connection Library.

In this case, just run the below command in SharePoint Management Shell.

Install-SPFeature DataconnectionLibrary
Install-SPFeature DataconnectionLibraryStapling
Enable-SPFeature DataConnectionLibrary -url http://siteurl

Applies To
  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s