on 10-17-2015 10:36 AM
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
Hi
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
I created a odbc connection from Oracle Server (client system for test data) and from DS when I am trying to view the its taking very long time and later becoming un responsive and finally forcing the close the Data Services.
I don't have a oracle client on my dev system.
Kindly suggest.
Thanks,
,
A Sustainer
Dear Drik/Arun,
During building our Developement System, we have installed Oracle, IPS and then Data Services.
So while creating a ODBC Connection, we could able to establish a ODBC Connection, but when i am "View Data" from Data Stores tables, It is taking long time and DS is getting "AppCrash" and i am forced to close the Data Services.
So my Question is Do we need to have 1 more Oracle Client 1 more time separately and why when i doing a view data its taking a very long time and at last ending up with APP Crash.
Thanks,
A Sustainer
Hi
Better go for Oracle Native Client. You can get it installed on the Dev system and there is no need to create an odbc datastore.
Make sure you install 32 bit Oracle 11G R2 client
Oracle Database 11g Release 2 for Microsoft Windows (32-bit)
You can create a free account in oracle with your gmail id and then download it from the above link.
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.