SharePoint - Can we use oracle database along with sharepoint

Asked By vijay
06-Apr-11 02:24 AM
Hi Experts,

Can we use oracle database along with sharepoint, if not
please suggest other way round (except using sql server).

Thanks
vijay
  Riley K replied to vijay
06-Apr-11 02:34 AM
You can connect to different types of datasources with SharePoint

see teh below link it show how to connect

http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-database-as-a-data-source-HA010100908.aspx
  Reena Jain replied to vijay
06-Apr-11 02:37 AM
hi vijay

Using BDC(business Data Catalog) webpart  sharpoint can be connect to the Oracle database.

here are some link on this

http://knowledgemanagement.ittoolbox.com/groups/technical-functional/sharepoint-l/re-connect-with-the-oracle-database-using-the-data-view-web-part-in-sharepoint-2007-2104148
http://forums.msdn.microsoft.com/en-US/sharepointcustomization/thread/f2b97973-59db-4484-9c0b-42d3b54161d7/

Hope this will help you
  Anoop S replied to vijay
06-Apr-11 03:39 AM

I think you can do it in 2 steps. First import required Oracle DB to sharepoint list. second use DataView WebPart to connect SharePoint List to OracleDB List.

chek the following link.

http://lightningtools.com/blog/archive/2010/03/04/how-to-connect-sharepoint-bdc-to-oracle-through-tns.aspx

in addition to that

If you are trying to connect to Oracle from 64bit application (for example SharePoint 2010) you should have installed: Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) (it can be found here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html )

If you are trying to connect to Oracle from 32bit application (for example VisualStudio 2010) you should have installed: Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit) (it can be found here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html )

Please ensure you select the 'Administrator' type of installation when you install Oracle clients.

Create New Account
help
MS Access and SharePoint SharePoint Is MS SharePoint a substitute for creating rational databases MS Access. SharePoint Discussions SQL Server (1) MySQL (1) SharePoint 2010 (1) SharePoint (1) Access 2010 (1) Access 2007 (1) Python (1) Oracle (1) Hello Jody, Absolutely not. I assume "rational
external data from oracle to sharepoint 2010 list hi friends i want to fetch external data (from oracle table) to SharePoint 2010 list. please explain how to do? i have tried bdc metaman and its trial period please tell any other method. regards M c jayanarayan It is possible to download the Oracle Data provider for .NET from Oracle web site : http: / / www.oracle.com / technetwork / topics / dotnet / index-085163.html . Using this provider
SharePoint 2010 Using External List How to create External Content Type and External List based on that content type in SharePoint 2010. We will use SharePoint Designer 2010 to do most of the work. External list is the new list type provided in the release of SharePoint 2010. In previous version of SharePoint i.e. 2007, we were using Business Data Catalog to
Access 2010 with Sharepoint 2010 DataBase I found this article http: / / sharepointproconnections.com / Articles / tabid / 149 / nodeid / 1996 / SharePoint-Wish-List- -Does-SharePoint-2010-Deliver-.aspx Of key interest to me was these two points: client." Hopefully this means you can test out the Access 2010 in a browser capabilities. 2.0 AA compliance. Level 1 browsers, which support 100 percent and behavior." Bob Access Discussions SQL Server (1) MySQL (1) Visual Basic for Applications (1) SharePoint (1) Access 2007 (1) Access 2010 (1) Office 2003 (1) Windows 7 (1) Well, the
Access 2007 2GB Limit- -Sharepoint 2010 integration I am using sharepoint 2010, and access 2007 (not permitted to upgrade to 2010 yet by employer). I want to include file attachments as an option for a user limit, and how quickly. I was thinking that because they are in a back end (sharepoint), that the file size will apply to the backend, not the front end. Sorry for attachments on the Access side. You can get attachments and its size from list with sharepoint object model. By below code and load in sharepoint page (user controls), developer can do that. 1- add asp:label in design mode. 2