• Replies 2 replies
  • Subscribers 95 subscribers
  • Views 287 views
  • Users 0 members are here
Options
Related

Connecting to Native Databases (Oracle database) through Database Systems Integration Module

dnyandev garad extern
1 month ago

Hi All,

I want to connect different oracle database to OIM system using Database Systems Integration Module.

We have one host and on that host there are 10 different databases.

in this case do I have to create 10 synchronization projects or is it posible to just create one synch and mamage all 10 databases using one synchronization project.

I went through documentation and did not find any details.

Kind Regards,

Dnyandev

Parents
  • 1 month ago

    We've done it with Oracle and ADO.net. We have one sync project to handle different databases on one server. 

    It works with Active Directory too . For AD we have a single sync project to handle several domains and servers.

    So I guess it will be the same for DSI. The key here is using variable sets in your sync project.

    1. In Manager create the different databases.
    2. Now in Sync Editor,  create a sync project and connect to your database and one of the instances, and check the variables that are created automatically. Now create different variable sets for the other instances : Each database will have its own variable set with a different CP_service_name (the different instances) while keeping the same CP_server and credentials. Finally use Base Objects to map the databases you created in Manager (UNSRootB) to the corresponding variable set.

    Check the documentation for your version, both for sync basics and for your connector. It is not explicitly detailed but it will help your understand the whole procedure once on the right path.

    Regards.

Reply
  • 1 month ago

    We've done it with Oracle and ADO.net. We have one sync project to handle different databases on one server. 

    It works with Active Directory too . For AD we have a single sync project to handle several domains and servers.

    So I guess it will be the same for DSI. The key here is using variable sets in your sync project.

    1. In Manager create the different databases.
    2. Now in Sync Editor,  create a sync project and connect to your database and one of the instances, and check the variables that are created automatically. Now create different variable sets for the other instances : Each database will have its own variable set with a different CP_service_name (the different instances) while keeping the same CP_server and credentials. Finally use Base Objects to map the databases you created in Manager (UNSRootB) to the corresponding variable set.

    Check the documentation for your version, both for sync basics and for your connector. It is not explicitly detailed but it will help your understand the whole procedure once on the right path.

    Regards.

Children