How do you find usages of entities in Integration Studio?

We are trying to find usages of entities from Integration Studio in Service Studio because we would like to delete unused entities but cannot figure out what is unused. Any suggestions?

mvp_badge
MVP
Solution

Hello Matthew,

You can use the Platform Metamodel for this. If you have direct access to the database, you can run this query to obtain all Espaces that consume Entities from Extensions:

SELECT [ossys_Espace].NAME AS ConsumerModule, PRODUCER_Name AS ProducerModule, [ossys_Espace_Reference].[NAME] AS EntityName

FROM [ossys_Espace_Reference]

INNER JOIN [ossys_Espace_Version] on CONSUMER_VERSION_ID = [ossys_Espace_Version].Id

INNER JOIN [ossys_Espace] ON [ossys_Espace].ID = [ossys_Espace_Version].Espace_Id

WHERE kind = 'Entity' and PRODUCER_KIND = 'Extension'


If you do not have direct access to the database, you can still consult the Metamodel data with this Forge component.

Champion

Hi,


You can use Service Studio "Find Usages" on the "Data" tab and choosing each entity from the module that you edit on integration studio.


Thanks

Hi Toto,

While this would normally work, we have tables with the same name in Integration Studio and Service Studio so that we can transfer data between environments, and there are hundreds of instances for each table and even more where that table is used, making this a difficult task to accomplish. On top of that, it seems that you are suggesting we find usages in every module which we have hundreds of, so this would take many hours to accomplish. If you know of any other ways to search for a specific table from Integration Studio in all modules, please let us know!

mvp_badge
MVP
Solution

Hello Matthew,

You can use the Platform Metamodel for this. If you have direct access to the database, you can run this query to obtain all Espaces that consume Entities from Extensions:

SELECT [ossys_Espace].NAME AS ConsumerModule, PRODUCER_Name AS ProducerModule, [ossys_Espace_Reference].[NAME] AS EntityName

FROM [ossys_Espace_Reference]

INNER JOIN [ossys_Espace_Version] on CONSUMER_VERSION_ID = [ossys_Espace_Version].Id

INNER JOIN [ossys_Espace] ON [ossys_Espace].ID = [ossys_Espace_Version].Espace_Id

WHERE kind = 'Entity' and PRODUCER_KIND = 'Extension'


If you do not have direct access to the database, you can still consult the Metamodel data with this Forge component.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.