On the ribbon, in the View group, click BDC Models. On the Central Administration Web site, in the Application Management section, click Manage service applications.Ĭlick in the Name column of the row that corresponds to the Business Data Connectivity service application. To do this task, you must be a farm administrator, an administrator of the Business Data Connectivity service application, and have Edit permission on the model and on all external systems that are contained in the model. In the File Save As dialog box, browse to a location, and then click Save.īusiness Data Connectivity metadata store In the Export BDC model dialog box, enter the name of the model, and click OK.

Right-click the selection, and then click Export BDC Model. Select the external content type you want to use. On the left pane, under Site Objects, select External Content Types. In Microsoft SharePoint Designer 2013, open the SharePoint site that contains the external content type. To create a BDCM file do one of the following: Net Types are supported: System.Boolean, System.Char, System.String, System.Int32, System.Int16, System.Double, System.DateTime, System.GUID.

Only flat data structures are supported, hierarchical data structures are not. Keep in mind the following when using a BDCM file with Access 2013: Top of Page Export the BDCM file from SharePoint productsĪ BDCM file is an XML file that contains all the information defined for an external content type. In an external database, the administrator may also want to create specific tables, views, queries, and so on to limit the results to just what is needed and to help improve performance.Ĭonfigure SharePoint services and accounts An administrator must activate Business Data Connectivity Services and Secure Store Service.Ĭonfigure Secure Store Services An administrator must do the following: determine the best access mode for the external data source, create a target application, and set the credentials for the target application.Ĭonfigure Business Data Connectivity Services An administrator must ensure that the user who creates the external content type has permission to the Business Data Connectivity metadata store and that appropriate users have access to the external content type that the external list is based on.Ĭreate an external content type A user must define an external content type which contains information about connections, access, methods of operation, columns, filters, and other metadata used to retrieve the data from the external data source. Prepare the external data source An administrator may need to create an account and provide permissions to the data source to ensure that the right people have access to the data and that the data does not end up in the wrong hands. To access external data, you or an administrator must do the following: Also, if you experience problems trying to work with external data, this information can help you identify the issue. The following information can help you plan your next steps. Working with external data requires several pre-requisite tasks to enable secure access to the data. In this articleĮxport the BDCM file from SharePoint productsĬreate a linked table based on the imported BDCM file NET Framework 4.įor more information, see Find content about external data. NET Framework 4 or higher installed on your client computer.

Data set and hfs file system access