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.
Multiple data sources are supported with Meta Man enabling you to connect to Microsoft SQL Server, Oracle, OData, Informix, MySQL, DB2, DBase and more ODBC data sources without having to write any code. Simply select your data source, set your authentication options, drag the tables you wish to connect to and configure your external content type. The complete bdc model file is generated from start to finish in just a few minutes. Writing a bdc model file by hand will take an experienced developer at least a day and longer for the inexperienced.
Once you have chosen your external data source, simply 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, 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.
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|