Import Metadata [message #482266] |
Wed, 10 November 2010 12:18 |
RMSoares
Messages: 46 Registered: September 2010 Location: Lisboa
|
Member |
|
|
Hi,
With Oracle BI Administration Tool we had intend to import the metadata of a schema Oracle 11g (Linux in this), we use two possible methods : ODBC and OCI 10g/11g, in both cases returns the error message "The connection has failed ".
We had validate the access to the database (with tnsping) using the TOAD we can view and executed query to the tables which we intend to import metadata, so There isn't any error in the definitions provided (DSN, Service Name, user ID and password).
In tests with ODBC we had used the driver for Oracle from Microsoft and a driver that was installed by OBIEE.
Any suggestions to validate the reason for the error? is there any ODBC driver Oracle recommend to 11g?
regards
|
|
|
|
Re: Import Metadata [message #487746 is a reply to message #487745] |
Thu, 30 December 2010 11:48 |
RMSoares
Messages: 46 Registered: September 2010 Location: Lisboa
|
Member |
|
|
Hi,
you must create the ODBC using the driver that had been created with OBIEE, and you must specified the user /password of OBIEE repository.
Put the step that are you doing to check if it correct.
Regards
|
|
|
Re: Import Metadata [message #488265 is a reply to message #487746] |
Thu, 06 January 2011 00:06 |
swapna053
Messages: 18 Registered: March 2010
|
Junior Member |
|
|
Hello,
Even i am facing the same problem.Showing connection failed.
I have connected to one user called abc_test(schema) while installing RCU.
So there (schema)in the "other users" i saw the dev_biplatform and dev_mds being created.
First i have just installed obiee on my machine.
Just was reading so got to know need to create a repository.
So went to obiee->Administartion tool->New Repository->ocl 10g/11g->but there i saw need data source name and un and pwd.
So i went to odbc->select driver oracle 11g bi->created a data source called ds.
Now again to adminstartion tool->New Repository->ocl 10g/11g->gave ds as data source name and gave dev_biplatform as un and then pwd, but showing connection failed??????
then in the un and pwd i tried with un as test_schema and pwd but that also failed.
What need to be eneterd in data source name,us and pwd?????
Aim is to connect to test_schema schema so that i can use select query to generate reports inside obiee.
please help.
Thanks
|
|
|
|
Re: Import Metadata [message #489167 is a reply to message #488389] |
Thu, 13 January 2011 10:48 |
skooman
Messages: 913 Registered: March 2005 Location: Netherlands
|
Senior Member |
|
|
Please note that (at least with OBIEE 10g) the repository and bi server use the tns names file (and Oracle connect software) on the server where it's located. While you are editing the rpd, most likely on your desktop on Windows or so, it's using the tns names file etc from your desktop!
So, it could be that one of the two is not correct. Best test is to ping from a command line, both on your desktop as well as the server.
|
|
|
|