Application Builder task for JDBC applications

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.4p1

Hi

I am trying to create an application Builder Task to automate multiple JDBC applications

I have seen examples for the csv file headers and they look similar to this

application url driver username password Schemas

I wanted to confirm if we can add our own headers and also as this is JDBC application, the schema will be discovered. So do we need to provide the schemas or leave it empty
Also regarding the correlation config and the global rules, can this be added as a column header and add the correct xml names in the columns for the same

Also, has anyone tried the task and if there are any better ways to do this or any learnings they want to share

Thanks
Manisha

2

Hi @mgupta403,

Since you are working with JDBC applications, the schema can be automatically discovered. If the schema is being discovered correctly, you can leave the “Schemas” field empty in your CSV file. However, if you have specific schemas that need to be referenced, you can include them as needed.

You can add correlation configuration details as additional column headers in your CSV.
Similar to correlation configurations, global rules can also be included as column headers.

3

Hi Vinod

Thanks for the reply.

I am able to create the application without schema but its not entering anything for url, drivers or username, password.
Just an empty application of type JDBC is created

Am I missing something ?

Also for correlationConfig, I added a column like below
application,url,driver,username,password,Schemas,correlationConfig,

But that too is empty, once the task runs
There is no error but just empty JDBC apps are created

4

Can you please enable debug loggers at task level to see more details in iiq logs

5

Ran the task with loggers added and Skip Test Connection checked

Got the following error, Please see attached file

logAppBuilder.txt (36.3 KB)

Thank you

6

@vinnysail, In the error, it says
“sailpoint.connector.SchemaNotDefinedException: The schema for objectType: account is not configured for this connector”

Do I need to add the schema ? As its a JDBC connector, the schema should be discovered. So not sure what to add there

7

Hi @mgupta403,

The JDBC connector doesn’t come with a built-in schema, as it is designed to be generic and needs to be discovered. Please include the schema detail in your CSV file and run the task.

Please refert the schema attached. you can modify based on your requirement.

<Schemas>
    <Schema displayAttribute="username" identityAttribute="userid" instanceAttribute="" nativeObjectType="user" objectType="account">
      <AttributeDefinition name="username" type="string">
        <Description>User Name</Description>
      </AttributeDefinition>
	  <AttributeDefinition name="userid" type="string">
        <Description>User id</Description>
      </AttributeDefinition>
      <AttributeDefinition name="Role" type="Group">
        <Description>Role Name</Description>
      </AttributeDefinition>
</Schema>
  </Schemas>
8

Hi Arun

I tried adding the schema and it works

I do have a question for AccountCorrelationConfig though,
I tried various options but doesn’t look like it takes the config from the csv file correctly. It adds it to the attribute map in place of separate entry

Which connector is the best option if we want to use the Application Builder task ?

Thanks
Manisha

9

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.