locked
How to connect to an Oracle database with SharePoint 2013 RRS feed

  • Question

  • Hi,

    I want to connect to an Oracle database as an external content type in Sharepoint Designer 2013. Is there any tool to perform this connection?

    Thanks for any help.

    Friday, May 29, 2015 4:12 PM

Answers

  • Hi,

    To access external data, you or an administrator must do the following, please follow the below steps.

    Prepare the external data source    An administrator may need to create an account and provide permissions to the data source to ensure that the right people have access to the data and that the data does not end up in the wrong hands. In an external database, the administrator may also want to create specific tables, views, queries, and so on to limit the results to just what is needed and to help improve performance.

    Configure SharePoint services and accounts    An administrator must activate Business Data Connectivity Services and Secure Store Service.

    Configure Secure Store Services    An administrator must do the following: determine the best access mode for the external data source, create a target application, and set the credentials for the target application.

    Configure Business Data Connectivity Services    An administrator must ensure that the user who creates the external content type has permission to the Business Data Connectivity metadata store and that appropriate users have access to the external content type that the external list is based on.

    Create an external content type    A user must define an external content type which contains information about connections, access, methods of operation, columns, filters, and other metadata used to retrieve the data from the external data source.

    Out of the box SharePoint designer does not support building External Content Type against Oracle database you will either have to build the model by hand here is the example see below

    https://msdn.microsoft.com/en-us/library/ff464424(v=office.14).aspx

    Or you can use BCS Meta man tool see here http://lightningtools.com/products/bcs-meta-man/

    https://social.msdn.microsoft.com/Forums/en-US/53c9d776-6d68-4456-9e85-a8eeae618b77/sharepoint-2010-connect-to-oracle-11g?forum=sharepointgeneralprevious


    Krishana Kumar http://www.mosstechnet-kk.com
    Please mark the replies and Proposed as answer if they help and solve your issue


    Friday, May 29, 2015 7:18 PM
  • Hi Yousssefff,

    Take a look at this recent article I have posted on TechNet Wiki. 

    http://social.technet.microsoft.com/wiki/contents/articles/30946.sharepoint-2013-external-list-from-oracle-database.aspx

    Hope this helps!


    Daniel Christian (MCTS)

    • Marked as answer by Victoria Xia Sunday, June 7, 2015 2:08 PM
    Saturday, May 30, 2015 7:21 PM

All replies

  • Hi,

    To access external data, you or an administrator must do the following, please follow the below steps.

    Prepare the external data source    An administrator may need to create an account and provide permissions to the data source to ensure that the right people have access to the data and that the data does not end up in the wrong hands. In an external database, the administrator may also want to create specific tables, views, queries, and so on to limit the results to just what is needed and to help improve performance.

    Configure SharePoint services and accounts    An administrator must activate Business Data Connectivity Services and Secure Store Service.

    Configure Secure Store Services    An administrator must do the following: determine the best access mode for the external data source, create a target application, and set the credentials for the target application.

    Configure Business Data Connectivity Services    An administrator must ensure that the user who creates the external content type has permission to the Business Data Connectivity metadata store and that appropriate users have access to the external content type that the external list is based on.

    Create an external content type    A user must define an external content type which contains information about connections, access, methods of operation, columns, filters, and other metadata used to retrieve the data from the external data source.

    Out of the box SharePoint designer does not support building External Content Type against Oracle database you will either have to build the model by hand here is the example see below

    https://msdn.microsoft.com/en-us/library/ff464424(v=office.14).aspx

    Or you can use BCS Meta man tool see here http://lightningtools.com/products/bcs-meta-man/

    https://social.msdn.microsoft.com/Forums/en-US/53c9d776-6d68-4456-9e85-a8eeae618b77/sharepoint-2010-connect-to-oracle-11g?forum=sharepointgeneralprevious


    Krishana Kumar http://www.mosstechnet-kk.com
    Please mark the replies and Proposed as answer if they help and solve your issue


    Friday, May 29, 2015 7:18 PM
  • Hi Yousssefff,

    Take a look at this recent article I have posted on TechNet Wiki. 

    http://social.technet.microsoft.com/wiki/contents/articles/30946.sharepoint-2013-external-list-from-oracle-database.aspx

    Hope this helps!


    Daniel Christian (MCTS)

    • Marked as answer by Victoria Xia Sunday, June 7, 2015 2:08 PM
    Saturday, May 30, 2015 7:21 PM