Skip to Content
avatar image
Former Member

Oracle Connection to BODS

Hi All,

I need to establish a connection from BODS to Oracle 11g.

Client has given the following details:

IP Address

PORT

Service Name

TNSNAME

User id and Pwd

My question is : Do i need to have Oracle Client installed on my Development System

What are the steps needed for connection from BODS to Oracle Client. Please let me know.

Thanks,

A Sustainer

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 17, 2015 at 01:34 PM

    Hi

    1. You need to install 32 bit Oracle 11 G R2 client on the Windows client
    2. Place the tnsnames.ora under the ORACLE_HOME/network/admin/ folder.
    3. Add the oracle installation location  under the ORA_HOME and environment variables like PATH and classpath
    4. Make sure you are able to tnsping the oracle instance using command in command prompt

              tnsping service_name

       5. Create a new datastore in the DS designer and point to the native Oracle driver using Database type.


       6. Also make sure that you are able to telnet the port on which oracle is listening

    Regards

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2015 at 12:48 PM

    Hi,

    Check this

    Arun

    Add comment
    10|10000 characters needed characters exceeded