Business Connectivity Services is MUCH more than linking external data to a SharePoint list. With Business Connectivity Services, you can search your external data source via SharePoint, Build Business Data Dashboards, Use the external data to populate column values in SharePoint lists and libraries, and Create, Update and Delete data via the SharePoint external list.
BCS Meta Man is also available as a Windows Application and can create BDC Model Files for SharePoint 2010 or 2013.
Need to create an SAP External Content Type? Try our BCS Connector:
SharePoint Designer 2010 provides a no-code solution to building the External Content Type (External Data Connection) for Microsoft SQL databases. If you wish to connect to Oracle, Informix, Dbase or any other external data source, you must write code in Visual Studio. BCS Meta Man writes that code for you! All you have to do is drag the Tables, Views and Stored procedures to the design surface, set some properties, and watch the code get written by Meta Man.
Services. Using ODBC you can configure a connection to most external data sources.
Even if you are connecting to Microsoft SQL, you may want to create associations (joins between tables) that SharePoint Designer cannot handle. You will also benefit from having your External Content Type compiled as a .NET assembly which makes it easier to deploy between non-production and production environments.
Configuring the methods such as Read List, Read Item, Insert, Update and Delete is simple using BCS Meta Man. There is no need to write the code, just simple check the box to say that you want those methods.
Filters, and custom Actions are created by simply setting some External Content Type properties.
Upgrading from SharePoint 2007’s Business Data Catalog? Using BCS Meta Man, you can upgrade your old Application Definition File from Business Data Catalog and have BCS Meta Man regenerate it as a .NET Assembly.
|Feature||BCS Meta Man
||Visual Studio SharePoint Tools|
|Connect to SQL without code|
|Connect to Oracle without code|
|Connect to ODBC Data Sources without Code|
|Connect to WCF Service without Code|
|Generate .NET Assembly External Content Type|
|Build Associations Using Drag/Drop|
|Build Filters without code|
|Build Associated ECTs in one model|
|Build Custom Actions without code|