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_member2987]

Pradeep.

This usually means that you have not set one of the parameters correctly.  Please check again against the instructions you were given (assume you're looking from a tutorial) and try again.

Also try using sqljdbc4.jar.

Otherwise, please post your configuration.

Matt

[former_member2987]

Pradeep,

I've set this up as a simple VDS configuration to set this up.  DM me if you want me to send this to you.

Matt

[Former Member]

Hi Matt

We tried using the sqljdbc4.jar file but still it does not work.Please send us your configurations for us to cross check.Also let us know what all our configurations screenshot you need from our end and I will send the same.

I am attaching few of them as per my understanding.

Regards

Pradeep

[Former Member]

Hi Matt

I extracted your file and tried using it but still the same issue.As the classpath is still the one we have  put there.

Please help me in resolving the issue.

Or Guide me how to resolve this issue using your file.

Regards

Pradeep

[former_member2987]

Pradeep,

Please share with us your JDBC connection string.

Thanks,

Matt

[Former Member]

Hi Matt

Please find the string as given below:

jdbc:sqlserver://GYANMDM:1433;databasename=mxmc_db;user=mxmc_rt;password={DES3CBC}1:471390ed31213eb0-c1fba6f8edb848198643f98991ab183d;

Regards

Pradeep