-
Hi all..
-
I have a question regarding using BCS with Secure Store Service.
-
I have created a custom BCS which is fetching data from Oracle database. The credentials for connecting data is being maintained at Secure store Service. To connect to this service, I have added custom properties to my ILOBsystem . I have also referenced IContextProperty.
-
Basically I have implemented my code exactly according to the given linkhttp://www.ashokraja.me/post/BCS-and-Secure-Store-Service-with-Visual-Studio.aspx. But I am getting null value for ILobsystem Current connection. Hence it is unable to access the newly added custom properties of the BCS.
I have done this for SQL Server data source not Oracle through SP Designer. i created one SS service for BCS in CA and create one view related to data in SQL Server. Brought all data through ECT from SP Designer as SP LIst and filter that particular list further through REST API, JSOM as per our business requirement but don’t think it will will work in ur case as u hv ORACLE DB . For connection only three option in connection string available in SP Designer.
1. NET Type
2. sql server
3.WCF service
