SolarWinds ServiceGraph Connector: Multiple Instances

[rahulyamgar]

Hello friends,

We are working with the SolarWinds ServiceGraph connector in which we are pointing the instance to the single SolarWinds instance and was able to get the data populated in CMDB in the small setup.

SolarWinds ServiceGraph Connector constituents below things in standard single setup:

a. Connection alias (connection details + credentials)
b. Scheduled Data Import
c. Data Sources
d. Flow to fetch the data and populate the staging table

So, we want to have data populated from the multiple SolarWinds instances into CMDB but do not want to duplicate data sources creation instead want to feed the connection details as input to the standard data source from the scheduled data imports which would feed the same to the Data Stream Action to pull the data dynamically from the various SolarWinds targets.

Anyone tried. Any leads? 

Thanks in advance,

R

[Ratnakar7]

Hi @rahulyamgar ,

Yes, it is possible to configure the SolarWinds ServiceGraph connector to fetch data from multiple SolarWinds instances. Here are the steps you can follow:

1. Create multiple connection aliases, each representing a connection to a different SolarWinds instance. For example, if you have three SolarWinds instances, create three connection aliases with their respective connection details and credentials.

2. Create a single data source that represents the data you want to fetch from all the SolarWinds instances. You can define the data source schema to include columns that differentiate the data fetched from each instance. For example, you can add a column to the data source schema that specifies the SolarWinds instance name.

3. Create scheduled data imports that use the connection aliases to fetch data from each SolarWinds instance. You can configure the scheduled data imports to fetch data from the same data source.

4. In the data stream action that fetches the data from the SolarWinds instances, use a condition to filter the data based on the connection alias used to fetch the data. For example, you can use the SolarWinds instance name column in the data source to filter the data.

5. Run the scheduled data imports to fetch data from all the SolarWinds instances and populate the data into the same data source. The data stream action will fetch the data dynamically based on the connection alias used to fetch the data.

Thanks,

Ratnakar

[rahulyamgar]

Thanks @Ratnakar7 for the detailed answer. 

However, i have followup questions as below:

1. Yes, we could create multiple connection aliases. But how do we configure the single data source to accept multiple connections/connection aliases. and how do we pass the connection aliases dynamically to the Data Source from the scheduled import.

2. Our data sources are triggered from the scheduled data import, how do we pass the connection aliases to the data sources as an input so that data would be fetched from the multiple SolarWinds instances.

Thanks,
Rahul

[MatinDe]

Hello Rahul,

Were you able to configure the single data source to accept multiple connections/connection aliases?

I am having the same concern as yours. 

Kindly share how you made it worked.

Thanks

MaTinDe