Connector for non-SAP applications

[Former Member]

Hi Folks,

We are implementing SAP IDM integration with non-SAP applications. The non-sap application is having Oracle as its database.

We have made a job in IDM (from Database pass).

• This pass has a query to fetch details from the application.
• We tried using both drivers (Oracle oci8 and Oracle thin driver).
• The job is unable to fetch any data.

When running this pass, we are successfully able to connect to non-sap app. and the job is running without any errors, BUT NO DATA IS GETTING FETCHED.

When we are running same query using Oracle client, it is able to fetch data successfully and showing in Oracle cilent.

So could you please advice as to why SAP IDM is unable to fetch any data.

• Are there any configuration changes that needs to be made?
• What could be the possible issues?
• Am I using the wrong connector ?

Versions :

SAP IDM  -  7.2 SP9

Please give your valuable suggestions.

Thanks in advance.

Shanky Agrawal

[Former Member · Accepted solution]

Thank you guys.. I was able to resolve the issue. There was some issue with the query I was trying to execute

[former_member2987 · Accepted solution]

Ok, please make sure that you mark this as closed, if you can also share what your original query was and the correct query, that would be helpful too!

Matt

[Former Member · Accepted solution]

Hi Matt,

In the above screenshot, the Destination tab contained the parameters as %resource_id%. It should have been provided without % %.

After removal of this, it was working properly.

Also, if you  could please reply to the other threads,

and

It would be of great help.

Thanks,

Shanky Agrawal

[terovirta]

Hello,

are there any error message in the job log?

There must be something in the log if your IdM is up and running, the job/pass is enabled and has dispatchers assigned.

regards, Tero

[former_member2987]

Hi there,

Can you please post some screen shots of your job?  That will help us to troubleshoot.  Here's a few questions that might also help us as well.

What database is IDM using?

Is the database on a different server?

Can you ping that server from the IDM server?

Could there be a firewall or permissions issue?

Matt

[Former Member]

Hi Matt,

I have attached the screenshots below of "From Database"pass which we are using for connection with non-SAP.

The connection is working fine, as on IDM server we are having Oracle client and we are able to connect and fetch entries from non-sap application into the Oracle client.

When we are making the same connection from SAP IDM, we are able to connect successfully to non-SAP but not able to fetch any data.

Please find the answers to the above questions below :

IDM database : Oracle 11gR2

Yes, the database is on a different server.

We are able to successfully ping that server from IDM server.

We dont think any firewall issue is present.

Thanks in advance.

Warm Regards,

Shanky

[former_member2987]

So you're saying that TEMP_SIV is empty?

Thanks