SharePoint 2013:BCS Connect To Oracle DB No Code

SharePoint 2013:BCS Connect To Oracle DB No Code

On SharePoint

There are many posts describes how to connect to Oracle DB database using .NET assembly Type of BCS, it requires writing codes and install the Oracle Client or OLEDB on every App and WFE server. I was going through the same road when it hits me , I can use Database Link to connect to the remote oracle table by installing OLEDB client on the SQL server only. Afterwards, I can easily create the BCS model by using SharePoint Designer. To create Database link use the below link http://blogs.msdn.com/b/dbrowne/archive/2013/10/02/creating-a-linked-server-for-oracle-in-64bit-sql-server.aspx After...

SharePoint 2013 Managed Properties not automatically created

SharePoint 2013 Managed Properties not automatically created

On SharePoint

According to TechNet article at http://technet.microsoft.com/en-us/library/jj613136(v=office.15).aspx SharePoint 2013 automatically generated crawled and managed properties given that the site column will have information stored and a full crawling has been completed successfully. However, I encountered a case in which the Search service application failed to managed properties and create a invalid crawled properties. In my custom site columns definition elements.xml file...