Multiple DB connectors to the same DB

Which IIQ version are you inquiring about?

8.3

Share all details about your problem, including any error messages you may have received.

I have multiple applications that use the same DB for auth-authz. In this DB, we have a different users table for each application.

In our IIQ, we created multiple DB connectors for that DB with different queries (each query accesses a different table, representing an application).

When running aggregation on these connectors, does IIQ know to send the queries to the DB individually, or does it send all of them simultaneously (which jeopardizes the DB due to overload)?

Hi @liza_s , IIQ wont hit the DB For aggregation sequentially until you define it .
If you run all the aggregation in same time , It will hit simultaneously .

What you can do , Create a Sequential Task and add your DB Aggregation Task in to it . And then schedule the sequential task . What it will do , It will run the aggregation one by one . which will not impact the DB Performance .