Skip to content
+1-888-319-3663

COMMUNITY FORUM

Looking for query to map the relationships between all connections/Data Source / Integrations

Christian Betrisey asked 3 months ago

Hi,

We have SmartConnect installed on 3 environments ( version = 21.1.0.658)

We would like to clean those SmartConnect as we have a lot of old Integrations/Data Source/connections that we want to get rid of. In order to so, we would like to have a report that shows the relationship between Integrations/Data Source/connections e.g.

 

Connection

Data Source

Integration

C1

DS1

Int1

C1

DS2

Int2

C10

DS10

Int10

 

 

 

I was trying to write a query in SQL, but quickly realized that the sql schema is not as straight forward.

Then I searched the Internet for such a query. I did find one, but it failed for it has some schema differences (probably the query was for a version of SmartConnect < 21)

 

Can you tell me how to do that?

  • Is there a kind of report I could run?
  • If not, do you  have by any chance a sql query I could run on the smartConnect DB?

Thanks for your help

 

Christian

Christian replied 3 months ago

Sorry, the table did not show well in the message above. Basically it is

Connection | Data source | Integration
—————————————————
C1 | DS1 | Int1
C1 | DS2 | Int2
C10 | DS10 | Int10
etc


If you would like to submit an answer or comment, please sign in to the eOne portal.