Video: Connect to External Data Sources and generate the External Content Type.
Within this twelve minute video, we connect to OData and Microsoft SQL, build two Entities and set the Finder, Specific Finder, Creator, Updater and Deleter methods. Limit Filter, and custom actions can also be set within the tool.
Supporting multiple data sources with BCS Meta Man for Sharepoint Business Connectivity Services enables you to connect to Microsoft SQL Server, Salesforce, Dynamics CRM, Oracle, OData, Informix, MySQL, DB2, DBase and more ODBC data sources without having to write any code. For example, simply select your data source, set your authentication options, drag the tables you wish to connect to configure your external content type. Generating the complete bdc model file takes just minutes from start to finish. Writing a bdc model file by hand will take an experienced developer at least a day and usually longer for the inexperienced.
Once you have chosen your external data source, drag the table to the design surface and begin to configure your external content type. Select your Finder, Specific Finder, ID Enumerator, Creator, Updater and Deleter methods, simply click generate, and you’re done!
Associations enable you to show your external data using Business Data Lists and Business Data Related List web parts. Your data relationships can also be shown in profile pages and also BDC item picker dialog boxes.
For instance, simply drag the association between the two external content types.
In addition, create filters, methods and custom actions in just a few clicks.
|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|