In the Relational Model Data Retrieval Wizard for Oracle ODP.Net , Oracle 11.2

The server name is

SERVER:PORT/SERVICE_NAME (see image)

Is there a way to specify the Schema too? Our Database has hundreds of schemas that appear and each time we go in, it takes a while to find it.

Ian

Hi Ian,

AFAIK, you can't indicate the schema on the server name. The schema selection takes place in the next step. What you could do is create a user with access only to those schemas you are interested in.

An alternative could be a tnsnames.ora file with the full connection information and then refer to the tnsname as the server. The user specified still has to have access to metadata in the oracle database tho.

PDBORA12 =   
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = windows2008r2.sd.local)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER=DEDICATED)
      (SERVICE_NAME = PDBORA12)
    )
  )

here we define the 'PDBORA12' name, and we use that as the server name which makes us able to connect to the PDB database in oracle 12c which has the schema we need.