Example 2: Materials from multiple database tables, published as one catalog
You want to publish all materials that have status 'Released' from two different databases, as one combined catalog.
How is the data organized in Granta MI?
The required materials belong to separate database tables (in different databases)
called Polymers and Metals respectively. In
both of these tables, the records have an attribute Released with
possible values 'Yes' or 'No', which can be used
to filter the required materials.
How many synchronization jobs?
To publish as a single catalog, you need to create a single synchronization job: 'All released polymers and metals'. However, the definition is structured differently than in Example 1: Publishing a catalog that contains materials from a database table, because the materials come from more than one database table.
Within each synchronization job, how do I use searches to find the materials I want?
The required materials belong to two different database tables (Polymers and Metals), so you need to define a search on each of those tables. One search per table is enough, because you only need to include one combination of attribute values (Released = 'Yes') from each table.
Hence, the synchronization job is built up from a number of searches, one for each database table. Each search has a single search criterion: Released = 'Yes'.