Best way to "load balance" JDBC Data Sources?

Aaron Dalton
Tera Expert

We've got ~40 JDBC data sources that are all scheduled at various times throughout the day/week/month. Lots of overlap on scheduling. We've also got LDAP setup. All of this right now is running through a single MID which doesn't seem optimal.

 

My understanding is that the MID cannot complete any other tasks while its busy performing any single JDBC or LDAP import (i.e. I can't run a JDBC load while LDAP is loading, it times out). This is what I see from testing in my environment, but is that accurate and how it "should" be?

 

Any suggestions on handling this number of imports? OOTB MID clusters don't support JDBC and LDAP, so short of adding more MIDs, I'm not sure what else can be done (if anything).

0 REPLIES 0