Not able to pull the sample HR Sample database tables from Schema

[#1]

Hi

We are trying to configure VDS for IDM 7.2 with SQL 2008.When we are configuring data-sources as sample HR table given in the db schema MXMC_DB.

For this we deployed latest JDBC driver i.e JDBC 4.0 for SQL 2008.But when we are trying to map the database sample table as data source we are not able to connect to db schema it just says "Trying to Connect"  As shown below in the screenshots.

Regards

Pradeep

[ChrisPS · Accepted solution]

Hello Pradeep,

                       if you are following the standard tutorial on accessing the HR_Sample table then the Scope field should have the value HR_Sample (see page 11 step 9) if all the steps are followed. The scope field is generally numeric as already indicated for other scenarios such as accessing the IdM Identity Store or the HCM staging area but not in this case.

Link to the tutorial http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40aa3c1a-a2da-2d10-82b5-9f1bfa541...

Regards,

Chris

[Former Member · Accepted solution]

Hi All

This issue is resolved now.We deleted all the classpath and just put the correct classpath and it worked.Thanks all for your inputs.

Regards

Pradeep