ToDatabase pass issue

[Former Member]

Hi ,

i'm working on sap idm v 8.0

source is ECCDEV and connected through jdbc:odbc driver and destination is CUA and connected through jdbc:odbc driver  andgetting this error

JDBCHandler constructor failed connecting to DB jdbc:odbc:SMD

java.lang.Throwable: No suitable driver found for jdbc:odbc:SMD,

but for source it is not throwing error ........ SMD  is my destination db

And as said

passing LastName to BNAME then write it as %LastName% in the value column in front BNAME. Similarly you need to pass value for each attribute.I have given the values to each and every attribute

Thanks,

Anurag

[Former Member]

What Matt said, and I also thought the jdbc:odbc bridge was tossed out of java a long time ago. It's much better to use a proper jdbc driver if you need to go down the To Database pass path.

Br,

Chris

[former_member2987]

Wow, totally missed that part (jdbc:odbc), Chris.  You're still sharp man!

Matt

[Former Member]

Hi,

Thanks Matt and yes I agree on that however I was trying out to pick from a flat file and write to SAP and get info from SAP into a file. So I was trying to see if I can write to the database directly to get a hang of the write and read passes and the SAP database. Do you think this is redundant and I can get all the info from the framework ?

Thanks

Anurag

[former_member2987]

Hi, Anurag,

If you want to do that, use a FromASCII instead.

And yes, it is preferable to use the framework when you are dealing with a SAP System.

Matt

[Former Member]

Hi  Matt,

Then to connect to the framework ToDATABASE pass will work or not ???

If no , then how to connect to the framework and which pass can be used???

If you have any pdf or any demo would be helpful...

Thanks,

Anurag

[former_member2987]

Hi Anurag,

Take a look here:

There are several documents about using the PF.  Even if they seem "off topic" (e.g., GRC) take a look since they will help explain the philosophy and design of the Framework.

I'd also recommend attending a SAP Training Class if at all possible.

BR,

Matt

[former_member2987]

Anurag,

Why are you connecting to ECCDEV via database and not using the framework?

That's probably your biggest issue at the moment.

Thanks,

Matt