Looking for query to map the relationships between all connections/Data Source / Integrations
We have SmartConnect installed on 3 environments ( version = 22.214.171.1248)
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.
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
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
If you would like to submit an answer or comment, please sign in to the eOne portal.