Sunday, December 23, 2012

Importing Very Simple BDC Model

1)Create a SQL table in Sql DB 
2)Create New  External Content Type in SPD with SQL connection  with User's Identity as Authentication mode.
3)Create required operation like read, write for Table Created in SQL
4)In CA,In Secure Store Service , Create Target application which maps the Credentials for External Content Type (If necessary)
5)In BCS Service Application, Set the required permissions for External Content Type
6)Create The External List With this Content Type
When You browse the list , you come across to this exception
“Login failed for user “NT AUTHORITY\ANONYMOUS LOGON” while browsing to external list.”
To avoid this enable RevertToSelf Authentication Mode as described here
Now ,Set the Authentication Mode to BDC Identity.
7)Save the ECT and export this Model

8)Edit the .bdcm file and modify it according to production server as follows.Save  this file and Import this model in  Production server CA
 <LobSystemInstance Name="UserInfocon">
            <Property Name="ShowInSearchUI" Type="System.String"></Property>
            <Property Name="AuthenticationMode" Type="System.String">RevertToSelf</Property>
            <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
            <Property Name="RdbConnection Data Source" Type="System.String">ProdServer</Property>
            <Property Name="RdbConnection Initial Catalog" Type="System.String">DataBaseName</Property>
            <Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>
            <Property Name="RdbConnection Pooling" Type="System.String">true</Property>

No comments: