JDBC over File

[Former Member]

Hi Experts,

I have a Database as a target system. The client is willing to use file adapter as they experienced data loss previously. How can i convince my client to go for JDBC adapter over file adpater??

Please help!!

[Former Member]

An alternative for you, if the client is not redy to let you touch thier DB main tables then ask them to create staging/intermediate tables in thier database. A PL/SQL program will validate this staging table and if its fine then update the main DB tables accordingly else can raise alerts or error logs at the client systems.

[Former Member]

Well....

I think that JDBC is better in performance and monitoring function. You can split the receiver interface in 2 different receivers: one to JDBC and one to File Backup (to prevent data loss).

File transfert is an obsolete way to solve an integration problem imho...

[udo_martens]

Hi,

you can send jdbc synchronous: A sender client will always get directly back the status of data base operation. Any failure in the proccess chain leads to an error at the sender.

Writing files is always aysnchronous. It is more difficult to watch the involved modules like sender, sender adapter, integration enginge, file adapter...

Regards,

Udo