• Call stored procedure with ODBC parameters in Sync Editor

    Hello community,

    I have a problem with calling the stored procedure. I read data from the view of a DB2 database and to insert or update properties into the target system from One Identity side I need to call some stored procedures. I am getting the following…

  • Synchronization Editor: Test connection failure after import sync project

    Hello!

    1IM 8.1 (2019-01-21-108).

    I have imported Native Database sync project to PostgreSQL database (via .projshell file)

    When I click Test button (In Target System) for check connection to the PostgreSQL database see error: "Data source name not found…

  • How to return a value in ADO.net script

    Hi,

    I am working on version 8.1.3. I am calling stored procedures through ADO.net connector and used the sample template provided in synchronization project to write a script. I am able to create the user in the target but unable to return the UserID…

  • Ho to read data from IEnumerable<CommitRecords>?

    Hi, I am working on ADO.net connector in version 8.1.3. We need to write our own code to push the data to target system and I noticed that we et the user data in IEnumerable<CommitRecords> when we write our own Multiprocessing steps script. Please help…

  • ObjectGUID in 1IM not update after provisionning to Target System

    Hello!

    1IM 8.1

    I created Sync Project Native database connector to PostgreSQL DB.

    I created mappings 1IM <-> PostgreSQL.

    Roles created in PostgreSQL correct. But ObjectGUID in 1IM UNSAccountB not update after provisionning.

    Force mapping against…

  • Unable to browse SAP HANA target system frok one Identity manager

    Hello,

    I am using one Identity manager 8.1.3. I am not able to create users in SAP HANA target system. I have used OOTB SAP HANA native database connector. If I define data operation on sys.users Insert method, it allows me to create a user but throws…

  • Getting an error "No suitable key found for reloading" for SAP HANA target system

    Hello,

    I am using One Identity version 8.1.3. I have used Native database connector to connect to SAP HANA database and had to declare primary key for SYS.Users schema in SAP HANA database. I could uccessfully establish the connectivity and could create…

  • Unable to connect to SQL database in Native Database Connector using Active directory password

    Hi,

    We are working on version 8.1.3. We are trying to connect to SQL database using Native Database connector and we have Active Directory credentials but we are not able to connect to it. Credentials are correct and we have selected Active Directory…

  • Need to understand the traffic generation from AD connector and Native Database connector

    Hello,

    We are using version 8.1.3 and we are using AD connector and Native Database connector which has connectivity with One IM database via Application Server. This is our QA environment and there is no major activity going on between One IM database…

  • Native DB Connector for DB2 - [2415001] Invalid reference target

    I am getting the error "VI.Base.ViException: Invalid reference target (USERACCOUNT.USERACCOUNT_ID)! The target must be unique." after defining foreign key references in the Native DB connector for DB2.

     

    The 1IM environment is version 7.1.1. 

  • How do i set null values into an Integer column in the native database connector

    Hi All,

    Version: 7.1.1

    I am using the Native Database connector for DB2 and am trying to synchronise a NULL value into an Integer column in a DB2 database. 

    Any ideas on how to do this?

    Everything I've tried has resulted in the connector attempting to set…