VDS Installation/ canu00B4t set the scope on a table

[Former Member]

Hi,

during the installation of the VDS (http://help.sap.com/saphelp_nwidmvds71/en/mvd.htm)

"Maintaining data sources --> Configuring a data source --> Configuring the database parameters --> Scope"

i can´t set the scope of any table which are displayed when i push the button "get database". Why it happend?

The connection to the database was successful i use the user mxmc_rt to connect to the Database:

Logfile:

Registering driver:oracle.jdbc.driver.OracleDriver

Trying to connect...

Success!

Database URL: jdbc:oracle:thin:mxmc_rt/C3l5ZXVpYnRk9;@hostname.domain.de:1521:IDM

Database user name: MXMC_RT

Database product name: Oracle

Database product version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Database major version: 10

Database minor version: 2

Database driver name: Oracle JDBC driver

Database driver version: 10.2.0.2.0

Database driver major version: 10

Database driver minor version: 2

JDBC major version: 10

JDBC minor version: 2

Database driver class: com.sap.idm.vds.gui.tools.JDBCShimDriver

Database driver class (shimmed): oracle.jdbc.driver.OracleDriver

Database driver file: E:/oracle/I03/102/jdbc/lib/ojdbc14.jar

-

-

---

appreciate for any help

Andreas

[Former Member · Accepted solution]

Andreas,

You need to be careful here. If you are attaching to the NW IdM Identity Store, do not specify a tablename. It is preconfigured into the VDS connector.

Matt

[Former Member]

By writing the Tablename manual in the scope field, accessing the data is possible