jarivaahtera Absent Member.
Absent Member.
797 views

Collecting data from multiple Databases with one Collector

I found this thread from 2015 which stated that you can't have multiple JDBC event sources in a single collector but is that still the case?

The post i'm referring to is here:
DB2-Connector-two-or-more-event-soruces

In the end is this text:

you are complete right: offset is stored in the collector not in the
event source.
Engineering will open an bug/enhancement log.


So the question is that is the bug/enhancement fixed?

We are using JDBC collector to collect Audit logs from Oracle databases and there will be dozens of event sources so it's not very convenient to generate separate collector for each one of them.
0 Likes
2 Replies
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: Collecting data from multiple Databases with one Collector

I have not heard of a change to that; it is best to just have multiple
collectors.

A new option now MAY be to see what comes from the HPE merger/acquisition
by Micro Focus. Some things we know are coming include functionality from
ArcSight; if they had a way to query multiple tables at the same time
across databases then that may eventually make it into Sentinel.

Otherwise you could potentially use the REST API to setup multiple event
sources quickly so you are not needing to do so manually. That may not
save you much time in the long run, but it may provide a lot of confidence
in consistency across many things because they are created via code.

--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
Highlighted
brandon-langley Absent Member.
Absent Member.

Re: Collecting data from multiple Databases with one Collect

jarivaahtera;2475860 wrote:
I found this thread from 2015 which stated that you can't have multiple JDBC event sources in a single collector but is that still the case?

The post i'm referring to is here:
DB2-Connector-two-or-more-event-soruces

In the end is this text:



So the question is that is the bug/enhancement fixed?

We are using JDBC collector to collect Audit logs from Oracle databases and there will be dozens of event sources so it's not very convenient to generate separate collector for each one of them.


FYI, https://forums.novell.com/showthread.php/490915-DB2-Connector-two-or-more-event-soruces?p=2478406#post2478406

Short answer: This will not be a problem for much longer.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.