Skip to Content
0
Former Member
Apr 05, 2013 at 01:25 PM

JDBC adapter - Technical settings

26 Views

Hi,

We have a scenario where we need to send all the packing information to the conveyor system which is SQL server2008. The frequency would be close to 10-15 seconds.

1. Does JDBC recommended approach for this or do i need to consider other factors like FTP etc?

2. If we can use JDBC, what would be the effective design methodology for this, i.e staging table, stored procedures, directly writing into DB etc.,

Regards

Anandh