In this tutorial we will go through how to connect to your External System using BCS Meta Man, we won’t be doing any configuration of our model, we will just be looking at the quickest way to get your External Systems data into SharePoint as easily as possible.
- SharePoint Server 2013
- BCS Meta Man (it doesn’t necessarily need to be installed on the SharePoint server but it requires .net Framework 4.5 installed on the machine where you are going to run BCS Meta Man from)
- MS SQL server with any sample database (for this walk through we are going to use the NorthWind sample database )
- To connect to SQL Server click appropriate data source item on the left pane on the initial screen.
- Enter the name of your MS SQL server and select the authentication mode in the appeared connection settings area on the right side . If you are using SQL Authentication you will also have to enter your SQL user account details. Press arrow near “database name” combo box in order to retrieve list of available databases.
- The combo box will now be populated with your database server names.
- Select one database server name and press arrow in order to connect to selected data source
- Upon successfully connecting to SQL Server you’ll see another window. In order to get a list of tables click “Tables” item in the list on the left pane.
- Now we can see listed all the tables for this particular database.
- We create an external content type by dragging and dropping a table onto our design surface which is the large area on the right side. We will be working with the “Territories” table, to add it to the model , just drag it onto the “Diagram”.
- When you drop the table you will be shown the following dialog, which allows to configure the external content type before creation. You may modify the external content type name, change identifier and add the methods to the external content type. In this example we’ll accept all default values and click “Create” button.
- You can see created external content type on the design surface with the listed methods and identifier.
- Now all we need to do is generate our application definition file. First we need to set the path to save the file. We set this location by going “Settings” from the titlebar.
- In the model file name textbox you should manually type the output file name and select model file path using the browse button. Click “Save” button.
- Once you have saved the filename and path to create your BDC model file to simply click “Generate” button and your BDC model file will get generated.
- Now we need to import our BDC model file. Open up SharePoint 2013 Central Administration. Navigate to Manage Service Application->Business Data Connectivity Service. Click “Import” button on the ribbon.
- Use the browser button to locate our BDC model file, or type in the path and filename yourself. Leave all the other options as they are for the time being, and click “Import”
- SharePoint 2013 will now go through and validate your BDC model file is correct, once it is done you will get a success page.
- Browse to the site where you want to add the External List. Click “Site Contents”->”add an app”.
- Select “External List”
- Enter a name for External list and click on the icon to show the available External Content Types
- Select our generated Northwind_MetaMan.Territories External Content Type, click “OK”
- Click “Create”
- Your external data from MS SQL database is now displayed in the SharePoint External List
We hope this walkthrough will be useful for you. If you have any questions feel free to email them to firstname.lastname@example.org