Feb 01
Making Oracle Connections from SharePoint 2007/2010

The following steps overview the process to enable connectivity from a SharePoint environment to Oracle line of business data connections.

The Oracle Oracle 11gR2 Client 32 bit "Runtime" is required for a Windows Server 2008 R2 installation.
You could optionally run the 64 bit.

SCENRIO
If an End-User requires a Business Data Connection using SharePoint to an Oracle Database then the Oracle Client will need to be installed on the Application or Web Front End (WFE) server. If a process has been designed to import data to the SQL Database then the SQL server will need the client installed.

To use the SharePoint Dashboard Designer to make data source connections you will need to install the Oracle Client on the WFE or Application server(s).

INSTALLATION PROCESS

  • Run the Oracle 11g R2 Client as an administrator
    • Right click > Run as Administrator
  • Click Yes to the User Access Control prompt

     

  • Select Runtime installation and click Next
  • Language
    • Next
  • Specify Oracle Base
    • Choose a directory other than C:\ "another LUN"
      • F:\Oracle\
    • Software Location
      • F:\Oracle\product\11.2.0\client
    • Perform Prerequisite Checks
    • Summary
      • Click Finish
    • Install Product
    • Finish
      • Click Close
  • Setup the TNS Names Files
    • Navigate to F:\Oracle\product\11.2.0\client\network\admin\
      • Open Notepad as an Administrator and open the sqlnet.ora file from F:\Oracle\product\11.2.0\client\network\admin\sqlnet.ora
        • Remove EZCONNECT from the sqlnet.ora
          • It should look like this NAMES.DIRECTORY_PATH= (TNSNAMES)
            • Save as All Files…
    • Create a new notepad file and name it TNSnames.ora and add any of the connections
      • i.e.
        (AAARN.WORLD =
        (DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = AAArn.AAA.AAAAA.edu)(PORT = 1521))
        )
        (CONNECT_DATA =
        (SID = AAARN)
        )
        )
    • Test functionality by opening command prompt and performing a tnsping to the Data source host name.
      • Tnsping AAARN
  • Use the Lightning Tools BDC Metaman to create the XML to establish the Oracle connections

REFERENCES

Then use a tool such as Lightning Tools BDC Metaman to make the Oracle connections
http://lightningtools.com/blog/archive/2010/03/04/how-to-connect-sharepoint-bdc-to-oracle-through-tns.aspx

Oracle Database Documentation Library
http://www.oracle.com/pls/db112/homepage

Comments

There are no comments for this post.

 ‭(Hidden)‬ Blog Tools