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

Hi Pradeep,

From your first screenshot I can see that you are not set up the score(identity store ID) you are using for the connection. You can check you Identity store ID from the IdM console(in IS stagin area - general tab). After you have set that, check all yoursettings again and try the connection.

BR,

Simona

[Former Member]

Hi Simona

Can you please guide me to find the IS staging area and the final Identity Store ID.Also I am trying to use sample HR tables available in Database schema  as my data source.So I was wondering also for sample tables is there any staging area?

Regards

Pradeep

[Former Member]

Hi Pradeep,

In the IdM console you have Identity stores and there you should fined Identity store(Staging area), after you have selected this IS in tab - general you will be able to see the ID of the IS. By default you have Identity Store ->1/Enterprise People(with ID 1), so you should fined your staging area ID there.

As for the Staging Area, this is the Identity store used for attribute mapping between the HR and IdM. Can you give more information about you scenario, because my understanding is that you have HR system and to make the connection with IdM you are using VDS.

BR,

Simona.

[Former Member]

Hi Simona

As of now we are creating a demo system for the client presentation so as per SAP's tutorial we are trying to use the HR Sample table which comes automatically in the Database Schema post installation which is called HR Sample table .We don't have any HR system as of now .So we are trying to use this HR sample Table as our datasource. But when we try to pull this table from DB Schema we are unable to and it says"Trying to Connect"

So I was wondering how to resole this .Therefore asked you do I really require to set Staging for this sample table as in the tutorial it dint showed.

Regards

Pradeep

[former_member2987]

Pradeep,

In that case, make sure scope is set to 1. Also make sure that you can ping the SQL Server instance and that there are no firewalls blocking port 1433.

Matt

[Former Member]

Hi Matt

I will try that.But it would be good if you can explain the concept of this scope in details and in future for real systems what needs to be done

Regards

Pradeep

[Former Member]

Hi Pradeep,

As Matt said, in this case you should use your default IS 1/Enterprise People(with id 1) and set the scope to 1.  After you have checked the settings make sure that you have remove and install the service again.

BR,

Simona

[Former Member]

Hi Simona

I tried putting it as 1 but still the same issue persists.Please help me in this regard.

Also I am not sure what you were pointing  about the removing and installing the service.

Pleas guide me on the same.

Regards

Pradeep

[former_member2987]

Simona brings up a good point that I did not cover.

Upon making changes make sure you are updating the configuration, either through the update button or by stopping and starting the service.

Matt

[Former Member]

Hi Pradeep,

After you have update the settings, please try this:

BR,

Simona

[Former Member]

Hi Matt/Simona

I tried doing whatever mentioned by you guys but still the same issue.Whenever I click on the button "Get the Database"  at the bottom it still shows  "Trying to Connect.." message.

Please help me to resolve this issue as I am stuck now and can't proceed further.

Regards

Pradeep