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

[former_member190695]

Hi Pradeep,

Please post a print screen of your Identity Store to ensure the scope you entered is correct.

Further what JVM version are you using and which template did you used when creating the configuration?

If you don't get the table's from "Get database" it doesn't mean you could not retrieve the data in you IdM job as the two configuration may differ based on versions, etc..

Regards,

Ridouan

[former_member2987]

There have been some known issues with doing a get database from the Identity Store, but you should be able to do this with no problem if you are limiting the virtualization to the HR_SAMPLE table.

[Former Member]

Hi Ridouan

I have provided the Scope  number as per Matt & Simona suggestion as above.

Regards

Pradeep

[Former Member]

Hi Matt

But still it is giving the same issue don't know how to resolve this issue now 😞

Please provide your inputs on the same.

Regards

Pradeep